Roman Kondakov created IGNITE-12915:
---------------------------------------
Summary: Calcite integration: Add push filter to join rule to the
planner
Key: IGNITE-12915
URL: https://issues.apache.org/jira/browse/IGNITE-12915
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Roman Kondakov
We need to add next rules to planner
* AggregateProjectMergeRule
In order to be able to make this transformation for the query:
{noformat}
"select x, sum(z), y from (\n"
+ " select deptno as x, empno as y, sal as z, sal * 2 as zz\n"
+ " from emp)\n"
+ "group by x, y"
BEFORE=
LogicalProject(X=[$0], EXPR$1=[$2], Y=[$1])
LogicalAggregate(group=[{0, 1}], EXPR$1=[SUM($2)])
LogicalProject(X=[$3], Y=[$0], Z=[$2])
IgniteTableScan(table=[[PUBLIC, EMP]])
AFTER=
IgniteProject(X=[$0], EXPR$1=[$2], Y=[$1])
IgniteProject(DEPTNO=[$1], EMPNO=[$0], EXPR$1=[$2])
IgniteAggregate(group=[{0, 3}], EXPR$1=[SUM($2)])
IgniteTableScan(table=[[PUBLIC, EMP]])
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
