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
-
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