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.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.