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
-
Re: error in running hive query
> Error: Java heap space

Guess this should give a hint.
On Fri, Jul 19, 2013 at 4:22 AM, ch huang <[EMAIL PROTECTED]> 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
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