calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chinmay Kolhatkar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-1440) Implement planner for converting multiple SQL statements to unified RelNode Tree
Date Fri, 14 Oct 2016 04:39:20 GMT
Chinmay Kolhatkar created CALCITE-1440:
------------------------------------------

             Summary: 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 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]



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

Mime
View raw message