Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
vectorization-branch
-
None
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.
Attachments
Issue Links
- relates to
-
HIVE-4680 second clause of OR filter not applied in vectorized query execution
- Resolved