[jira] [Created] (HIVE-25507) 聚合的时候+get_json_object 一起使用 大小写 有问题

["yaofangxu (Jira)" <ji...@apache.org>]

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)