Krisztian Kasa created HIVE-25240:
-------------------------------------
Summary: Query Text based MaterializedView rewrite if subqueries
Key: HIVE-25240
URL: https://issues.apache.org/jira/browse/HIVE-25240
Project: Hive
Issue Type: Improvement
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa
{code}
create materialized view mat1 as
select col0 from t1 where col0 > 1;
explain cbo
select col0 from
(select col0 from t1 where col0 > 1) sub
where col0 = 10;
{code}
{code}
HiveProject(col0=[CAST(10):INTEGER])
HiveFilter(condition=[=($0, 10)])
HiveTableScan(table=[[default, mat1]], table:alias=[default.mat1])
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
