Thanks! I had to manually create the directory under tmp. Shouldn't it do that by itself?
From: Carl Steinbach [mailto:[email protected]] Sent: Thursday, February 25, 2010 4:37 PM To: [email protected] Subject: Re: Execution Error You can also change the value of hive.exec.scratchdir (default value: /tmp/hive-${user.name<http://user.name>}) to a path that you have permission to write to. The exception makes it look like you don't have permission to write to /tmp. Carl On Thu, Feb 25, 2010 at 1:25 PM, Zheng Shao <[email protected]<mailto:[email protected]>> wrote: Most probably $TMPDIR does not exist. I think by default it's "/tmp/<user>". Can you mkdir ? On Thu, Feb 25, 2010 at 5:58 AM, Aryeh Berkowitz <[email protected]<mailto:[email protected]>> wrote: > Can anybody tell me why I'm getting this error? > > > > hive> show tables; > > OK > > email > > html_href > > html_src > > ipadrr > > phone > > urls > > Time taken: 0.129 seconds > > hive> SELECT DISTINCT a.url, a.signature, a.size from urls a; > > Total MapReduce jobs = 1 > > Launching Job 1 out of 1 > > java.io.IOException: No such file or directory > > at java.io.UnixFileSystem.createFileExclusively(Native Method) > > at java.io.File.checkAndCreate(File.java:1704) > > at java.io.File.createTempFile(File.java:1792) > > at > org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:87) > > 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:630) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:504) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:382) > > at > org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:138) > > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:197) > > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:303) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:597) > > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.MapRedTask -- Yours, Zheng
