Parse PostgreSQL query using Calcite-BABEL

config for using BABEL: * val sqlParserConfig = SqlParser.configBuilder() .setParserFactory(SqlBabelParserImpl.FACTORY) .setConformance(SqlConformanceEnum.BABEL) .build()* *SqlParser.create(sql,sqlParserConfig).parseQuery()* but this gave me exception on *.time (Was expecting one of)* *S

Re: Not able use PostgresDialect.

e. > > Best, > Danny Chan > 在 2020年2月14日 +0800 PM3:58，Shivraj Singh ，写道： > > Thanks @Danny Chan , > > > > Please tell me one more thing: > > Just curious what does the PostgresSqlDialect accomplish in Calcite, if > not > > to parse postgres sqls? > >

Re: Not able use PostgresDialect.

Thanks, @Stamatis Zampetakis, SqlBabelParserImpl where I can find this class. and what config I have to set for BABEL parser. *Shivraj Singh* Software Consultant Knoldus Inc. <http://www.knoldus.com> +91-8800782123 Canada - USA - India - Singapore <https://in.linkedin.com/company/knoldu

Re: Not able use PostgresDialect.

Thanks @Danny Chan , Please tell me one more thing: Just curious what does the PostgresSqlDialect accomplish in Calcite, if not to parse postgres sqls? *Shivraj Singh* Software Consultant Knoldus Inc. <http://www.knoldus.com> +91-8800782123 Canada - USA - India - Singapore

Re: Not able use PostgresDialect.

build() SqlParser.create(new SourceStringReader(sql),sqlParserConfig).parseQuery() Am I doing something wrong? *Shivraj Singh* Software Consultant Knoldus Inc. <http://www.knoldus.com> +91-8800782123 Canada - USA - India - Singapore <https://in.linkedin.com/company/knoldus> <

Not able use PostgresDialect.

_state) VALUES (?, ?::system_state_type) exception I got: org.apache.calcite.sql.parser.SqlParseException: Encountered "*:*" at line. Was expecting one of: "EXCEPT" ... Please help me 1. How to parse these queries? 2. Can we parse query using PostgresqlSqlDialect, if yes the