Hi Atri, The timestamp literal seems to be missing a closing quote '2021-01-01 vs '2021-01-01'.
Best, Stamatis On Mon, Sep 27, 2021 at 10:59 AM Atri Sharma <[email protected]> wrote: > 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 >
