[IGNITE-14810] Calcite. Simple JOIN with f1=f2 cannot be planned with CNLJ.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Not A Bug
• Component/s: sql
• Labels: calcite
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 01/Jun/21 14:27
• Updated: 01/Jun/21 14:45
• Resolved: 01/Jun/21 14:45

Description

For now simple JOIN requests like:

SELECT * FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i

can be planned only through MergeJoin or NestedLoopJoin it would be useful to extend it with CNLJ too. Starting point : FilterSpoolMergeToSortedIndexSpoolRule#onMatch

We have to add new rule FilterSpoolMergeToSortedIndexSpoolRule_ForceCollation which forces collation by the filter condition.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine