Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-25409

group by the same column result sum result error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.2.1, 1.2.2
    • 2.1.1
    • Hive
    • None
    • hadoop 2.8.5

      hive 1.2.1 or hive 1.2.2

    Description

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

      Attachments

        Activity

          People

            Unassigned Unassigned
            liuguanghua liuguanghua
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: