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 <the1plum...@gmail.com> > what query did u run? > > > On Tue, Jun 14, 2011 at 4:49 AM, jinhang du <dujinh...@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
