[HIVE-4680] second clause of OR filter not applied in vectorized query execution - ASF JIRA

XML

Word

Printable

JSON

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;

is related to

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