[CALCITE-1440] Implement planner for converting multiple SQL statements to unified RelNode Tree

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Chinmay Kolhatkar
• Created: 14/Oct/16 04:38
• Updated: 28/Feb/24 06:03

Description

This can be implemented as a separate planner or in VolcanoPlanner itself. The planner should take multiple SQL statements as input and return a unified RelNode tree.

Example of above is as follows:

SELECT COL1, COL2 FROM TABLE WHERE COL3 > 10;
SELECT COL1, COL2 FROM TABLE WHERE COL4 = 'abc';

The above 2 statements have a common path and hence can provide a unified RelNode tree as follows:

 [Scan] -> [Project (COL1, COL2)] -> [Filter (COL4 = 'abc')] -> [Delta]
                    |
                    V
            [Filter (COL3 > 10)]
                    |
                    v
                 [Delta]

Issue Links

• is related to: CALCITE-481 Add "Spool" operator, to allow re-use of relational expressions
• relates to: CALCITE-6188 Multi-query optimization