Unable to import Oracle Clob using tSqoopImport with Java API mode

Four Stars

Unable to import Oracle Clob using tSqoopImport with Java API mode

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.

 

Talend_Pic1.jpgDefine 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.

Talend_Pic2.jpgAdditional 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.

 


Accepted Solutions
Four Stars

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

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"

 

 


All Replies
Four Stars

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

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"

 

 

Moderator

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

Hello,

Thanks for sharing the solution on forum.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.