[ 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)