yaofangxu created HIVE-25507:
--------------------------------
Summary: 聚合的时候+get_json_object 一起使用 大小写 有问题
Key: HIVE-25507
URL: https://issues.apache.org/jira/browse/HIVE-25507
Project: Hive
Issue Type: Bug
Affects Versions: 1.2.1
Reporter: yaofangxu
--执行报错
select get_json_object(col,'$.a'),get_json_object(col,'$.A'),count(1)from
(select '\{"a":"b","A":"d"}' as col from dual) b group by
get_json_object(col,'$.a'),get_json_object(col,'$.A')
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:645)
at
org.apache.hadoop.hive.ql.exec.GroupByOperator.processAggr(GroupByOperator.java:911)
at
org.apache.hadoop.hive.ql.exec.GroupByOperator.processKey(GroupByOperator.java:741)
at
org.apache.hadoop.hive.ql.exec.GroupByOperator.processOp(GroupByOperator.java:809)
--执行结果不对
select get_json_object(col,'$.a') as cc,get_json_object(col,'$.A')from (select
'\{"a":"b","A":"d"}' as col from dual) b group by
get_json_object(col,'$.a'),get_json_object(col,'$.A')
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
