You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "liuguanghua (Jira)" <ji...@apache.org> on 2021/07/30 06:53:00 UTC

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

liuguanghua created HIVE-25409:
----------------------------------

             Summary: 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.2, 1.2.1
         Environment: hadoop 2.8.5

hive 1.2.1 or hive 1.2.2
            Reporter: liuguanghua


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)