calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Γιώργος Θεοδωράκης <giwrgosrth...@gmail.com>
Subject How to use VolcanoPlanner
Date Mon, 03 Oct 2016 15:51:36 GMT
Hi,

I want to parse an Sql query and transform it to an optimized relational
plan (not convert it to physical !!) using calcite rules based on my
database schema and metadata. Right now, the only helpful example I have
found for my purpose is taken from
https://github.com/milinda/samza-sql/blob/master/samza-sql-planner/src/main/java/org/apache/samza/sql/planner/QueryPlanner.java
,
in which a simple Planner is used for parsing and validating Sql and a
HepPlanner is used for searching for an optimized plan based on imported
rules.

Is there any way to use in my case the VolcanoPlanner? The only examples I
have seen so far from the test classes suggest that it should be used for
converting relational expressions to physical ones. How can I make the
Volcano Planner "see" my SchemaPlus schema ,when I can only define
RelOptSchema? Can someone provide me with a complete example of using
Volcano Planner and adding rules, such
as FilterProjectTransposeRule.INSTANCE?

Thanks in advance,
George

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