You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by ch huang <ju...@gmail.com> on 2013/07/19 11:22:12 UTC
error in running hive query
why the task failed? anyone can help?
hive> select cookieid,count(url) as visit_num from alex_test_big_seq group
by cookieid order by visit_num desc limit 10;
MapReduce Total cumulative CPU time: 49 minutes 20 seconds 870 msec
Ended Job = job_1374214993631_0037 with errors
Error during job, obtaining debugging information...
Job Tracking URL:
http://CH22:8088/proxy/application_1374214993631_0037/<http://ch22:8088/proxy/application_1374214993631_0037/>
Examining task ID: task_1374214993631_0037_m_000007 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000002 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000028 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000035 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000046 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000054 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000020 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000040 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000040 (and more) from job
job_1374214993631_0037
Examining task ID: task_1374214993631_0037_m_000079 (and more) from job
job_1374214993631_0037
Task with the most failures(4):
-----
Task ID:
task_1374214993631_0037_m_000011
URL:
http://CH22:8088/taskdetails.jsp?jobid=job_1374214993631_0037&tipid=task_1374214993631_0037_m_000011<http://ch22:8088/taskdetails.jsp?jobid=job_1374214993631_0037&tipid=task_1374214993631_0037_m_000011>
-----
Diagnostic Messages for this Task:
Error: Java heap space
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
MapReduce Jobs Launched:
Job 0: Map: 114 Reduce: 33 Cumulative CPU: 2960.87 sec HDFS Read:
22037646479 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 49 minutes 20 seconds 870 msec
Re: error in running hive query
Posted by "kulkarni.swarnim@gmail.com" <ku...@gmail.com>.
> Error: Java heap space
Guess this should give a hint.
On Fri, Jul 19, 2013 at 4:22 AM, ch huang <ju...@gmail.com> wrote:
> why the task failed? anyone can help?
>
>
> hive> select cookieid,count(url) as visit_num from alex_test_big_seq group
> by cookieid order by visit_num desc limit 10;
>
> MapReduce Total cumulative CPU time: 49 minutes 20 seconds 870 msec
> Ended Job = job_1374214993631_0037 with errors
> Error during job, obtaining debugging information...
> Job Tracking URL: http://CH22:8088/proxy/application_1374214993631_0037/<http://ch22:8088/proxy/application_1374214993631_0037/>
> Examining task ID: task_1374214993631_0037_m_000007 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000002 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000028 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000035 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000046 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000054 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000020 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000040 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000040 (and more) from job
> job_1374214993631_0037
> Examining task ID: task_1374214993631_0037_m_000079 (and more) from job
> job_1374214993631_0037
>
> Task with the most failures(4):
> -----
> Task ID:
> task_1374214993631_0037_m_000011
>
> URL:
>
> http://CH22:8088/taskdetails.jsp?jobid=job_1374214993631_0037&tipid=task_1374214993631_0037_m_000011<http://ch22:8088/taskdetails.jsp?jobid=job_1374214993631_0037&tipid=task_1374214993631_0037_m_000011>
> -----
> Diagnostic Messages for this Task:
> Error: Java heap space
>
> FAILED: Execution Error, return code 2 from
> org.apache.hadoop.hive.ql.exec.MapRedTask
> MapReduce Jobs Launched:
> Job 0: Map: 114 Reduce: 33 Cumulative CPU: 2960.87 sec HDFS Read:
> 22037646479 HDFS Write: 0 FAIL
> Total MapReduce CPU Time Spent: 49 minutes 20 seconds 870 msec
>
--
Swarnim