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
