hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "arvind@cloudera.com" <arv...@cloudera.com>
Subject Re: error [Import data from SQL to HDFS]
Date Mon, 24 Oct 2011 16:57:19 GMT
[Moving conversation to sqoop-user@incubator.apache.org,
bcc:user@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.tv@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.
>
>
>

Mime
View raw message