Hi Julian, Look like error was due to an old jar. Query went through parsing after cleaning and rebuilding Calcite. But I am still getting
"Streaming aggregation requires at least one monotonic expression in GROUP BY clause". Most probably this should be due to incompatibilities in my query planner code and new changes to 'chi' branch. I'll debug and see whats going on. Thanks for the help. Milinda On Fri, Mar 6, 2015 at 3:33 PM, Julian Hyde <[email protected]> wrote: > We support “FLOOR(rowtime TO HOUR)”. The “TO” is part of the syntax of the > FLOOR function, just as “AS” is part of the cast syntax “CAST(1.5 AS > DOUBLE)”. > > And we support the CEIL function: "CEIL(rowtime TO DAY)”. > > What query did you try? Did you re-generate the parser (“mvn clean”)? > > Julian > > > On Mar 6, 2015, at 12:28 PM, Milinda Pathirage <[email protected]> > wrote: > > > Hi Julian, > > > > Is expressions like 'rowtime TO HOUR' supported in 'chi' branch. I am > > getting a parser error when I tried a sample query from > > https://github.com/julianhyde/incubator-calcite/blob/chi/doc/STREAM.md > with > > latest build from 'chi' branch. > > > > Thanks > > Milinda > > > > > > -- > > Milinda Pathirage > > > > PhD Student | Research Assistant > > School of Informatics and Computing | Data to Insight Center > > Indiana University > > > > twitter: milindalakmal > > skype: milinda.pathirage > > blog: http://milinda.pathirage.org > > -- Milinda Pathirage PhD Student | Research Assistant School of Informatics and Computing | Data to Insight Center Indiana University twitter: milindalakmal skype: milinda.pathirage blog: http://milinda.pathirage.org
