[HIVE-11172] Vectorization wrong results for aggregate query with where clause without group by

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 1.2.2, 1.3.0, 2.0.0
• Component/s: Hive
• Assignee: Hari Sankar Sivarama Subramaniyan
• Reporter: Yi Zhang
• Created: 02/Jul/15 18:16
• Updated: 16/Feb/16 23:52
• Resolved: 21/Jul/15 10:05

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

Issue Links

• links to: Review board