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 C8F114C8B for ; Wed, 15 Jun 2011 04:55:06 +0000 (UTC) Received: (qmail 29810 invoked by uid 500); 15 Jun 2011 04:55:06 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 29760 invoked by uid 500); 15 Jun 2011 04:55:05 -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 29751 invoked by uid 99); 15 Jun 2011 04:55:04 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Jun 2011 04:55:04 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dujinhang@gmail.com designates 209.85.210.176 as permitted sender) Received: from [209.85.210.176] (HELO mail-iy0-f176.google.com) (209.85.210.176) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Jun 2011 04:54:58 +0000 Received: by iym1 with SMTP id 1so8181995iym.35 for ; Tue, 14 Jun 2011 21:54:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=FJyW7uUbrRhRF7NdzlsKNdNhbZXYlFM0cSDEdkUHvMU=; b=GeWaZTlItblDRWAgqCsV+4cStydz7vhJ3qQeURwiceolmYF5w8u3qxgdu/f5/pdQW0 xslfXvjurIYg9/se9GRH5Cf7vIkbJH5NSEnFp1iMAf1AWLmotmATzr8d4kmXTL6RCbke yW3zMJocTvVTLSEjAYFXGuPU0o6WSBWAK9eEc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=GXsauTXL8yuXNHDMm5KSwuQJa9AjDfjL0GFwbZQMfDQ7qiuP9p01KT3HPmBfjJRtiF 09UzeBZnF60FhmuqoBouJDWEbiv5AahYKl0SeMScMb0SaYr8metL3P72w+EuBuRpk6Ik VcYtwtRcfiI8ePE/nrXXa/tL8aRO904J7umzc= MIME-Version: 1.0 Received: by 10.231.202.196 with SMTP id ff4mr73172ibb.9.1308113677082; Tue, 14 Jun 2011 21:54:37 -0700 (PDT) Received: by 10.231.168.72 with HTTP; Tue, 14 Jun 2011 21:54:37 -0700 (PDT) In-Reply-To: References: Date: Wed, 15 Jun 2011 12:54:37 +0800 Message-ID: Subject: Re: When joins are executed, exceptions occur. From: jinhang du To: user@hive.apache.org Content-Type: multipart/alternative; boundary=00504502c71d0c60e504a5b8f39c --00504502c71d0c60e504a5b8f39c Content-Type: text/plain; charset=ISO-8859-1 from a join b on (a.s=b.s) select a.p, b.p When I use console client, this query is well executed. 2011/6/15 Shouguo Li > what query did u run? > > > On Tue, Jun 14, 2011 at 4:49 AM, jinhang du wrote: > >> >> Hi all, I use hive java client to execute hql. >> >> Simple queries like 'select * from table' are answered well. >> However, when i use join in my query ,exceptions occur. >> Error log : >> >> java.lang.NoClassDefFoundError: >> org/codehaus/jackson/map/JsonMappingException >> at >> org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:641) >> at >> org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:123) >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130) >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063) >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900) >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748) >> at >> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:116) >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >> at Sql.execSql(Sql.java:18) >> at Sql.test(Sql.java:24) >> at Sql.main(Sql.java:64) >> Caused by: java.lang.ClassNotFoundException: >> org.codehaus.jackson.map.JsonMappingException >> at java.net.URLClassLoader$1.run(URLClassLoader.java:202) >> at java.security.AccessController.doPrivileged(Native Method) >> at java.net.URLClassLoader.findClass(URLClassLoader.java:190) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:307) >> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:248) >> ... 12 more >> FAILED: Execution Error, return code -101 from >> org.apache.hadoop.hive.ql.exec.MapRedTask >> 11/06/14 19:33:53 ERROR ql.Driver: FAILED: Execution Error, return code >> -101 from org.apache.hadoop.hive.ql.exec.MapRedTask >> Exception in thread "main" java.sql.SQLException: Query returned non-zero >> code: 9, cause: FAILED: Execution Error, return code -101 from >> org.apache.hadoop.hive.ql.exec.MapRedTask >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189) >> at Sql.execSql(Sql.java:18) >> at Sql.test(Sql.java:24) >> at Sql.main(Sql.java:64) >> >> >> Can you help me ? >> -- >> dujinhang >> > > -- dujinhang --00504502c71d0c60e504a5b8f39c Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable from a join b on (a.s=3Db.s) select a.p, b.p

When I use console clie= nt, this query is well executed.

2011/6/1= 5 Shouguo Li <the1plummie@gmail.com>
what query did u run?


On Tue, Jun 14, 2011 at 4:49= AM, jinhang du <dujinhang@gmail.com> wrote:

Hi all, I use hive java client to execute hql.

Simple queries li= ke 'select * from table' are answered well.
However, when i use = join in my query ,exceptions occur.
Error log :

java.lang.NoClass= DefFoundError: org/codehaus/jackson/map/JsonMappingException
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.j= ava:641)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.MapRedTask.execute(= MapRedTask.java:123)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.Task.ex= ecuteTask(Task.java:130)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRu= nner.java:57)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.launchTask(D= river.java:1063)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.execute(D= river.java:900)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
=A0= =A0=A0 at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execu= te(HiveServer.java:116)
=A0=A0=A0 at org.apache.hadoop.hive.jdbc.HiveSta= tement.executeQuery(HiveStatement.java:187)
=A0=A0=A0 at Sql.execSql(Sql.java:18)
=A0=A0=A0 at Sql.test(Sql.java:24)=
=A0=A0=A0 at Sql.main(Sql.java:64)
Caused by: java.lang.ClassNotFoun= dException: org.codehaus.jackson.map.JsonMappingException
=A0=A0=A0 at j= ava.net.URLClassLoader$1.run(URLClassLoader.java:202)
=A0=A0=A0 at java.security.AccessController.doPrivileged(Native Method)
= =A0=A0=A0 at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
= =A0=A0=A0 at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
=A0= =A0=A0 at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
=A0=A0=A0 at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
=A0= =A0=A0 ... 12 more
FAILED: Execution Error, return code -101 from org.ap= ache.hadoop.hive.ql.exec.MapRedTask
11/06/14 19:33:53 ERROR ql.Driver: F= AILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exe= c.MapRedTask
Exception in thread "main" java.sql.SQLException: Query returned = non-zero code: 9, cause: FAILED: Execution Error, return code -101 from org= .apache.hadoop.hive.ql.exec.MapRedTask
=A0=A0=A0 at org.apache.hadoop.hi= ve.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
=A0=A0=A0 at Sql.execSql(Sql.java:18)
=A0=A0=A0 at Sql.test(Sql.java:24)=
=A0=A0=A0 at Sql.main(Sql.java:64)


Can you help me ?
--
dujinhang




--
dujinhang --00504502c71d0c60e504a5b8f39c--