Details
-
Type:
New Feature
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
Problem faced by user:
We are facing following an error while importing data from a table in
SQL Server 2008 using "sqoop" -
11/05/06 15:46:43 ERROR orm.ClassWriter: Cannot resolve SQL type -9
11/05/06 15:46:43 ERROR orm.ClassWriter: No Java type for SQL type -9
11/05/06 15:46:43 ERROR orm.ClassWriter: No Java type for SQL type -9
11/05/06 15:46:43 ERROR orm.ClassWriter: No Java type for SQL type -9
11/05/06 15:46:43 ERROR orm.ClassWriter: No Java type for SQL type -9
11/05/06 15:46:43 ERROR orm.ClassWriter: No Java type for SQL type -9
11/05/06 15:46:43 ERROR orm.ClassWriter: No Java type for SQL type -9
11/05/06 15:46:43 ERROR sqoop.Sqoop: Got exception running Sqoop:
java.lang.NullPointerException
java.lang.NullPointerException
at com.cloudera.sqoop.orm.ClassWriter.parseNullVal(ClassWriter.java:738)
at com.cloudera.sqoop.orm.ClassWriter.parseColumn(ClassWriter.java:761)
at com.cloudera.sqoop.orm.ClassWriter.generateParser(ClassWriter.java:835)
at com.cloudera.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1116)
at com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:981)
at com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:134)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:170)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:196)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:205)
If I exclude columns of "nvarchar" type from select-list, I am able to
import the data.