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