hive任务Could not find status of job:job_xxx
日常运行的线上任务夜间突然报错,重跑还是如此,搜一堆 set hive.jobname.length=100;
显然不适用,经排查,往下看
2023-02-24 03:42:29 End of local task; Time Taken: 2.394 sec.
2023-02-24 03:42:30,564 Stage-47 map = 100%, reduce = 40%, Cumulative CPU 145.8 sec
Execution completed successfully
MapredLocal task succeeded
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. Could not find status of job:job_1667972909715_2306949
2023-02-24 03:42:31,617 Stage-70 map = 100%, reduce = 0%, Cumulative CPU 21.53 sec
2023-02-24 03:42:31,621 Stage-47 map = 100%, reduce = 100%, Cumulative CPU 145.8 sec
MapReduce Total cumulative CPU time: 21 seconds 530 msec
Ended Job = job_1667972909715_2306965
java.io.IOException: Could not find status of job:job_1667972909715_2306964
at org.apache.hadoop.hive.ql.exec.mr.HadoopJobExecHelper.progress(HadoopJobExecHelper.java:301)
at org.apache.hadoop.hive.ql.exec.mr.HadoopJobExecHelper.progress(HadoopJobExecHelper.java:559)
at org.apache.hadoop.hive.ql.exec.mr.ExecDriver.execute(ExecDriver.java:428)
at org.apache.hadoop.hive.ql.exec.mr.MapRedTask.execute(MapRedTask.java:151)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:201)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100)
at org.apache.hadoop.hive.ql.exec.TaskRunner.run(TaskRunner.java:79)
Ended Job = job_1667972909715_2306964 with exception 'java.io.IOException(Could not find status of job:job_1667972909715_2306964)'
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hdfs.protocol.FSLimitException$MaxDirectoryItemsExceededException): The directory item limit of /emr/hadoop-yarn/staging/history/done_intermediate/dw_hadoop_user is exceeded: limit=1048576 items=1048576
清理用户下目录,任务重跑正常。