hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jinhang du <dujinh...@gmail.com>
Subject Re: When joins are executed, exceptions occur.
Date Wed, 15 Jun 2011 04:54:37 GMT
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 <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 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

Mime
View raw message