[IGNITE-13744] Calcite. Use TableSpool for IgniteNestedLoopJoin

• Type: Bug
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite calcite2-required calcite3-required iep-96
• Assignee: Evgeny Stanilovsky
• Reporter: Taras Ledkov
• Created: 23/Nov/20 10:14
• Updated: 26/Oct/22 15:47

Description

Now NestedLoopJoinNode uses internal buffer to save all rows of the right input.
We have to do refactoring IgniteNestedLoopJoin to use rewind of the right input and use TableSpool for not rewindable inputs.

This refactoring separates implementation the join logic from materialization of the right input if it is needed. In the future we can use disk offload for TableSpool etc.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #9168