You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Ziwei Liu (Jira)" <ji...@apache.org> on 2021/12/20 08:38:00 UTC
[jira] [Updated] (CALCITE-4909) In SubstituteVisitor, if there is a calc on target's agg, the query will not be rewritten by materialized view.
[ https://issues.apache.org/jira/browse/CALCITE-4909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ziwei Liu updated CALCITE-4909:
-------------------------------
Description:
sql("select 'a',\"empid\",\"deptno\",sum(\"salary\") as s from \"emps\" group by \"empid\",\"deptno\"", "select sum(\"salary\") +1 as s,\"deptno\" from \"emps\" group by \"deptno\"").noMat();
In substitute processing, this case will not be rewritten by materialized view because there is a Calc RelNode on target's agg. We may need a rule AggregateOnCalcToCalcOnAggregateUnifyRule to handle this condition.
was:
sql("select 'a',\"empid\",\"deptno\",sum(\"salary\") as s from \"emps\" group by \"empid\",\"deptno\"", "select sum(\"salary\") +1 as s,\"deptno\" from \"emps\" group by \"deptno\"").noMat();
In substitute processing, this case will not be rewritten by materialized view because there is a calc on target's agg. We may need a rule AggregateOnCalcToCalcOnAggregateUnifyRule to handle this condition.
> In SubstituteVisitor, if there is a calc on target's agg, the query will not be rewritten by materialized view.
> ---------------------------------------------------------------------------------------------------------------
>
> Key: CALCITE-4909
> URL: https://issues.apache.org/jira/browse/CALCITE-4909
> Project: Calcite
> Issue Type: Improvement
> Reporter: Ziwei Liu
> Assignee: Ziwei Liu
> Priority: Major
>
> sql("select 'a',\"empid\",\"deptno\",sum(\"salary\") as s from \"emps\" group by \"empid\",\"deptno\"", "select sum(\"salary\") +1 as s,\"deptno\" from \"emps\" group by \"deptno\"").noMat();
> In substitute processing, this case will not be rewritten by materialized view because there is a Calc RelNode on target's agg. We may need a rule AggregateOnCalcToCalcOnAggregateUnifyRule to handle this condition.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)