Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1FC437D90 for ; Mon, 24 Oct 2011 16:58:26 +0000 (UTC) Received: (qmail 11793 invoked by uid 500); 24 Oct 2011 16:58:25 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 11760 invoked by uid 500); 24 Oct 2011 16:58:25 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 11752 invoked by uid 99); 24 Oct 2011 16:58:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Oct 2011 16:58:25 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of arvind@cloudera.com designates 209.85.216.169 as permitted sender) Received: from [209.85.216.169] (HELO mail-qy0-f169.google.com) (209.85.216.169) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Oct 2011 16:58:20 +0000 Received: by qyk29 with SMTP id 29so2616242qyk.14 for ; Mon, 24 Oct 2011 09:57:59 -0700 (PDT) Received: by 10.182.74.41 with SMTP id q9mr3491472obv.28.1319475479142; Mon, 24 Oct 2011 09:57:59 -0700 (PDT) MIME-Version: 1.0 Received: by 10.182.144.98 with HTTP; Mon, 24 Oct 2011 09:57:19 -0700 (PDT) In-Reply-To: <4EA53844.8090107@vtc.vn> References: <4EA53774.4080006@vtc.vn> <4EA53844.8090107@vtc.vn> From: "arvind@cloudera.com" Date: Mon, 24 Oct 2011 09:57:19 -0700 Message-ID: Subject: Re: error [Import data from SQL to HDFS] To: sqoop-user@incubator.apache.org Content-Type: multipart/alternative; boundary=f46d044470e3395f2d04b00e53e9 --f46d044470e3395f2d04b00e53e9 Content-Type: text/plain; charset=ISO-8859-1 [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 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. > > > --f46d044470e3395f2d04b00e53e9 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable [Moving conversation to = sqoop-user@incubator.apache.org,=A0bcc:user@hive.apache.org]

From the console= log that you sent, it appears that your import data contains NVARCHAR data= type. This support was recently added via SQOOP-323. Please use a more rece= nt 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=3D0
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
=A0 =A0at
org.apache.hadoop.sqoop.orm.ClassWriter.parseColumn(ClassWrit= er.java:603)
=A0 =A0at
org.apache.hadoop.sqoop.orm.ClassWriter.generateParser(ClassW= riter.java:675)
=A0 =A0at
org.apache.hadoop.sqoop.orm.ClassWriter.generateClassForColum= ns(ClassWriter.java:847)
=A0 =A0at
org.apache.hadoop.sqoop.orm.ClassWriter.generate(ClassWriter.= java:735)
=A0 =A0at org.apache.hadoop.sqoop.Sqoop.generateORM(Sqoop.java:79)<= br> =A0 =A0at org.apache.hadoop.sqoop.Sqoop.importTable(Sqoop.java:91)<= br> =A0 =A0at org.apache.hadoop.sqoop.Sqoop.run(Sqoop.java:179)
=A0 =A0at org.apache.hadoop.util.ToolRunner.run(ToolRunner.j= ava:65)
=A0 =A0at org.apache.hadoop.util.ToolRunner.run(ToolRunner.j= ava:79)
=A0 =A0at org.apache.hadoop.sqoop.Sqoop.main(Sqoop.java:205)
=A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ= e Method)
=A0 =A0at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMeth= odAccessorImpl.java:57)
=A0 =A0at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Delega= tingMethodAccessorImpl.java:43)
=A0 =A0at java.lang.reflect.Method.invoke(Method.java:616)
=A0 =A0at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

Any suggestion for me to resolve above issue?

Thanks in advance.



--f46d044470e3395f2d04b00e53e9--