[jira] [Created] (CALCITE-1182) Add ProjectRemoveRule to pre-processing program of materialization substitution

["Maryann Xue (JIRA)" <ji...@apache.org>]

Maryann Xue created CALCITE-1182:
------------------------------------

             Summary: Add ProjectRemoveRule to pre-processing program of materialization substitution
                 Key: CALCITE-1182
                 URL: https://issues.apache.org/jira/browse/CALCITE-1182
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Maryann Xue
            Assignee: Maryann Xue
            Priority: Minor


In VolcanoPlanner, we apply a simple pre-processing hep program to normalize the "target" and "query" rels before materialization substitution. Currently this program runs with two rules: FilterProjectTransposeRule and ProjectMergeRule.
We need an extra rule ProjectRemoveRule for the Phoenix use case where a secondary index (modeled as materialized views) is defined on a view so the materialized view "queryRel" may have an identity projection introduced by this view.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)