[jira] [Resolved] (CALCITE-1797) Support view partial rewriting in aggregate materialized view rewriting

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-1797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez resolved CALCITE-1797.
----------------------------------------------
    Resolution: Fixed

Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/88da6a1.

> Support view partial rewriting in aggregate materialized view rewriting
> -----------------------------------------------------------------------
>
>                 Key: CALCITE-1797
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1797
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>             Fix For: 1.13.0
>
>
> Simple extension for AbstractMaterializedViewRule similar to CALCITE-1791, however for views/queries rooted with an Aggregate node.
> In this case, we need to rely on FK-UK relationship to check whether the missing tables are just appending columns to the view result or even filtering the result, but not changing their multiplicity. If they meet these requirements, we can join the missing tables to the view and the view plan (that will be modified accordingly), and let the rewriting algorithm work the same way and enforce any missing predicate.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)