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)