[ 
https://issues.apache.org/jira/browse/CALCITE-1440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Michael Mior updated CALCITE-1440:
----------------------------------
    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:

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

  was:
This can be implemented as a seperate 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';

Above 2 statements has a common path and hence can provide an unified RelNode 
tree as follows:

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


> Implement planner for converting multiple SQL statements to unified RelNode 
> Tree
> --------------------------------------------------------------------------------
>
>                 Key: CALCITE-1440
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1440
>             Project: Calcite
>          Issue Type: New Feature
>            Reporter: Chinmay Kolhatkar
>            Assignee: Julian Hyde
>
> 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:
> {noformat}
>  [Scan] -> [Project (COL1, COL2)] -> [Filter (COL4 = 'abc')] -> [Delta]
>                     |
>                     V
>             [Filter (COL3 > 10)]
>                     |
>                     v
>                  [Delta]
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to