Re: [DISCUSS] Towards Calcite 1.30.0

Friendly reminder. The next release managers would be: - Andrei Sereda for 1.30.0 - Liya Fan for 1.31.0 Andrei, are you available to be RM for 1.30? When would it be a good date for a RC? Ruben. PS: Do we have any other volunteers for the subsequent releases? On Wed, Feb 16, 2022 at 12:59 AM

Re: [DISCUSS] Towards Calcite 1.30.0

Thanks for driving this Ruben! Another alternative if Andrei is unavailable at the moment would be to see if they can switch places with Liya. Would this be possible Liya? Best, Stamatis On Thu, Feb 24, 2022 at 10:41 AM Ruben Q L wrote: > Friendly reminder. > > The next release managers would

[DISCUSS] Release Managers

Hi all, In the last 2 years or so we had the following people helping out with releasing Calcite. 1.22.0 Danny Chan 1.23.0 Haisheng Yuan 1.24.0 Chunwei Lei 1.25.0 Andrei Sereda 1.26.0 Ruben Quesada Lopez 1.27.0 Stamatis Zampetakis 1.28.0 Julian Hyde 1.29.0 Rui Wang Big thanks to everyone! Now w

[Discuss] Converting SELECT Fields to STAR may cause duplicate column exception when executing ctas

Hi community, I'm trying to convert a plan to a sql of SPARK dialect, but sometimes the fields will be converted to star, see the following example *create table users(id int);* *create table depts(id int);* *select a.id , b.id as id0 from users1 a, depts1 b* converti

Re: dynamic reflective schema

Hi Julian, What about SQL Double, does it corrrespond to java's double too? -- Original -- From: "Julian Hyde";; Send time: Thursday, Feb 24, 2022 3:41 PM To: "dev"; Subject: Re: dynamic reflective schema SQL’s FLOAT type (aka DOUBLE) corresponds to Java’

Re: dynamic reflective schema

What we want to do is mapping Java LocalTime to SQL Time, from the csv adapter example we know that we should pass a long value for SQL Time, but we can't convert a Java LocalTime to Java Date to call it's getTime method like the CSV adapter, then what value should we calculate from Java LocalT

Re: dynamic reflective schema

The JDBC specification [1] defines the mapping between JDBC/SQL types to Java types (check TABLE B-1 JDBC Types Mapped to Java Types). Best, Stamatis [1] https://jcp.org/aboutJava/communityprocess/mrel/jsr221/index3.html On Thu, Feb 24, 2022 at 1:48 PM xiaobo wrote: > What we want to do is map

Re: dynamic reflective schema

Also if it is helpful, there is a class in Calcite called "SqlTypeName" that has a "Map" and a function "getNameForJdbcType(int ordinal)" https://github.com/apache/calcite/blob/812e3e98eae518cf85cd1b6b7f055fb96784a423/core/src/main/java/org/apache/calcite/sql/type/SqlTypeName.java#L215-L256 There

Re: dynamic reflective schema

We found the answer, we should pass total milliseconds of the day for SQL Time. -- Original -- From: "xiaobo ";; Send time: Thursday, Feb 24, 2022 8:48 PM To: "dev"; Subject: Re: dynamic reflective schema What we want to do is mapping Java LocalTime to SQ

Re: [DISCUSS] Release Managers

Hi Stamatis, I can do 1.32.0 (or whatever makes sense). Jess On Thu, Feb 24, 2022 at 5:11 AM Stamatis Zampetakis wrote: > Hi all, > > In the last 2 years or so we had the following people helping out with > releasing Calcite. > > 1.22.0 Danny Chan > 1.23.0 Haisheng Yuan > 1.24.0 Chunwei Lei >

Re: dynamic reflective schema

Yes. As I said, DOUBLE is basically a synonym for FLOAT in SQL. Julian > On Feb 24, 2022, at 06:13, Stamatis Zampetakis wrote: > > The JDBC specification [1] defines the mapping between JDBC/SQL types to > Java types (check TABLE B-1 JDBC Types Mapped to Java Types). > > Best, > Stamatis >

Re: [DISCUSS] Release Managers

Put me down for 1.33 On Thu, Feb 24, 2022 at 7:39 AM Jess Balint wrote: > > Hi Stamatis, > > I can do 1.32.0 (or whatever makes sense). > > Jess > > On Thu, Feb 24, 2022 at 5:11 AM Stamatis Zampetakis > wrote: > > > Hi all, > > > > In the last 2 years or so we had the following people helping ou

Re: [Discuss] Converting SELECT Fields to STAR may cause duplicate column exception when executing ctas

Which code is generating this "SELECT *" query? It seems wrong to generate "SELECT *". It should generate a list of columns with unique names instead. On Thu, Feb 24, 2022 at 3:41 AM Yanjing Wang wrote: > > Hi community, > > I'm trying to convert a plan to a sql of SPARK dialect, but sometimes th

Re: [DISCUSS] Release Managers

Hi Stamatis, I can release the 1.34 Julian Hyde 于2022年2月25日周五 05:59写道： > Put me down for 1.33 > > On Thu, Feb 24, 2022 at 7:39 AM Jess Balint wrote: > > > > Hi Stamatis, > > > > I can do 1.32.0 (or whatever makes sense). > > > > Jess > > > > On Thu, Feb 24, 2022 at 5:11 AM Stamatis Zampetak

[jira] [Created] (CALCITE-5021) Double JOIN is created for NOT IN when IN-list that the values all non-nullable is converted to Values

xiong duan created CALCITE-5021: --- Summary: Double JOIN is created for NOT IN when IN-list that the values all non-nullable is converted to Values Key: CALCITE-5021 URL: https://issues.apache.org/jira/browse/CALCITE-

I would like to fix "CALCITE-4739: json_object pushdown JDBC". Looking through the codebase, not obvious where to start, hints greatly appreciated

As title implies, as part of a larger effort to fix a couple of things related to JSON support, I'd really like to add support for converting JSON_OBJECT and JSON_ARRAYAGG calls to the right DB-specific syntax: https://issues.apache.org/jira/browse/CALCITE-4739 I thought that maybe this functiona

[jira] [Created] (CALCITE-5022) JSON values from queries against H2 (possibly other) schemas encoded as bytes (IE: "B@6e9a0bea")

Gavin Ray created CALCITE-5022: -- Summary: JSON values from queries against H2 (possibly other) schemas encoded as bytes (IE: "B@6e9a0bea") Key: CALCITE-5022 URL: https://issues.apache.org/jira/browse/CALCITE-5022

Re: [DISCUSS] Towards Calcite 1.30.0

Sure. If Andrei is not available, I think I am OK. Best, Liya Fan Stamatis Zampetakis 于2022年2月24日周四 19:10写道： > Thanks for driving this Ruben! > > Another alternative if Andrei is unavailable at the moment would be to see > if they can switch places with Liya. Would this be possible Liya? > > B

[jira] [Created] (CALCITE-5023) JOIN whose inputs projecting same field names shouldn't generate SELECT STAR when converting rel to sql

yanjing.wang created CALCITE-5023: - Summary: JOIN whose inputs projecting same field names shouldn't generate SELECT STAR when converting rel to sql Key: CALCITE-5023 URL: https://issues.apache.org/jira/browse/CAL