Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - error in running hive query


Copy link to this message
-
error in running hive query
ch huang 2013-07-19, 09:22
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