[ https://issues.apache.org/jira/browse/HIVE-25240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa updated HIVE-25240: ---------------------------------- Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master. Thanks [~jcamachorodriguez] for review. > 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 > Labels: CBO, materializedviews, pull-request-available > Fix For: 4.0.0 > > Time Spent: 0.5h > Remaining Estimate: 0h > > {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)