calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chinmay Kolhatkar <chin...@datatorrent.com>
Subject Using VolcanoPlanner to create unified RelNode tree from multiple SQL
Date Tue, 04 Oct 2016 16:23:19 GMT
Dear Community,

I'm working on integration with Apache Apex and Apache Calcite (underlying
Apache Jira is: APEXMALHAR-1818).

I have a question related to conversion from SQL to RelNode Tree.

Is it possible that VolcanoPlanner can 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]


Thanks,
Chinmay.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message