There is a Execution Error in hive, can you help me figure out what problem is ?
Ended Job = job_201002261500_0005 with errors FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver Here is Hive.log in /tmp/, I can see the error info below .Failed map tasks:1,FileSystemCounters.FILE_BYTES_READ:42566756,FileSystemCounters.HDFS_ BYTES_READ:6089415548, FileSystemCounters.FILE_BYTES_WRITTEN:678631707 TaskProgress TASK_HADOOP_PROGRESS="2010-02-26 07:02:59,182 map = 99%, reduce =33%" TASK_NAME="org.apache.hadoo p.hive.ql.exec.ExecDriver" TASK_COUNTERS="Job Counters .Launched reduce tasks:8,Job Counters .Rack-local map ta sks:118,Job Counters .Launched map tasks:143,Job Counters .Data-local map tasks:25,Job Counters .Failed map tas ks:1,FileSystemCounters.FILE_BYTES_READ:42566756,FileSystemCounters.HDFS_BYT ES_READ:6089415548,FileSystemCounte rs.FILE_BYTES_WRITTEN:678631707,org.apache.hadoop.hive.ql.exec.MapOperator$C ounter.DESERIALIZE_ERRORS:0,Map-Red uce Framework.Combine output records:0,Map-Reduce Framework.Map input records:121944581,Map-Reduce Framework.Sp illed Records:24489407,Map-Reduce Framework.Map output bytes:590412105,Map-Reduce Framework.Map input bytes:608 9173827,Map-Reduce Framework.Combine input records:0,Map-Reduce Framework.Map output records:22891209" TASK_ID= "Stage-1" QUERY_ID="searchadmin_20100226185858" TASK_HADOOP_ID="job_201002261500_0004" TIME="1267182179184" TaskProgress TASK_HADOOP_PROGRESS="2010-02-26 07:03:02,210 map = 100%, reduce =100%" TASK_NAME="org.apache.had oop.hive.ql.exec.ExecDriver" TASK_COUNTERS="Job Counters .Launched reduce tasks:11,Job Counters .Rack-local map tasks:118,Job Counters .Launched map tasks:143,Job Counters .Data-local map tasks:25,Job Counters .Failed map tasks:1,FileSystemCounters.FILE_BYTES_READ:42566756,FileSystemCounters.HDFS_ BYTES_READ:6089415548,FileSystemCou nters.FILE_BYTES_WRITTEN:678631707,org.apache.hadoop.hive.ql.exec.MapOperato r$Counter.DESERIALIZE_ERRORS:0,Map- Reduce Framework.Combine output records:0,Map-Reduce Framework.Map input records:121944581,Map-Reduce Framework .Spilled Records:24489407,Map-Reduce Framework.Map output bytes:590412105,Map-Reduce Framework.Map input bytes: 6089173827,Map-Reduce Framework.Combine input records:0,Map-Reduce Framework.Map output records:22891209" TASK_ ID="Stage-1" QUERY_ID="searchadmin_20100226185858" TASK_HADOOP_ID="job_201002261500_0004" TIME="1267182182213" TaskEnd TASK_RET_CODE="2" TASK_HADOOP_PROGRESS="2010-02-26 07:03:02,210 map = 100%, reduce =100%" TASK_NAME="o rg.apache.hadoop.hive.ql.exec.ExecDriver" TASK_COUNTERS="Job Counters .Launched reduce tasks:11,Job Counters .R ack-local map tasks:118,Job Counters .Launched map tasks:143,Job Counters .Data-local map tasks:25,Job Counters .Failed map tasks:1,FileSystemCounters.FILE_BYTES_READ:42566756,FileSystemCounters.HDFS_ BYTES_READ:6089415548, FileSystemCounters.FILE_BYTES_WRITTEN:678631707,org.apache.hadoop.hive.ql.ex ec.MapOperator$Counter.DESERIALIZE_ ERRORS:0,Map-Reduce Framework.Combine output records:0,Map-Reduce Framework.Map input records:121944581,Map-Red uce Framework.Spilled Records:24489407,Map-Reduce Framework.Map output bytes:590412105,Map-Reduce Framework.Map input bytes:6089173827,Map-Reduce Framework.Combine input records:0,Map-Reduce Framework.Map output records:22 891209" TASK_ID="Stage-1" QUERY_ID="searchadmin_20100226185858" TASK_HADOOP_ID="job_201002261500_0004" TIME="12 67182182219" QueryEnd QUERY_STRING="INSERT OVERWRITE TABLE daily_hotkey select * from (select commclick.keyword keyword,c ommclick.navid navid,count(commclick.navid) countnavid from commclick GROUP BY commclick.keyword,commclick.navi d) t order by keyword,countnavid desc " QUERY_ID="searchadmin_20100226185858" QUERY_NUM_TASKS="2" TIME="1267182 182219"
