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

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

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 0.14.0
    • 1.2.2, 1.3.0, 2.0.0
    • Hive
    • 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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            hsubramaniyan Hari Sankar Sivarama Subramaniyan Assign to me
            yeezaa Yi Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment