[IGNITE-12914] Calcite integration: Add aggregate project merge rule to the planner

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite2-required calcite3-required
• Assignee: Unassigned
• Reporter: Roman Kondakov
• Created: 19/Apr/20 11:41
• Updated: 18/Jun/21 09:34

Description

We need to add  next rules to planner

• AggregateProjectMergeRule

In order to be able to make this transformation for the query:

"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]])

 

 

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine