Re: is there any tool class to generate RexNodes from a SQL command?

2016-09-14 Thread bluejoe
By the way, I took an insight into the PlanerImpl.validate(): public SqlNode validate(SqlNode sqlNode) throws ValidationException { ensure(State.STATE_3_PARSED); this.validator = new CalciteSqlValidator( operatorTable, createCatalogReader(), typeFactory);

Re: when Calcite will support windowing, like TUMBLE, HOP

2016-09-14 Thread Julian Hyde
We’d like to add these, and there are JIRA cases logged, e.g. https://issues.apache.org/jira/browse/CALCITE-768 , but we have not committed to a particular timeline. > On Sep 14, 2016, at 1:00 AM, Yuan,Youjun wrote: > >

Re: is there any tool class to generate RexNodes from a SQL command?

2016-09-14 Thread jordan.halter...@gmail.com
You have to run planner.validate after parse, otherwise the state in PlannerImpl will be incorrect. You can also go into the PlannerImpl and steal some code if you need to circumvent those states, but I agree this is probably the easiest way to go about it. The alternative is just creating a

[jira] [Created] (CALCITE-1375) Why "select CONCAT('a','b') from EMPS" won't work?

2016-09-14 Thread hongbin ma (JIRA)
hongbin ma created CALCITE-1375: --- Summary: Why "select CONCAT('a','b') from EMPS" won't work? Key: CALCITE-1375 URL: https://issues.apache.org/jira/browse/CALCITE-1375 Project: Calcite Issue

Re: is there any tool class to generate RexNodes from a SQL command?

2016-09-14 Thread bluejoe
Hi, Hyde I wrote code like this: FrameworkConfig config = Frameworks.newConfigBuilder().build(); Planner planner = Frameworks.getPlanner(config); SqlNode node = planner.parse(sql); RelRoot relRoot = planner.rel(node); RelNode project =