Grokbase Groups Hive user June 2011
FAQ
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

Search Discussions

  • Shouguo Li at Jun 15, 2011 at 4:15 am
    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
  • Jinhang du at Jun 15, 2011 at 4:55 am
    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 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedJun 14, '11 at 11:49a
activeJun 15, '11 at 4:55a
posts3
users2
websitehive.apache.org

2 users in discussion

Jinhang du: 2 posts Shouguo Li: 1 post

People

Translate

site design / logo © 2021 Grokbase