According to my testing, some join configurations are unreachable by default rules, here is a bug about it with a possible cause suggestion: https://issues.apache.org/jira/browse/CALCITE-2666
On Tue, Nov 20, 2018 at 8:07 AM Wang, Ken <mingmw...@ebay.com.invalid> wrote: > Hi, Julian > > I’m reading Apache Calcite source code. There are some rules for Join > order enumeration: JoinPushThroughJoinRule, JoinCommuteRule and > JoinAssociateRule. > By default, JoinAssociateRule is disabled. > > Does JoinPushThroughJoinRule + JoinCommuteRule prove to be complete to > generate all the search space for Join ordering? > And why we prefer use JoinPushThroughJoinRule instead of JoinAssociateRule? > > Thanks > Ken > > -- Best regards, Anton.