[Moving conversation to sqoop-user@incubator.apache.org, bcc:u...@hive.apache.org]
>From the console log that you sent, it appears that your import data contains NVARCHAR datatype. This support was recently added via SQOOP-323. Please use a more recent build of Sqoop and let us know if that works for you. Thanks, Arvind On Mon, Oct 24, 2011 at 3:04 AM, trang van anh <anh...@vtc.vn> wrote: > > 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. > > >
