[jira] [Commented] (HIVE-25409) group by the same column result sum result error

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

    [ https://issues.apache.org/jira/browse/HIVE-25409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17391581#comment-17391581 ] 

Zhihua Deng commented on HIVE-25409:
------------------------------------

This has been fixed by https://issues.apache.org/jira/browse/HIVE-14715, as RS shrinks the same keys to reduce the amount of data to be shuffled, leads to a wrong value type on the value that to be merged on the gby.

> group by the same column result sum result error
> ------------------------------------------------
>
>                 Key: HIVE-25409
>                 URL: https://issues.apache.org/jira/browse/HIVE-25409
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 1.2.1, 1.2.2
>         Environment: hadoop 2.8.5
> hive 1.2.1 or hive 1.2.2
>            Reporter: liuguanghua
>            Priority: Major
>
> create table test
> (
> a string,
> b string
> );
> insert into table test values ('a','1'),('b','2'),('c','3');
> select a,a,sum(b) from test group by a,a;
>  
> this will get the wrong answer.  We expect the sum(b),but is will compute the sum(a).



--
This message was sent by Atlassian Jira
(v8.3.4#803005)