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

Vectorization wrong results for aggregate query with where clause without group by

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 0.14.0
    • Fix Version/s: 1.3.0, 2.0.0, 1.2.2
    • Component/s: Hive
    • Labels:
      None

      Description

      create table testvec(id int, dt int, greg_dt string) stored as orc;

      insert into table testvec
      values
      (1,20150330, '2015-03-30'),
      (2,20150301, '2015-03-01'),
      (3,20150502, '2015-05-02'),
      (4,20150401, '2015-04-01'),
      (5,20150313, '2015-03-13'),
      (6,20150314, '2015-03-14'),
      (7,20150404, '2015-04-04');

      hive> select dt, greg_dt from testvec where id=5;
      OK
      20150313 2015-03-13
      Time taken: 4.435 seconds, Fetched: 1 row(s)

      hive> set hive.vectorized.execution.enabled=true;
      hive> set hive.map.aggr;
      hive.map.aggr=true

      hive> select max(dt), max(greg_dt) from testvec where id=5;

      OK
      20150313 2015-03-30

      hive> set hive.vectorized.execution.enabled=false;
      hive> select max(dt), max(greg_dt) from testvec where id=5;
      OK
      20150313 2015-03-13

        Attachments

        1. HIVE-11172.1.patch
          6 kB
          Hari Sankar Sivarama Subramaniyan
        2. HIVE-11172.2.patch
          6 kB
          Hari Sankar Sivarama Subramaniyan
        3. HIVE-11172.3.patch
          6 kB
          Hari Sankar Sivarama Subramaniyan

          Issue Links

            Activity

              People

              • Assignee:
                hsubramaniyan Hari Sankar Sivarama Subramaniyan
                Reporter:
                yeezaa Yi Zhang
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: