Description
SemiJoinRule should not apply to RIGHT and FULL JOIN; and it should strip LEFT JOIN once it has disovered that the rows from the right input are unique.
Original description:
For IN and EXISTS sub-queries Calcite currently generates plan consisting of GROUP BY on inner table followed by INNER JOIN with outer table. Such cases could be converted using this rule to use SEMI-JOIN to make it more efficient.
Attachments
Issue Links
- is related to
-
CALCITE-330 Add a rule that converts join-on-aggregate to semi-join
-
- Closed
-