You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Wang, Ken" <mi...@ebay.com.INVALID> on 2018/11/20 06:06:55 UTC

JoinPushThroughJoinRule and JoinAssociateRule in calcite

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

Re: JoinPushThroughJoinRule and JoinAssociateRule in calcite

Posted by Anton Haidai <an...@gmail.com>.

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 <mi...@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.