Hive中使⽤Round（）的坑
有个算法如下:
SELECT MEMBERNUMBER, ROUND(SUM(SumPointAmount)) AS VALUE FROM BSUM_CRMPOINT WHERE UPPER(POINTCATEGORY)='REWARD'GROUP BY MEMBERNUMBER 使⽤round()函数来规范Sum()后的值..
算法并不复杂..但⼀直报错..
MapReduce Total cumulative CPU time: 1 minutes 16 seconds 968 msec
Ended Job = job_1483628918349_2920 with errors
Error during job, obtaining
Examining task ID: task_1483628918349_2920_m_000002 (and more) from job job_1483628918349_2920
Task with the most failures(4):
-
hue trunc函数----
Task ID:
task_1483628918349_2920_m_000000
URL:
headnodehost:9014/taskdetails.jsp?jobid=job_1483628918349_2920&tipid=task_1483628918349_2920_m_000000
-----
Diagnostic Messages for this Task:
Error: GC overhead limit exceeded
Container killed by the ApplicationMaster.
Container killed on request. Exit code is137
Container exited with a non-zero exit code 137
FAILED: Execution Error, return code 2from org.apache.hadoop.r.MapRedTask
MapReduce Jobs Launched:
Stage-Stage-1: Map: 3  Reduce: 8  Cumulative CPU: 76.968 sec  HDFS Read: 1547020 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 1 minutes 16 seconds 968 msec
并没有具体错误的报⽂..  ExitValue 为  2
后来偶然把Round去掉..跑通了..返回码0
百思不得其解..
有路过⼤神希望能解释下..
有同样算法的童鞋请尝试去除round再试..到原因请分享..

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。