Thanks Stamatis. Apologies for the noise. Reminds me not to send emails before a cup of coffee...
On Mon, Sep 27, 2021 at 2:32 PM Stamatis Zampetakis <[email protected]> wrote: > > 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 > > -- Regards, Atri l'apprenant
