[jira] [Created] (FLINK-12937) Introduce join reorder planner rules in blink planner

[Shang Yuanchun (Jira)]

godfrey he created FLINK-12937:
----------------------------------

             Summary: Introduce join reorder planner rules in blink planner
                 Key: FLINK-12937
                 URL: https://issues.apache.org/jira/browse/FLINK-12937
             Project: Flink
          Issue Type: New Feature
          Components: Table SQL / Planner
            Reporter: godfrey he
            Assignee: godfrey he


This issue aims to let blink planner support join reorder. `LoptOptimizeJoinRule` in Calcite could meet our requirement for now, so we could use directly this rule in blink planner. `JoinToMultiJoinRule` , `ProjectMultiJoinMergeRule` and `FilterMultiJoinMergeRule` should be also introduced to support `LoptOptimizeJoinRule`.

additionally, we add a new rule named `RewriteMultiJoinConditionRule` which could apply transitive closure on `MultiJoin` for equi-join predicates to create more optimization possibilities.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)