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

Posted to dev@calcite.apache.org by Abhishek Agarwal <ab...@gmail.com> on 2021/03/03 09:12:10 UTC

Re-write right outer join as left outer join

Hello everyone,

is there an existing rule that can re-write a right outer join as a left
outer join by swapping tables?

Re: Re-write right outer join as left outer join

Posted by Abhishek Agarwal <ab...@gmail.com>.

Yes. Thank you. JoinCommuteRule is what I was looking for.

On Wed, Mar 3, 2021 at 3:53 PM Danny Chan <da...@apache.org> wrote:

> Do you mean the join reordering ?
>
> You can take a look at LoptOptimizeJoinRule and JoinCommuteRule.
>
> Abhishek Agarwal <ab...@gmail.com> 于2021年3月3日周三 下午5:12写道：
>
> > Hello everyone,
> >
> > is there an existing rule that can re-write a right outer join as a left
> > outer join by swapping tables?
> >
>

Re: Re-write right outer join as left outer join

Posted by Danny Chan <da...@apache.org>.

Do you mean the join reordering ?

You can take a look at LoptOptimizeJoinRule and JoinCommuteRule.

Abhishek Agarwal <ab...@gmail.com> 于2021年3月3日周三 下午5:12写道：

> Hello everyone,
>
> is there an existing rule that can re-write a right outer join as a left
> outer join by swapping tables?
>