topic Re: Unable to import Oracle Clob using tSqoopImport with Java API mode in Talend Studio

Unable to import Oracle Clob using tSqoopImport with Java API mode

Anonymous — Sat, 16 Nov 2024 08:28:39 GMT

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.

Re: Unable to import Oracle Clob using tSqoopImport with Java API mode

Anonymous — Tue, 03 Apr 2018 21:49:42 GMT

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"

Re: Unable to import Oracle Clob using tSqoopImport with Java API mode

Anonymous — Sun, 08 Apr 2018 10:26:08 GMT

Hello,

Thanks for sharing the solution on forum.

Best regards

Sabrina