tSqoopImport error while loading BLOB type data into hive

Five Stars

tSqoopImport error while loading BLOB type data into hive

Dear folks,

 

Present I am working on Talend Real-time Big data platform 6.4.1v

We are working on data ingestion from oracle to hive at that time I am facing below issue

[ERROR]: org.apache.sqoop.orm.ClassWriter - Cannot resolve SQL type 2011
[ERROR]: org.apache.sqoop.orm.ClassWriter - Cannot resolve SQL type 2011
[ERROR]: org.apache.sqoop.orm.ClassWriter - Cannot resolve SQL type 2011
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.orm.ClassWriter - No Java type for SQL type 2011 for column NOTES
[ERROR]: org.apache.sqoop.Sqoop - Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.sqoop.orm.ClassWriter.parseNullVal(ClassWriter.java:1377)
at org.apache.sqoop.orm.ClassWriter.parseColumn(ClassWriter.java:1402)
at org.apache.sqoop.orm.ClassWriter.myGenerateParser(ClassWriter.java:1528)
at org.apache.sqoop.orm.ClassWriter.generateParser(ClassWriter.java:1491)
at org.apache.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1920)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1736)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:606)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at ubp_talend.accounts_0_1.Accounts.tSqoopImport_1Process(Accounts.java:632)
at ubp_talend.accounts_0_1.Accounts.runJobInTOS(Accounts.java:1704)
at ubp_talend.accounts_0_1.Accounts.main(Accounts.java:1530)
[ERROR]: ubp_talend.accounts_0_1.Accounts - tSqoopImport_1 - The Sqoop import job has failed. Please check the logs.

Please help me to resolve this issue.

 

Regards,

Rupesh. M

 

Twelve Stars

Re: tSqoopImport error while loading BLOB type data into hive

on advanced  settings tab add column mapping

like. --map-column-hive COLUMN_BLOB=binary

-----------