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 <kiteradd...@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
