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)