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.
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.
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.
Solved! Go to Solution.
Thanks for sharing the solution on forum.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.