Thanks for the reply. I dont think that was the case (I am not running from SQLLine, but from a custom Calcite integration).
I think it was something to do with the timestamp formatting, fixing that seems to work. Let me try a couple of other queries and revert. On Mon, Sep 27, 2021 at 2:11 PM hongkang jiang <[email protected]> wrote: > > "SELECT COUNT(*) FILTER (WHERE timestampColumn > '2021-01-01), > timestampColumn FROM testTable WHERE timestampColumn > '2021-01-01" > + "00:00:00.123' GROUP BY timestampColumn" > > There's a semicolon missing. > > On Mon, Sep 27, 2021 at 4:34 PM Atri Sharma <[email protected]> wrote: > > > Using the Babel parser, I get an error while parsing the following query: > > > > "SELECT COUNT(*) FILTER (WHERE timestampColumn > '2021-01-01), > > timestampColumn FROM testTable WHERE timestampColumn > '2021-01-01" > > + "00:00:00.123' GROUP BY timestampColumn" > > > > The exception raised is: > > > > Caused by: org.apache.calcite.sql.parser.SqlParseException: > > Encountered "2021" at line 1, column 119. > > Was expecting one of: > > ")" ... > > "." ... > > <QUOTED_STRING> ... > > "UESCAPE" ... > > "NOT" ... > > "IN" ... > > "<" ... > > "<=" ... > > ">" ... > > ">=" ... > > "=" ... > > "<>" ... > > "!=" ... > > "BETWEEN" ... > > "LIKE" ... > > "SIMILAR" ... > > "+" ... > > "-" ... > > "*" ... > > "/" ... > > > > What am I missing, please? > > > > > > -- > > Regards, > > > > Atri > > l'apprenant > > -- Regards, Atri l'apprenant
