[
https://issues.apache.org/jira/browse/HIVE-17059?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wenjie.yu updated HIVE-17059:
-----------------------------
Description:
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
{color:#8eb021}1, The table is big one. {color}
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":{*"_col0":"46f572ce-ed86-4c2a-bf7a-db2171654144"*,"_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
was:
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
{color:#8eb021}1, The table is big one. {color}
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:#d04437}"_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
> 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
> {color:#8eb021}1, The table is big one. {color}
> 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":{*"_col0":"46f572ce-ed86-4c2a-bf7a-db2171654144"*,"_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)
