Hello, SqlParserTest might help you. It has some checks related to BIG_QUERY. Maybe a .parserConfig(SqlParser.Config.DEFAULT.withConformance(SqlConformanceEnum.BIG_QUERY)) could fix the problem.
Cordialement / Best Regards, *Thomas Rebele, PhD* | R&D Developer | Germany | www.tibco.com On Fri, Feb 4, 2022 at 12:57 PM Dmitry Sysolyatin <dm.sysolya...@gmail.com> wrote: > Hi! > I have a problem with ARRAY_CONCAT operator. > > The following code failed with the exception ''No match found for function > signature array_concat(<INTEGER ARRAY>, <INTEGER ARRAY>)". > ``` > val config = Frameworks.newConfigBuilder() > .parserConfig(parserConfig) > .defaultSchema(CalciteSchema.createRootSchema(false, false).plus()) > .operatorTable(SqlOperatorTables.chain( > SqlStdOperatorTable.instance(), > SqlLibraryOperatorTableFactory.INSTANCE.getOperatorTable( > SqlLibrary.BIG_QUERY > ))) > .programs(Programs.standard()) > .build() > val planner = Frameworks.getPlanner(config) > > val query = "SELECT ARRAY_CONCAT(ARRAY[1, 2], ARRAY[2, 3])" > val parsedSqlNode = planner.parse(query) > planner.validate(parsedSqlNode) > ``` > > Am I doing something wrong or it is a bug? >
