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.
