Re: error [Import data from SQL to HDFS]

trang van anh Mon, 24 Oct 2011 19:18:32 -0700

Thanks so much for help, i am trying to build lastest version fromgithup, but i want to get built version of sqoop-323, Could you tell mewhere to get it.?


Thanks&&Regards
On 10/24/2011 11:57 PM, arv...@cloudera.com wrote:

[Moving conversation to sqoop-u...@incubator.apache.org<mailto:sqoop-u...@incubator.apache.org>, bcc:user@hive.apache.org<mailto:bcc%3au...@hive.apache.org>]

From the console log that you sent, it appears that your import datacontains NVARCHAR datatype. This support was recently added viaSQOOP-323. Please use a more recent build of Sqoop and let us know ifthat works for you.


Thanks,
Arvind

On Mon, Oct 24, 2011 at 3:04 AM, trang van anh <anh...@vtc.vn<mailto: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.

Re: error [Import data from SQL to HDFS]

Reply via email to