CREATE TABLE is not supported ?

2017-11-11 Thread Enrico Olivelli
Hi, I am trying to use Calcite as planner, I get this error using latest master. Is create table not supported ? If not maybe I can try to provide an implementation and a PR if someone could give me some hint about where to start Thanks Enrico org.apache.calcite.sql.parser.SqlParseException: En

Re: Volcano planner

2017-11-11 Thread Enrico Olivelli
Sorry I cannot make it work for INSERT/DELETE/UPDATE This is the error for a DELETE Qury: DELETE FROM MYTABLE where id=1 -- Logical Plan LogicalTableModify(table=[[x, MYTABLE]], operation=[DELETE], flattened=[true]) LogicalProject(id=[$0], name=[$1]) LogicalFilter(condition=[=($0, 1)])

Re: Project + Sort on single and on multiple columns

2017-11-11 Thread Christian Tzolov
@Julian, this exactly what i would expect as logical behavior. In fact it (consistently) behaves like this (e.g. Sort is after Project) when the Sort is on a single column! But for some reasons if the Sort is performed on two columns (same used in the Project) then the Sort is performed before th

Network access to /vlsi/calcite-test-dataset VM

2017-11-11 Thread Christian Tzolov
I'm adding Apache Geode provisioning to the /vlsi/calcite-test-dataset test VM I can build and start the Vagrant environment, i can "vagrant ssh" and verify that all the services are running that the required ports are forwarded. But i can't access those services from the host (MacOSX) machine. T

Re: CREATE TABLE is not supported ?

2017-11-11 Thread James
yes,ddl is not supported. Enrico Olivelli 于2017年11月11日 周六下午5:41写道: > Hi, > I am trying to use Calcite as planner, I get this error using latest > master. > Is create table not supported ? > > If not maybe I can try to provide an implementation and a PR if someone > could give me some hint about w

Re: Volcano planner

2017-11-11 Thread Enrico Olivelli
Got it by myself, the Table must implement ModifiableTable. As far as I am learning the planner is driven by the properties of the Table, expressed using intefaces I wonder if there is some summary of the behavior of the planner or some basic Glossary Cheers Enrico 2017-11-11 11:27 GMT+01:00 Enr

[jira] [Created] (CALCITE-2048) Create a better documentation for the Planner design

2017-11-11 Thread Edmon Begoli (JIRA)
Edmon Begoli created CALCITE-2048: - Summary: Create a better documentation for the Planner design Key: CALCITE-2048 URL: https://issues.apache.org/jira/browse/CALCITE-2048 Project: Calcite Is

Re: Recycling Planner objects

2017-11-11 Thread Edmon Begoli
Enrico, I created an issue for this: https://issues.apache.org/jira/browse/CALCITE-2048 Please add your thoughts, findings, instructions, and comments into the issue itself, and we'll translate these into the material for the site. Thank you, Edmon On Fri, Nov 10, 2017 at 3:50 PM, Enrico Olivel

A guide to Planner

2017-11-11 Thread Edmon Begoli
Calcite planner implementer(s): Could you give me a quick pointer on how to best navigate and study the planner code, so that I could write a proper documentation as the community desires, and maybe write an example for a simple custom planner. Give me, if you can, a quick guide on: 1. where to

Re: [DISCUSS] The state of the project - 2017

2017-11-11 Thread Julian Hyde
I agree. Let’s make it actionable: create a JIRA case, and to complete the task we should add the list of components and their owners in one of the web pages. We should make the list of components should line up with the components in JIRA. I don’t think it’s very important how we slice up the p

Re: A guide to Planner

2017-11-11 Thread Julian Hyde
1. I would run planner tests (e.g. RelOptRulesTest, PlannerTest, VolcanoPlannerTest) in a debugger. I would turn on tracing and try to understand the output. Frameworks and Planner may be useful classes if you find it difficult to create the environment needed for a planner. 2. VolcanoPlanner