Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB