Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Distinct errors


Copy link to this message
-
Re: Distinct errors
Arvind Prabhakar 2010-03-25, 07:23
The patch available for
HIVE-1277<https://issues.apache.org/jira/browse/HIVE-1277>should
address this issue. Can you please try that out and let us know if it
worked?

Thanks,
Arvind
On Fri, Feb 26, 2010 at 10:13 AM, Peter Sankauskas <[EMAIL PROTECTED]>wrote:

> Looks like the same error as before... the temp directory is missing.
>
> Kind regards,
> Peter Sankauskas
>
> Motally, Inc
> Office: +1 (415) 932-6898
>
>
>
> On Fri, Feb 26, 2010 at 5:33 AM, Aryeh Berkowitz <[EMAIL PROTECTED]>wrote:
>
>>  When I try to do a SELECT DISTINCT, I get “No such file” errors.
>>
>>
>>
>> hive> SELECT DISTINCT URL FROM URLS;
>>
>> 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
>>
>
>