calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Haisheng Yuan (Jira)" <>
Subject [jira] [Created] (CALCITE-3968) Disable JoinPushThroughJoinRule.left by default
Date Sat, 02 May 2020 15:48:00 GMT
Haisheng Yuan created CALCITE-3968:

             Summary: Disable JoinPushThroughJoinRule.left by default
                 Key: CALCITE-3968
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Haisheng Yuan

JoinPushThroughJoinRule.right does 
(RS)T -> (RT)S

JoinPushThroughJoinRule.left does
(RS)T -> (TS)R 

If JoinCommuteRule is enabled, only enabling JoinPushThroughJoinRule.right can achieve the
same alternative with JoinPushThroughJoinRule.left, vice versa (suppose they are connected).
So there is no need to enable left and right instances at the same time, which will slow down
the optimization dramatically, e.g TPCH q05, q07 in never finish. There is also
the same bug report from [1].

Meanwhile, JoinPushThroughJoinRule matches RelNode.class, which is unnecessary. It should
be just a group, or RelSet / RelSubset, as a place holder, because we don't care about what
exactly the top join's right child is. But since the rule is designed to work with both HepPlanner
and VolcanoPlanner, so just bear with the slowness.


This message was sent by Atlassian Jira

View raw message