[
https://issues.apache.org/jira/browse/HIVE-25507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yaofangxu updated HIVE-25507:
-----------------------------
Attachment: image-2021-09-14-16-59-59-460.png
Description:
--执行报错
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')
--沒有dual可以執行
select get_json_object(col,'$.a')
,get_json_object(col,'$.A')
,count(1) from
(select '\{"a":"b","A":"d"}' as col) 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')
,get_json_object(col,'$.A')
from
(select '\{"a":"b","A":"d"}' as col) b
group by get_json_object(col,'$.a')
,get_json_object(col,'$.A')
!image-2021-09-14-16-59-59-460.png!
was:
--执行报错
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')
--沒有dual可以執行
select get_json_object(col,'$.a')
,get_json_object(col,'$.A')
,count(1) from
(select '\{"a":"b","A":"d"}' as col) 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')
,get_json_object(col,'$.A')
from
(select '\{"a":"b","A":"d"}' as col) b
group by get_json_object(col,'$.a')
,get_json_object(col,'$.A')
> 聚合的时候+get_json_object 一起使用 大小写 有问题
> ----------------------------------
>
> Key: HIVE-25507
> URL: https://issues.apache.org/jira/browse/HIVE-25507
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.2.2
> Reporter: yaofangxu
> Priority: Major
> Attachments: image-2021-09-14-16-59-59-460.png
>
>
>
> --执行报错
>
> 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')
>
> --沒有dual可以執行
> select get_json_object(col,'$.a')
> ,get_json_object(col,'$.A')
> ,count(1) from
> (select '\{"a":"b","A":"d"}' as col) 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')
> ,get_json_object(col,'$.A')
> from
> (select '\{"a":"b","A":"d"}' as col) b
> group by get_json_object(col,'$.a')
> ,get_json_object(col,'$.A')
>
> !image-2021-09-14-16-59-59-460.png!
>
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
