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.