Steve Carlin created HIVE-22258:
-----------------------------------
Summary: Rewriting fails for `IN` clauses in MV and query when we
use equals or subset in the query
Key: HIVE-22258
URL: https://issues.apache.org/jira/browse/HIVE-22258
Project: Hive
Issue Type: Sub-task
Components: CBO
Affects Versions: 3.1.2
Reporter: Steve Carlin
Attachments: in-pred.sql
...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;
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
