I’ve filed CALCITE-5631 with the example in SQL and RelNode forms
https://issues.apache.org/jira/browse/CALCITE-5631
-Ian
l have the same issue as general joins?
>
> Thanks!
> -Ian
>
> From: Stamatis Zampetakis
> Date: Thursday, March 30, 2023 at 1:41 AM
> To: dev@calcite.apache.org
> Subject: [External Sender] Re: Rules to squash redundant join sides?
> Hey Ian,
>
> I think
Subject: [External Sender] Re: Rules to squash redundant join sides?
Hey Ian,
I think you are referring to the problem of query minimization and at
the moment we don't have any such rules in Calcite but it would be a
valuable contribution.
Apart from the algorithm itself, it might be necessary
Hey Ian,
I think you are referring to the problem of query minimization and at
the moment we don't have any such rules in Calcite but it would be a
valuable contribution.
Apart from the algorithm itself, it might be necessary to introduce
some new metadata provider for PK-FK relationships
Howdy,
Is there a collection of rules which squash a tree of binary joins if the same
side of each join is mergeable?
For example:
```
201:LogicalProject(P4=[$70], P5=[$72])
└─ 199:LogicalJoin(condition=[=($0, $71)], joinType=[left])
├─ 190:LogicalProject(...)
| └─