[HIVE-22258] Rewriting fails for `IN` clauses in MV and query when we use equals or subset in the query - ASF JIRA

XML

Word

Printable

JSON

...as stated in title. Script is attached. The issue can be seen with these queries:

create materialized view av1 stored as orc as select state, year, sum(population) from census_pop where year IN (2010, 2018) group by state, year;

– this is ok

explain extended select state, year, sum(population) from census_pop where year IN (2010, 2018) group by state, year;

– this is not ok

explain extended select state, year, sum(population) from census_pop where year = 2010 group by state, year;

– this is not ok

explain extended select state, year, sum(population) from census_pop where year in (2010) group by state, year;

is part of

HIVE-22256 Rewriting fails when `IN` clause has items in different order in MV and query