You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "wenjie.yu (JIRA)" <ji...@apache.org> on 2017/07/07 10:31:00 UTC
[jira] [Created] (HIVE-17059) Hive Runtime Error while processing
row (tag=0)
wenjie.yu created HIVE-17059:
--------------------------------
Summary: Hive Runtime Error while processing row (tag=0)
Key: HIVE-17059
URL: https://issues.apache.org/jira/browse/HIVE-17059
Project: Hive
Issue Type: Test
Reporter: wenjie.yu
I run the sql looks like below in HIVE and got error:Hive Runtime Error while processing row (tag=0)
QUERY:
select
dt as d_date
...... -- group by columns
,min(epoch_time) as min_epoch_time
,count(*) as cnt
from
DB.target_Table
where
dt = '20170705'
group by
dt
...... -- group by columns
ERROR:
Error: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{"_col0":"20170705","_col1":"-2144668477","_col2":"4724a50e-9238-4146-9394-a076acd41836","_col3":"client://plusApp/pdtil_Purchase","_col4":"924","_col5":"61","_col6":"app","_col7":"A","_col8":"comic","_col9":"4724a50e-9238-4146-9394-a076acd41836","_col10":"46f572ce-ed86-4c2a-bf7a-db2171654144"},"value":{"_col0":"46f572ce-ed86-4c2a-bf7a-db2171654144","_col1":"1499186628.124"}}
at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:265)
at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:444)
at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:392)
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1693)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{"_col0":"20170705","_col1":"-2144668477","_col2":"4724a50e-9238-4146-9394-a076acd41836","_col3":"client://plusApp/pdtil_Purchase","_col4":"924","_col5":"61","_col6":"app","_col7":"A","_col8":"comic","_col9":"4724a50e-9238-4146-9394-a076acd41836","_col10":"46f572ce-ed86-4c2a-bf7a-db2171654144"},"value":{"_col0":"46f572ce-ed86-4c2a-bf7a-db2171654144","_col1":"1499186628.124"}}
at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:253)
... 7 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.io.Text cannot be cast to org.apache.hadoop.io.LongWritable
at org.apache.hadoop.hive.ql.exec.GroupByOperator.processOp(GroupByOperator.java:763)
at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:244)
... 7 more
Caused by: java.lang.ClassCastException: org.apache.hadoop.io.Text cannot be cast to org.apache.hadoop.io.LongWritable
at org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableLongObjectInspector.get(WritableLongObjectInspector.java:36)
at org.apache.hadoop.hive.ql.udf.generic.GenericUDAFCount$GenericUDAFCountEvaluator.merge(GenericUDAFCount.java:150)
at org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEvaluator.aggregate(GenericUDAFEvaluator.java:188)
at org.apache.hadoop.hive.ql.exec.GroupByOperator.updateAggregations(GroupByOperator.java:609)
at org.apache.hadoop.hive.ql.exec.GroupByOperator.processAggr(GroupByOperator.java:848)
at org.apache.hadoop.hive.ql.exec.GroupByOperator.processKey(GroupByOperator.java:692)
at org.apache.hadoop.hive.ql.exec.GroupByOperator.processOp(GroupByOperator.java:758)
... 8 more
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
1, The table is big one.
2, Hive Runtime Error while processing row (tag=0) {"key":{"_col0":"20170705","_col1":"-2144668477","_col2":"4724a50e-9238-4146-9394-a076acd41836","_col3":"client://plusApp/pdtil_Purchase","_col4":"924","_col5":"61","_col6":"app","_col7":"A","_col8":"comic","_col9":"4724a50e-9238-4146-9394-a076acd41836","_col10":"46f572ce-ed86-4c2a-bf7a-db2171654144"},"value":{{color:red}"_col0":"46f572ce-ed86-4c2a-bf7a-db2171654144"{color},"_col1":"1499186628.124"}}
i think col0 of Value should be a number because it is a count for group by query.
but the value:46f572ce-ed86-4c2a-bf7a-db2171654144 looks be a value of column(adid?)
I don't know why.
CDH-5.8.0-1.cdh5.8.0.p0.42
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)