[
https://issues.apache.org/jira/browse/HIVE-4680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eric Hanson updated HIVE-4680:
------------------------------
Description:
query:
select ddate, count\(\*\) from factsqlengineam_vec_orc where ddate =
"2012-05-19 00:00:00" OR ddate = "2012-05-20 00:00:00" group by ddate;
Actual result:
OK
2012-05-19 00:00:00 528741
Expected result:
There would be two rows, one for each day in the OR clause in the query.
This query actually returns a row, so there is data there for 2012-05-20.
select ddate, count\(\*\) from factsqlengineam_vec_orc where ddate =
"2012-05-20 00:00:00" group by ddate;
was:
query:
select ddate, count(*) from factsqlengineam_vec_orc where ddate = "2012-05-19
00:00:00" OR ddate = "2012-05-20 00:00:00" group by ddate;
Actual result:
OK
2012-05-19 00:00:00 528741
Expected result:
There would be two rows, one for each day in the OR clause in the query.
This query actually returns a row, so there is data there for 2012-05-20.
select ddate, count(*) from factsqlengineam_vec_orc where ddate = "2012-05-20
00:00:00" group by ddate;
> second clause of OR filter not applied in vectorized query execution
> --------------------------------------------------------------------
>
> Key: HIVE-4680
> URL: https://issues.apache.org/jira/browse/HIVE-4680
> Project: Hive
> Issue Type: Sub-task
> Components: Query Processor
> Affects Versions: vectorization-branch
> Reporter: Eric Hanson
>
> query:
> select ddate, count\(\*\) from factsqlengineam_vec_orc where ddate =
> "2012-05-19 00:00:00" OR ddate = "2012-05-20 00:00:00" group by ddate;
> Actual result:
> OK
> 2012-05-19 00:00:00 528741
> Expected result:
> There would be two rows, one for each day in the OR clause in the query.
> This query actually returns a row, so there is data there for 2012-05-20.
> select ddate, count\(\*\) from factsqlengineam_vec_orc where ddate =
> "2012-05-20 00:00:00" group by ddate;
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
