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

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Assignee: Andrey Mashenkov
• Reporter: Roman Kondakov
• Created: 19/Apr/20 11:44
• Updated: 15/May/20 18:20
• Resolved: 15/May/20 18:20

Description

We need to add  next rules to planner

• FilterJoinRule
• JoinPushExpressionsRule

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

"select d.deptno, e.deptno from sales.dept d, sales.emp e\n"
    + " where d.deptno + 10 = e.deptno * 2"

BEFORE=
LogicalProject(DEPTNO=[$0], DEPTNO0=[$5])
  LogicalFilter(condition=[=(+($0, 10), *($5, 2))])
    LogicalJoin(condition=[true], joinType=[inner])
      IgniteTableScan(table=[[PUBLIC, DEPT]])
      IgniteTableScan(table=[[PUBLIC, EMP]])

AFTER=
IgniteProject(DEPTNO=[$0], DEPTNO0=[$5])
  IgniteJoin(condition=[=(+($0, 10), *($5, 2))], joinType=[inner])
    IgniteTableScan(table=[[PUBLIC, DEPT]])
    IgniteTableScan(table=[[PUBLIC, EMP]])

 

 

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #7803