You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "yaofangxu (Jira)" <ji...@apache.org> on 2021/09/14 08:58:00 UTC
[jira] [Updated] (HIVE-25507) 聚合的时候+get_json_object 一起使用 大小写 有问题
[ https://issues.apache.org/jira/browse/HIVE-25507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
yaofangxu updated HIVE-25507:
-----------------------------
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')
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')
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')
> 聚合的时候+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')
>
> --沒有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')
>
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)