Re: Execution Error

[Arvind Prabhakar <ar...@cloudera.com>]

Yes - this has been fixed in the trunk. See:

https://issues.apache.org/jira/browse/HIVE-1277

<https://issues.apache.org/jira/browse/HIVE-1277>Arvind

On Fri, Feb 26, 2010 at 8:59 AM, Aryeh Berkowitz <ar...@iswcorp.com> wrote:

>  Thanks! I had to manually create the directory under tmp. Shouldn’t it do
> that by itself?
>
>
>
> *From:* Carl Steinbach [mailto:carl@cloudera.com]
> *Sent:* Thursday, February 25, 2010 4:37 PM
> *To:* hive-user@hadoop.apache.org
> *Subject:* Re: Execution Error
>
>
>
> You can also change the value of hive.exec.scratchdir (default value:
> /tmp/hive-${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 <zs...@gmail.com> 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 <ar...@iswcorp.com>
> 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
>
>
>