You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2017/05/19 11:33:05 UTC

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

Jesus Camacho Rodriguez created CALCITE-1797:
------------------------------------------------

             Summary: 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)