You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Michael Mior (JIRA)" <ji...@apache.org> on 2016/10/14 14:25:20 UTC
[jira] [Updated] (CALCITE-1440) Implement planner for converting
multiple SQL statements to unified RelNode Tree
[ 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)