[ https://issues.apache.org/jira/browse/CALCITE-6134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
SimonAlexs resolved CALCITE-6134. --------------------------------- Resolution: Resolved extend or edit this file for my logic: `calcite/babel/src/main/codegen/includes/parserImpls.ftl` > Can't parse custom function with name 'DATEADD' in babel > -------------------------------------------------------- > > Key: CALCITE-6134 > URL: https://issues.apache.org/jira/browse/CALCITE-6134 > Project: Calcite > Issue Type: Bug > Components: babel > Affects Versions: 1.36.0 > Reporter: SimonAlexs > Priority: Major > > h4. *1. config* > I use SqlBabelParserImpl.FACTORY, and create SqlCustomOperatorTable.java > which extends org.apache.calcite.sql.fun.SqlStdOperatorTable. > {code:java} > Frameworks.newConfigBuilder() > .parserConfig(SqlParser.config() > .withLex(Lex.MYSQL) > .withCaseSensitive(false) > .withConformance(SqlConformanceEnum.MYSQL_5) > .withParserFactory(SqlBabelParserImpl.FACTORY) > ) > .operatorTable(SqlCustomOperatorTable.instance()) {code} > In my SqlCustomOperatorTable, I define my custom function named with > 'DATEADD'. > h4. *2. error* > When i try the sql below, i got error as follows. > {code:java} > select dateadd(1698389166000, interval 1 year) {code} > {code:java} > Encountered "1698389166000" at line 1, column 16. > Was expecting one of: > <IDENTIFIER> ... > <HYPHENATED_IDENTIFIER> ... > <QUOTED_IDENTIFIER> ... > <BACK_QUOTED_IDENTIFIER> ... > <BIG_QUERY_BACK_QUOTED_IDENTIFIER> ... > <BRACKET_QUOTED_IDENTIFIER> ... > <UNICODE_QUOTED_IDENTIFIER> ... {code} > Is 'DATEADD' a reserved word? Is there any method to let me create a > custom function with name 'DATEADD'? > Thanks for your help. -- This message was sent by Atlassian Jira (v8.20.10#820010)