You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "liuguanghua (Jira)" <ji...@apache.org> on 2021/08/11 06:25:00 UTC
[jira] [Resolved] (HIVE-25409) group by the same column result sum
result error
[ https://issues.apache.org/jira/browse/HIVE-25409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liuguanghua resolved HIVE-25409.
--------------------------------
Resolution: Fixed
> 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
> Fix For: 2.1.1
>
>
> 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)