Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-12915

Calcite integration: Add push filter to join rule to the planner

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sql
    • Labels:
      None

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

       

       

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              amashenkov Andrey Mashenkov
              Reporter:
              rkondakov Roman Kondakov

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 0.5h
                0.5h

                  Issue deployment