hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From trang van anh <anh...@vtc.vn>
Subject error [Import data from SQL to HDFS]
Date Mon, 24 Oct 2011 10:04:52 GMT

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.



Mime
View raw message