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:20 UTC

[jira] [Created] (HIVE-4680) second clause of OR filter not applied in vectorized query execution

Eric Hanson created HIVE-4680:
---------------------------------

             Summary: 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