You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Yi Zhang (JIRA)" <ji...@apache.org> on 2015/07/02 20:17:04 UTC
[jira] [Created] (HIVE-11172) Vectorization wrong results for
aggregate query with where clause without group by
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)