[jira] [Created] (IGNITE-12915) Calcite integration: Add push filter to join rule to the planner

[Anton Vinogradov (Jira)]

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)