[
https://issues.apache.org/jira/browse/CALCITE-1216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15271686#comment-15271686
]
Amogh Margoor commented on CALCITE-1216:
----------------------------------------
Thanks [~julianhyde] . Fixup looks good.
Thanks [~michaelmior] for the review.
> 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
>
> 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)
