This is not a released version so we can't do this quite yet but at some point we need to update to the latest calcite or update to 1.26 and include PRs that solve issues we have found regarding correlation being inserted into queries where it doesn't make sense for us.
This being said I do think we can start doing some work improving the optimized plans that come of of the queries that are parsed properly. @dsusanibarblazing can you add examples of the relational algebra output that we were getting that was less optimal than we hoped for?
This is not a released version so we can't do this quite yet but at some point we need to update to the latest calcite or update to 1.26 and include PRs that solve issues we have found regarding correlation being inserted into queries where it doesn't make sense for us.
This being said I do think we can start doing some work improving the optimized plans that come of of the queries that are parsed properly. @dsusanibarblazing can you add examples of the relational algebra output that we were getting that was less optimal than we hoped for?