Dear all ,
I using sqoop tool to import data from sql server (importing data is a
View in SQL) to hdfs but i face following problem, i have imported
successfully from Mysql to HDFS
11/10/24 16:55:54 INFO sqoop.ImportOptions: Using Hive-specific
delimiters for output. You can override
11/10/24 16:55:54 INFO sqoop.ImportOptions: delimiters with
--fields-terminated-by, etc.
11/10/24 16:55:54 INFO sqoop.Sqoop: Beginning code generation
11/10/24 16:55:54 INFO manager.SqlManager: Executing SQL statement:
SELECT t.* FROM VW_AccountLoginedProfile AS t WHERE 1=0
11/10/24 16:55:54 ERROR orm.ClassWriter: Cannot resolve SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: Cannot resolve SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: Cannot resolve SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: Cannot resolve SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR orm.ClassWriter: No Java type for SQL type -9
11/10/24 16:55:54 ERROR sqoop.Sqoop: Got exception running Sqoop:
java.lang.NullPointerException
java.lang.NullPointerException
at
org.apache.hadoop.sqoop.orm.ClassWriter.parseColumn(ClassWriter.java:603)
at
org.apache.hadoop.sqoop.orm.ClassWriter.generateParser(ClassWriter.java:675)
at
org.apache.hadoop.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:847)
at
org.apache.hadoop.sqoop.orm.ClassWriter.generate(ClassWriter.java:735)
at org.apache.hadoop.sqoop.Sqoop.generateORM(Sqoop.java:79)
at org.apache.hadoop.sqoop.Sqoop.importTable(Sqoop.java:91)
at org.apache.hadoop.sqoop.Sqoop.run(Sqoop.java:179)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
at org.apache.hadoop.sqoop.Sqoop.main(Sqoop.java:205)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
Any suggestion for me to resolve above issue?
Thanks in advance.
