Re: Creating a parser for Big query

I thought I was already using Babel parser - .withParserFactory(SqlBabelParserImpl.FACTORY) . Care to give me a code snippet? On Fri, Dec 17, 2021 at 2:45 PM Julian Hyde wrote: > Or use Babel parser. > > > On Dec 17, 2021, at 9:35 AM, Maxim Gramin > wrote: > > > > It looks like the parser

Re: Creating a parser for Big query

In the documentation section - https://calcite.apache.org/docs/reference.html - in "Dialect Specific Operator" I can see that "IF" is listed for Big-Query. Based on this I assumed that it should be supported out of the box without extentind the parser. It says that I need to specify a "fun"

Re: Creating a parser for Big query

Or use Babel parser. > On Dec 17, 2021, at 9:35 AM, Maxim Gramin wrote: > > It looks like the parser needs to be extended > https://calcite.apache.org/docs/adapter.html#extending-the-parser > > On Fri, Dec 17, 2021 at 5:34 PM Arash Bizhan zadeh > wrote: > >> This is my test query >> >>

Re: Creating a parser for Big query

It looks like the parser needs to be extended https://calcite.apache.org/docs/adapter.html#extending-the-parser On Fri, Dec 17, 2021 at 5:34 PM Arash Bizhan zadeh wrote: > This is my test query > > SELECT IF(CAST(age as numeric) < 0.5, name, last_name) as customer_name > FROM

Re: Creating a parser for Big query

This is my test query SELECT IF(CAST(age as numeric) < 0.5, name, last_name) as customer_name FROM 307320.test_dataset.customers On Fri, Dec 17, 2021 at 5:47 AM Maxim Gramin wrote: > Can you show the query? I don't see this one. > > On Thu, Dec 16, 2021 at 10:12 PM Arash Bizhan zadeh >

Re: Creating a parser for Big query

Can you show the query? I don't see this one. On Thu, Dec 16, 2021 at 10:12 PM Arash Bizhan zadeh wrote: > Hi, > I am trying to create a parser to parse big query statements like this - > this is kotlin btw: > > val sqlParserConfig = BigQuerySqlDialect( > >

Creating a parser for Big query

Hi, I am trying to create a parser to parse big query statements like this - this is kotlin btw: val sqlParserConfig = BigQuerySqlDialect( BigQuerySqlDialect.DEFAULT_CONTEXT.withDatabaseProduct(SqlDialect.DatabaseProduct.BIG_QUERY)).configureParser(SqlParser.config()