hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dilip Joseph <dilip.antony.jos...@gmail.com>
Subject Re: select count(1)
Date Mon, 03 Jan 2011 18:38:23 GMT
Another possibility is that some required jars are not in your classpath
when running your JDBC client.  That could explain why everything works from
the Hive CLI and HiveServer.

I had written an article on using Hive from Jython -
http://csgrad.blogspot.com/2010/04/to-use-language-other-than-java-say.html.
 Verifying that all the jars listed in the article are in your classpath may
help.

Regards

Dilip


On Mon, Jan 3, 2011 at 9:18 AM, kiteraddict <kiteraddict@googlemail.com>wrote:

> Hi Dilip,
> Unfortunately, not. No special characters. Tried a symlink as well...
> The Path seems ok, and the strange is: select count(1) from the cli
> woks.
> I get the same error in Eclipse and in Netbeans (OSX 10.6.4). However
> thank you for your tip!
> Malte
>
> 2011/1/3 Dilip Joseph <dilip.antony.joseph@gmail.com>:
> > Does the full path to your hadoop installation contain a '+' character?
>  I
> > ran into a similar problem where a bug in the DataNucleus libraries used
> by
> > hive prevented it from constructing the full path to your hadoop
> > installation, if the path contained a '+'.  The solution was to remove
> the
> > '+' from the path by renaming the Hadoop installation directory, or by
> > creating a symlink to it.
> > Dilip
> >
> > On Mon, Jan 3, 2011 at 4:37 AM, Malte Ehmke <kiteraddict@googlemail.com>
> > wrote:
> >>
> >> Hi there,
> >>
> >> I'am trying the jdbc example
> >>
> >> http://wiki.apache.org/hadoop/Hive/HiveClient#JDBC
> >>
> >> and getting that for the select count(1) query
> >>
> >> 11/01/03 12:34:35 INFO exec.MapRedTask: Generating plan file
> >>
> /tmp/hive-malte/hive_2011-01-03_12-34-35_503_9118509121830839307/plan4525595563698858213.xml
> >>
> >> 11/01/03 12:34:35 INFO exec.MapRedTask: Executing: null/bin/hadoop jar
> >> /Applications/java/hive-0.6.0/lib/hive-exec-0.6.0.jar [...]
> >>
> >> java.io.IOException: Cannot run program "null/bin/hadoop": error=2, No
> >> such file or directory
> >>
> >> at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
> >>
> >> at java.lang.Runtime.exec(Runtime.java:593)
> >>
> >> at java.lang.Runtime.exec(Runtime.java:431)
> >>
> >> at java.lang.Runtime.exec(Runtime.java:369)
> >>
> >> at
> org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:176)
> >>
> >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107)
> >>
> >> at
> >>
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:55)
> >>
> >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:633)
> >>
> >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:506)
> >>
> >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:384)
> >>
> >> at
> >>
> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:114)
> >>
> >> at
> >>
> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:195)
> >>
> >> at de.codiacs.hive.HiveServiceTest.main(HiveServiceTest.java:64)
> >>
> >> Caused by: java.io.IOException: error=2, No such file or directory
> >>
> >> at java.lang.UNIXProcess.forkAndExec(Native Method)
> >>
> >> at java.lang.UNIXProcess.<init>(UNIXProcess.java:53)
> >>
> >> at java.lang.ProcessImpl.start(ProcessImpl.java:91)
> >>
> >> at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
> >>
> >> ... 12 more
> >>
> >> 11/01/03 12:34:35 ERROR exec.MapRedTask: Exception: Cannot run program
> >> "null/bin/hadoop": error=2, No such file or directory
> >>
> >> FAILED: Execution Error, return code 1 from
> >> org.apache.hadoop.hive.ql.exec.MapRedTask
> >>
> >> 11/01/03 12:34:35 ERROR ql.Driver: FAILED: Execution Error, return code
> 1
> >> 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 1 from
> >> org.apache.hadoop.hive.ql.exec.MapRedTask
> >>
> >> at
> >>
> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:197)
> >>
> >> Creating and inserting works.
> >>
> >> Does anybody have a solution for that problem?
> >>
> >> Thanks
> >
> >
> > --
> > _________________________________________
> > Dilip Antony Joseph
> > http://csgrad.blogspot.com
> > http://www.marydilip.info
> >
>



-- 
_________________________________________
Dilip Antony Joseph
http://csgrad.blogspot.com
http://www.marydilip.info

Mime
View raw message