[ https://issues.apache.org/jira/browse/CALCITE-1216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde resolved CALCITE-1216. ---------------------------------- Resolution: Fixed Fix Version/s: 1.8.0 Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/bf098dd6; thanks for the PR, [~amargoor]! > Add new rules for Materialised view optimisation of join queries > ---------------------------------------------------------------- > > Key: CALCITE-1216 > URL: https://issues.apache.org/jira/browse/CALCITE-1216 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: next > Reporter: Amogh Margoor > Assignee: Amogh Margoor > Priority: Minor > Fix For: 1.8.0 > > > This is to keep track of adding new rules that would enable optimisation > using view of join queries. For instance, when we have materialised view of > table 'X' named 'X_part' defined by query: " select * from X where X.a > > '2016-01-01' " then we expect following query to be optimised by 'X_part': > select * from X inner join Y on X.id = Y.xid inner join Z on Y.id=Z.yid where > X.a > '2016-02-02' and Y.b = "Bangalore" > Following are the changes done in Quark which we are planning to pull into > Calcite: > 1. Add a new Rule for Filter on TableScan. Basically, after predicate has > been pushed through join onto table scan, new rule checks if it can be > optimised by Materialised View. > https://github.com/qubole/quark/blob/master/optimizer/src/main/java/com/qubole/quark/planner/MaterializedViewFilterScanRule.java > 2. Add a new Unify rule to MaterialisedSubstitutionVisitor: > https://github.com/qubole/incubator-calcite/commit/2d031d14d23810291377d92dc5ef2eaa515d35b7 -- This message was sent by Atlassian JIRA (v6.3.4#6332)