[jira] [Created] (CALCITE-4875) NVL Function Incorrectly changes nullability field of its operands

2021-11-03 Thread Jay Narale (Jira)
Jay Narale created CALCITE-4875: --- Summary: NVL Function Incorrectly changes nullability field of its operands Key: CALCITE-4875 URL: https://issues.apache.org/jira/browse/CALCITE-4875 Project: Calcite

[jira] [Created] (CALCITE-4874) Add recursive digest helper method

2021-11-03 Thread Will Noble (Jira)
Will Noble created CALCITE-4874: --- Summary: Add recursive digest helper method Key: CALCITE-4874 URL: https://issues.apache.org/jira/browse/CALCITE-4874 Project: Calcite Issue Type: Improvement

Extending Grammar Mapping

2021-11-03 Thread Jeremy Dyer
Hello, I am working on a custom parser grammar that extends "PostgresqlSqlDialect". I have a simple case where I want to allow my grammar to accept the token "SUBSTR" and have it behave exactly like "SUBSTRING" would. Is there a simple way to map this behavior without having to create a new

Re: Calcite for macro parsing in SQL ?

2021-11-03 Thread Julian Hyde
Calcite already has something called macros. They work like Lisp macros (substituting the AST) rather than C macros (your model of string replacement). See JdbcTest.testTableMacro [1]. Does this approach solve your problem? Julian [1]

Calcite for macro parsing in SQL ?

2021-11-03 Thread Cyril Catheu
Hey, I'm working on a product that executes arbitrary SQL on a "data source". A data source implements a SQL language, for instance, it can be MySQL, Pinot, BigQuery, etc... I'd like to introduce a macro language on top of the SQL. Very similar to what is done in grafana:

How to get the real column name and data type from a SQL view ?

2021-11-03 Thread Armstrong
Hi guys, Thanks for your time to read this help message. I'm new to Calcite and reading some codes and examples from calcite Github repo. I'm wandering how to get the column real name and type from view. For example, I have some SQL as below. A kafka topic table left join MySQL table,

[jira] [Created] (CALCITE-4873) Unconditional operand appending on SqlPosixRegexOperator#createCall method call

2021-11-03 Thread Igor Seliverstov (Jira)
Igor Seliverstov created CALCITE-4873: - Summary: Unconditional operand appending on SqlPosixRegexOperator#createCall method call Key: CALCITE-4873 URL: https://issues.apache.org/jira/browse/CALCITE-4873