hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bhaskar, Snehalata" <>
Subject RE: does not exist) when running a hive query
Date Mon, 04 Mar 2013 10:49:32 GMT
Does anyone know how to solve this issue??

Thanks and regards,
Snehalata Deorukhkar
Nortel No : 0229 -5814

From: Bhaskar, Snehalata []
Sent: Sunday, March 03, 2013 11:23 PM
Subject: does not exist) when running a hive query


I am getting " does not exist: /tmp/sb25634/hive_2013-03-01_23-21-43_428_5325193042224363842/-mr-10000/1/emptyFile)'
" exception when running any join query :

Following is the query that I am using and exception thrown.

hive> select * from retail_1 l join retail_2 t on l.product_name=t.product_name;

Total MapReduce jobs = 1

Launching Job 1 out of 1

Number of reduce tasks determined at compile time: 1

In order to change the average load for a reducer (in bytes):

  set hive.exec.reducers.bytes.per.reducer=<number>

In order to limit the maximum number of reducers:

  set hive.exec.reducers.max=<number>

In order to set a constant number of reducers:

  set mapred.reduce.tasks=<number>

WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter
in all the files.

Execution log at: /tmp/sb25634/sb25634_20130301232121_0c9f19d1-7846-4f4e-9469-401641fdd137.log File does not exist: /tmp/sb25634/hive_2013-03-01_23-21-43_428_5325193042224363842/-mr-10000/1/emptyFile

        at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(

        at org.apache.hadoop.mapred.lib.CombineFileInputFormat$OneFileInfo.<init>(

        at org.apache.hadoop.mapred.lib.CombineFileInputFormat.getMoreSplits(

        at org.apache.hadoop.mapred.lib.CombineFileInputFormat.getSplits(

        at org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileInputFormatShim.getSplits(

        at org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileInputFormatShim.getSplits(


        at org.apache.hadoop.mapred.JobClient.writeOldSplits(

        at org.apache.hadoop.mapred.JobClient.writeSplits(

        at org.apache.hadoop.mapred.JobClient.access$600(

        at org.apache.hadoop.mapred.JobClient$

        at org.apache.hadoop.mapred.JobClient$

        at Method)



        at org.apache.hadoop.mapred.JobClient.submitJobInternal(

        at org.apache.hadoop.mapred.JobClient.submitJob(

        at org.apache.hadoop.hive.ql.exec.ExecDriver.execute(

        at org.apache.hadoop.hive.ql.exec.ExecDriver.main(

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(

        at java.lang.reflect.Method.invoke(

        at org.apache.hadoop.util.RunJar.main(

Job Submission failed with exception ' does not exist: /tmp/sb25634/hive_2013-03-01_23-21-43_428_5325193042224363842/-mr-10000/1/emptyFile)'

Execution failed with exit status: 1

Obtaining error information

Task failed!

Task ID:




FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask

What may be the cause of this error?

Please help me to resolve this issue.Thanks in advance.

Snehalata Deorukhkar.

View raw message