[ https://issues.apache.org/jira/browse/HIVE-25240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa updated HIVE-25240: ---------------------------------- Summary: Query Text based MaterializedView rewrite of subqueries (was: Query Text based MaterializedView rewrite if subqueries) > Query Text based MaterializedView rewrite of subqueries > ------------------------------------------------------- > > Key: HIVE-25240 > URL: https://issues.apache.org/jira/browse/HIVE-25240 > Project: Hive > Issue Type: Improvement > Reporter: Krisztian Kasa > Assignee: Krisztian Kasa > Priority: Major > > {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)