Thanks Jiajun. It looks like the following syntax with the backticks works for me.
SELECT CAST(NULL AS `MAP<STRING, STRING>`) FROM schema.table Thomas On Sun, Oct 1, 2023 at 11:23 PM Jiajun Xie <jiajunbernou...@gmail.com> wrote: > Hi Thomas, > > Cast map syntax is not supported in the current release version. > But we will support it in the 1.36.0 version. > > FYI: https://issues.apache.org/jira/browse/CALCITE-5570 > > On Sun, 1 Oct 2023 at 22:38, Thomas Wang <w...@datability.io> wrote: > > > Hi Mihai, > > > > Could you point me to more information w.r.t modifying the parser? Also, > I > > noticed for the ARRAY type, I can do CAST(NULL AS BIGINT ARRAY), but the > > grammar doesn't seem to have MAP supported, does it? Did I miss > something? > > Thanks. > > > > Thomas > > > > On Sat, Sep 30, 2023 at 7:59 PM Mihai Budiu <mbu...@gmail.com> wrote: > > > > > Calcite is open source, so you can certainly modify the parser. The > > > architecture of the parser had been designed to be flexible and even > > > calcite has several parsers, the strandard one, server, and Babel. Let > me > > > know if you need help figuring out how to roll your own. > > > > > > Mihai > > > ________________________________ > > > From: Thomas Wang <w...@datability.io> > > > Sent: Saturday, September 30, 2023 7:42:19 PM > > > To: dev@calcite.apache.org <dev@calcite.apache.org> > > > Subject: Re: SQL Parsing > > > > > > Thanks Mihai, "BIGINT ARRAY" seems to work! Just curious if I can have > > > flexibility to change the behavior of the parse to parse > "ARRAY<BIGINT>" > > > instead? > > > > > > Thomas > > > > > > On Sat, Sep 30, 2023 at 6:32 PM Mihai Budiu <mbu...@gmail.com> wrote: > > > > > > > The syntax is "bigint array" > > > > https://calcite.apache.org/docs/reference.html > > > > ________________________________ > > > > From: Thomas Wang <w...@datability.io> > > > > Sent: Saturday, September 30, 2023 6:27:46 PM > > > > To: dev@calcite.apache.org <dev@calcite.apache.org> > > > > Subject: SQL Parsing > > > > > > > > Hi Apache Calcite Community, > > > > > > > > I'm new to Apache Calcite and trying to use it for SQL parsing and > SQL > > > > rewriting. > > > > > > > > I tried to parse a couple of SELECT statements and it works pretty > > well. > > > > However, when I tried to parse a SELECT statement that contains a > cast > > to > > > > array like below, it complains it cannot recognize ARRAY. > > > > > > > > SELECT CAST(NULL AS ARRAY<BIGINT>) FROM schema.t1 > > > > > > > > However, casting to BIGINT seems ok. The following SELECT is ok. > > > > > > > > SELECT CAST(NULL AS BIGINT) FROM schema.t1 > > > > > > > > Is there any configuration I need to enable to enable/support parsing > > > > ARRAY? Thanks. > > > > > > > > Thomas > > > > > > > > > >
