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
