[HIVE-4678] second clause of AND, OR filter not applied for vectorized execution

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: vectorization-branch
• Fix Version/s: 0.13.0
• Component/s: Query Processor
• Assignee: Jitendra Nath Pandey
• Reporter: Eric N. Hanson
• Created: 06/Jun/13 20:26
• Updated: 24/Mar/14 20:38
• Resolved: 08/Jun/13 16:37

Description

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.

Issue Links

• relates to: HIVE-4680 second clause of OR filter not applied in vectorized query execution