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
