Requesting a Review about PR----[CALCITE-5021]

Hi Follower, Please help review this PR about optimizing the NOT IN, So that I can make some improvements. Thanks very much. Double JOIN is created for NOT IN when IN-list that the values all non-nullable is converted to Values. This is caused by we infer the IN-list type by the left type th

Re: Draft: board report for 2022 Q1

+1 Looks great, Ruben! On 2/04/2022 5:21 pm, xiong duan wrote: Hi Ruben, It looks good to me, thanks for preparing the draft. Haisheng Yuan 于2022年4月2日周六 12:20写道： It looks good to me, thanks for preparing the draft, Ruben. Haisheng On 2022/04/01 11:17:19 Ruben Q L wrote: Hello, Below t

Re: Draft: board report for 2022 Q1

Hi Ruben, It looks good to me, thanks for preparing the draft. Haisheng Yuan 于2022年4月2日周六 12:20写道： > It looks good to me, thanks for preparing the draft, Ruben. > > Haisheng > > On 2022/04/01 11:17:19 Ruben Q L wrote: > > Hello, > > > > Below these lines you can find a draft of this quarter's

Re: [DISCUSS] Github PR link to JIRA issue

The present hyperlinking was enabled by Stamatis: https://issues.apache.org/jira/browse/CALCITE-4104 I’m not exactly sure how the .asf.yaml file accomplishes this. Maybe it instructs some ASF robot to modify the GitHub project settings on ou

Re: Draft: board report for 2022 Q1

It looks good to me, thanks for preparing the draft, Ruben. Haisheng On 2022/04/01 11:17:19 Ruben Q L wrote: > Hello, > > Below these lines you can find a draft of this quarter's board report. I > plan to submit it > at the beginning of next week. > Please let me know if you have any additions o

Re: [DISCUSS] Github PR link to JIRA issue

Yes, that is what I meant. I was expecting to see the link to JIRA in PR's commit page: https://github.com/apache/calcite/pull/2752/commits I am lazy to navigate to JIRA manually. :) Haisheng On 2022/04/01 01:04:19 Julian Hyde wrote: > Ah, I see. In the page for a commit (e.g. [1]) the text “[C

[jira] [Created] (CALCITE-5082) Ensure client_reference updated on site for user-facing properties

Josh Elser created CALCITE-5082: --- Summary: Ensure client_reference updated on site for user-facing properties Key: CALCITE-5082 URL: https://issues.apache.org/jira/browse/CALCITE-5082 Project: Calcite

Re: Contributing a custom SQL dialect of Firebolt to Calcite

Sorry I was slow to respond to your earlier message. (No need to add me to the thread - I am on the list, just backlogged. By the way, I am on vacation for the next ten days, so don’t expect responses from me. Other project members may or may not be able to help.) Please log a JIRA case, as I

Re: Calcite's parser didn't support bitwise's operator

In my opinion we should support the ‘|’ operator but not in the core SQL parser by default. Either support it in babel or enable it with flags in the core parser. Rationale: MySQL in its early days seemed to have a wacky mission to make SQL look like C. 0 and 1 for true and false, the |, ^, &&,

[jira] [Created] (CALCITE-5081) Bug in RelDecorrelator.decorrelate(Aggregate, boolean) is changing the group keys

Shiven Dvrk created CALCITE-5081: Summary: Bug in RelDecorrelator.decorrelate(Aggregate, boolean) is changing the group keys Key: CALCITE-5081 URL: https://issues.apache.org/jira/browse/CALCITE-5081 P

Calcite's parser didn't support bitwise's operator

Hi all I am using CALCITE as a mysql-proxy in my project. Some user want use mysql's bit functions[1], but I found CALCITE didn't support to parse these token. For example: > select 1 | 2 as c1; Exception: Caused by: java.lang.RuntimeException: org.apache.calcite.sql.parser.SqlParseException: En

Re: Contributing a custom SQL dialect of Firebolt to Calcite

Adding Julian to the thread. Thanks & Regards, Raghav Sharma | SDE 1 | Data Engineering M: +91 7087637086 I Mail: ragh...@sigmoidanalytics.com On Thu, Mar 31, 2022 at 2:39 PM Raghav Sharma wrote: > Hey Julian! > I followed your suggestions related to the dialect/plu

Re: Draft: board report for 2022 Q1

Hi Ruben, thanks for preparing the draft, it already looks good to me as-is. Best regards, Alessandro On Fri, 1 Apr 2022 at 13:17, Ruben Q L wrote: > Hello, > > Below these lines you can find a draft of this quarter's board report. I > plan to submit it > at the beginning of next week. > Please

Draft: board report for 2022 Q1

Hello, Below these lines you can find a draft of this quarter's board report. I plan to submit it at the beginning of next week. Please let me know if you have any additions or corrections. ## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data

[jira] [Created] (CALCITE-5080) jdbc adapter "zeroDateTimeBehavior=convertToNull" Causes "enumerable" to get stuck

itxiangkui created CALCITE-5080: --- Summary: jdbc adapter "zeroDateTimeBehavior=convertToNull" Causes "enumerable" to get stuck Key: CALCITE-5080 URL: https://issues.apache.org/jira/browse/CALCITE-5080 Pr