error [Import data from SQL to HDFS]

Mon, 24 Oct 2011 03:02:06 -0700 

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 



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.























					Reply via email to