[CALCITE-1495] SemiJoinRule should not apply to RIGHT and FULL JOIN

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Vineet Garg
• Created: 16/Nov/16 00:19
• Updated: 06/Jan/17 19:30
• Resolved: 02/Dec/16 18:20

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.

Issue Links

• is related to: CALCITE-330 Add a rule that converts join-on-aggregate to semi-join