You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Eric Hanson (JIRA)" <ji...@apache.org> on 2013/06/07 00:56:21 UTC
[jira] [Updated] (HIVE-4680) second clause of OR filter not applied
in vectorized query execution
[ 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