hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Hanson (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4678) second clause of AND filter not applied for vectorized execution
Date Thu, 06 Jun 2013 20:28:20 GMT
Eric Hanson created HIVE-4678:
---------------------------------

             Summary: second clause of AND filter not applied for vectorized execution
                 Key: HIVE-4678
                 URL: https://issues.apache.org/jira/browse/HIVE-4678
             Project: Hive
          Issue Type: Sub-task
          Components: Query Processor
    Affects Versions: vectorization-branch
            Reporter: Eric Hanson


Query

select ddate, dnumbertables23008 from factsqlengineam_vec_orc where ddate = "2013-01-08 00:00:00"
and dnumbertables23008 = 1052436;

returns rows where dnumbertables23008 != 1052436.

Actual results:

636087 rows 

Sample:

...
2013-01-08 00:00:00     0
2013-01-08 00:00:00     0
2013-01-08 00:00:00     108
2013-01-08 00:00:00     0
2013-01-08 00:00:00     0
2013-01-08 00:00:00     1625
2013-01-08 00:00:00     210
2013-01-08 00:00:00     0
2013-01-08 00:00:00     209
2013-01-08 00:00:00     0
...

Expected results:

Either no rows returned, or all rows have 1052436 in second column.


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

Mime
View raw message