hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ch huang <justlo...@gmail.com>
Subject error in running hive query
Date Fri, 19 Jul 2013 09:22:12 GMT
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

Mime
View raw message