Re: Error: Need to implement org.apache.calcite.adapter.jdbc.JdbcToEnumerableConverter

2021-11-29 Thread Florent Martineau
not > supported either because it doesn't make sense or because nobody > implemented support for those till now. > > Best, > Stamatis > > [1] > > https://github.com/apache/calcite/blob/7c423ef23878271b1c50c03629ebfff674985681/core/src/main/java/org/apache/calcite/adapter/jdbc/J

Error: Need to implement org.apache.calcite.adapter.jdbc.JdbcToEnumerableConverter

2021-11-26 Thread Florent Martineau
Hi everyone, I'm having troubles transforming a RelNode to SQL. When running this code: RelToSqlConverter converter = new RelToSqlConverter(SqlDialect.DatabaseProduct.CALCITE.getDialect()); SqlImplementor.Result result = converter.visitRoot(relNode); I'm getting the following error on

Re: Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2021-11-26 Thread Florent Martineau
Just wanted to mention that, as a newcomer in the Calcite community, the BOSS tutorial is immensely valuable, at least for me! Calcite is a complex project, with little examples online except in the Tests. Having an overview of the main concepts and their implementation is VERY helpful. I would

How to avoid Planner rewriting RelNodes ?

2021-11-24 Thread Florent Martineau
Hi all! I'm using RelBuilder to create RelNodes, that I then save as JSON using RelJsonWriter. When doing so, it seems to me that the planner rewrites my query. For instance, if I set a filter that will always be false, it rewrites my query so that it basically outputs nothing. For instance,

Re: Calcite to build a query

2021-11-24 Thread Florent Martineau
Hi Sandeep, I'm no expert so take what I'm saying with a grain of salt. I use Calcite to generate queries by using the RelBuilder, which will create RelNodes that I can then convert to SQL when I need to execute the query. >From my understanding, if we use Relational Algebra it's because it's

Re: Error parsing DATE("2021-01-01") for BigQuery, using Calcite

2021-09-25 Thread Florent Martineau
use the Babel parser, because DATE is a > reserved keyword and therefore the parser needs to work in a different mode > in order to see it as a function name. I think I made the DATE function work > for Redshift but I’m not sure I did it for BigQuery. > > > > On Sep 24, 2

Re%3A Error parsing DATE("2021-01-01") for BigQuery%2C using CalciteIn-Reply-To=

2021-09-25 Thread Florent Martineau
because DATE is a > reserved keyword and therefore the parser needs to work in a different mode > in order to see it as a function name. I think I made the DATE function work > for Redshift but I’m not sure I did it for BigQuery. > > > > On Sep 24, 2021, at 1:58 PM, Florent

Error parsing DATE("2021-01-01") for BigQuery, using Calcite

2021-09-24 Thread Florent Martineau
Dear all, Disclaimer: It's the first time I send a message to a mailing list. If it's not the right mailing list or if I should use other means (eg. Stackoverflow), please do not hesitate to tell me! Also, if you need additional pieces of information, I will be glad to provide them! My problem