Unable to import Oracle Clob using tSqoopImport with Java API mode

[Anonymous]

Hello,

I have a Talend Bigdata Standard job, that uses tSqoopImport component with "Java API" mode to import data from Oracle into a Parquet file. It works fine except when I have to import a CLOB column. I am using a query against the source table. I have tried to manually Define the Java Mapping in Advanced properties with no luck.

Define Java Mappng

 FYI, the CLOB column name's case exactly matches (it's all upper case).

I have also tried defining under the "Additional Arguments" section and had no luck as well.

Additional Arguments

The error I get is "[ERROR]: org.apache.sqoop.tool.ImportTool - Import failed: Cannot convert SQL type 2005"

It seems to me like a Talend bug. Already spent over 4 hrs on trying several options and giving up on it. Any help would be appreciated. 

Thanks

Pradeep.

[Anonymous · Accepted solution]

Solution provided by Talend Support:

In the above scenario, the syntax for Argument and Value must be as below.

Argument Name: "map.column.java.JOBDTL_EXTINFO"
Value = "String"

[Anonymous]

Hello,

Thanks for sharing the solution on forum.

Best regards

Sabrina