A note I forgot to mention earlier is that I’m starting with a RelBuilder...
On Fri, 27 Mar 2020 at 15:59, Chris Channing <[email protected]> wrote: > Hey Folks, > > Is it currently possible to have Calcite optimize-away unnecessary joins? > The case I'm thinking of is where (hopefully the formatting holds up!): > > ...you have a bushy tree as follows: > > --------------------- > | | > | | > |--------| |---------| > T1 T2 T2 T3 > > ...which could be rewritten as a left-deep tree to avoid scanning T2 again: > > |-------------------| > | | > |----------| | > T1 T2 T3 > > If so, does any have an example of how to do this please? > > Many thanks, > Chris > >
