Yi Zhang created HIVE-11172:
-------------------------------

             Summary: Vectorization wrong results for aggregate query with 
where clause without group by
                 Key: HIVE-11172
                 URL: https://issues.apache.org/jira/browse/HIVE-11172
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 0.14.0
            Reporter: Yi Zhang
            Priority: Critical


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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to