[
https://issues.apache.org/jira/browse/HIVE-25507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17412886#comment-17412886
]
zhishui commented on HIVE-25507:
--------------------------------
[~yaofangxu] could you give some data from dual, I could not reproduce this
problem with version of 3.1.2
> 聚合的时候+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
> Priority: Major
>
>
> --执行报错
>
> 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)
