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

["Roman Kondakov (Jira)" <ji...@apache.org>]

Roman Kondakov created IGNITE-12914:
---------------------------------------

             Summary: Calcite integration: Add aggregate project merge rule to the planner
                 Key: IGNITE-12914
                 URL: https://issues.apache.org/jira/browse/IGNITE-12914
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Roman Kondakov


We need to add  next rules to planner
 * FilterJoinRule,
 * JoinAddRedundantSemiJoinRule,
 * SemiJoinRemoveRule

In order to be able to make this transformation for the query:
{noformat}
"select e.ename from emp e, dept d\n"
        + "where e.deptno = d.deptno"

BEFORE=
LogicalProject(ENAME=[$1])
  LogicalFilter(condition=[=($3, $5)])
    LogicalJoin(condition=[true], joinType=[inner])
      IgniteTableScan(table=[[PUBLIC, EMP]])
      IgniteTableScan(table=[[PUBLIC, DEPT]])

AFTER=
IgniteProject(ENAME=[$1])
  IgniteJoin(condition=[=($3, $5)], joinType=[inner])
    IgniteTableScan(table=[[PUBLIC, EMP]])
    IgniteTableScan(table=[[PUBLIC, DEPT]])
{noformat}
 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)