[jira] [Created] (CALCITE-6419) Invalid unparse for VARCHAR without precision in HiveSqlDialect And SparkSqlDialect

2024-05-24 Thread xiong duan (Jira)
xiong duan created CALCITE-6419: --- Summary: Invalid unparse for VARCHAR without precision in HiveSqlDialect And SparkSqlDialect Key: CALCITE-6419 URL: https://issues.apache.org/jira/browse/CALCITE-6419

[jira] [Created] (CALCITE-6417) Map value constructor and Array value constructor unparsed incorrectly for HiveSqlDialect

2024-05-23 Thread xiong duan (Jira)
xiong duan created CALCITE-6417: --- Summary: Map value constructor and Array value constructor unparsed incorrectly for HiveSqlDialect Key: CALCITE-6417 URL: https://issues.apache.org/jira/browse/CALCITE-6417

[jira] [Created] (CALCITE-6416) Remove unnecessary SUBSTRING rewrite in SparkSqlDialect

2024-05-23 Thread xiong duan (Jira)
xiong duan created CALCITE-6416: --- Summary: Remove unnecessary SUBSTRING rewrite in SparkSqlDialect Key: CALCITE-6416 URL: https://issues.apache.org/jira/browse/CALCITE-6416 Project: Calcite

[jira] [Created] (CALCITE-6415) Invalid unparse for TIMESTAMP with HiveSqlDialect

2024-05-22 Thread xiong duan (Jira)
xiong duan created CALCITE-6415: --- Summary: Invalid unparse for TIMESTAMP with HiveSqlDialect Key: CALCITE-6415 URL: https://issues.apache.org/jira/browse/CALCITE-6415 Project: Calcite Issue

Re: Bug(about timestamp dataType) - 20240509

2024-05-09 Thread Xiong Duan
Hi developer, Please log it in Calcite Jira: https://issues.apache.org/jira/browse/CALCITE and also use code reformat when description. 小艾 <854413...@qq.com.invalid> 于2024年5月9日周四 16:30写道: > Version 1.36.0

Re: [DISCUSS] Towards Calcite 1.37.0

2024-03-18 Thread Xiong Duan
+1 It is a good time to release a new version. Francis Chuang 于2024年3月18日周一 05:44写道: > > Hey everyone, > > I just wanted to jump in regarding CALCITE-6248 [1] and CALCITE-6282 (no > corresponding PRs in the Calcite repo yet). > > The corresponding PRs in the Avatica repo are: > -

[jira] [Created] (CALCITE-5929) Improve LogicalWindow print plan to add the constant value

2023-08-14 Thread xiong duan (Jira)
xiong duan created CALCITE-5929: --- Summary: Improve LogicalWindow print plan to add the constant value Key: CALCITE-5929 URL: https://issues.apache.org/jira/browse/CALCITE-5929 Project: Calcite

[ANNOUNCE] Apache Calcite 1.35.0 released

2023-07-27 Thread Xiong Duan
/ Thanks to everyone involved! Xiong Duan, on behalf of the Apache Calcite Team

Main Code freeze is over and commits can resume

2023-07-27 Thread Xiong Duan
Hello Calcite Community, We have released Calcite 1.35.0, The Main Code freeze is over and commits can resume. Best, Xiong Duan

[RESULT] [VOTE] Release apache-calcite-1.35.0 (release candidate 3)

2023-07-26 Thread Xiong Duan
Thanks to everyone who has tested the release candidate and given their comments and votes. The tally is as follows. 4 binding +1s: Francis Chuang Benchao Li Julian Hyde Ruben Quesada Lopez 1 non-binding +1s: Xiong Duan No 0s or -1s. Therefore, I am delighted to announce

Re: [VOTE] Release Apache Calcite 1.35.0 (release candidate 3)

2023-07-26 Thread Xiong Duan
Hi, Thanks, everyone, I will close this voting thread and the results will be tallied. Best, Xiong Duan Ruben Q L 于2023年7月24日周一 16:42写道: > - Release notes: ok > - Checksum: ok > - Signature: ok > - Diff source release and git repository: ok > - Build + tests: ok &g

[VOTE] Release Apache Calcite 1.35.0 (release candidate 3)

2023-07-21 Thread Xiong Duan
he Calcite 1.35.0 [ ] 0 I don't feel strongly about it, but I'm okay with the release [ ] -1 Do not release this package because... Here is my vote: +1 (binding) Best, Xiong Duan

[CANCEL][VOTE] Release Apache Calcite 1.35.0 (release candidate 2)

2023-07-20 Thread Xiong Duan
levant licensed dependencies. (Is there an automated way to do this? Further discussion needed) Thanks a lot for all your review and advice. Best, Xiong Duan

Re: [VOTE] Release Apache Calcite 1.35.0 (release candidate 2)

2023-07-20 Thread Xiong Duan
Hi, Thanks, everyone, I will close this voting thread because this RC2 testing failed with Apache Druid, and some Release Notes need to improve. Best, Xiong Duan Francis Chuang 于2023年7月20日周四 16:45写道: > +1 as this is a regression. Thanks, Gian, for discovering this. > > On 20/07/

Re: [VOTE] Release Apache Calcite 1.35.0 (release candidate 2)

2023-07-17 Thread xiong duan
Hi Francis, Now, The URL https://people.apache.org/keys/committer/xiong.asc is online. xiong duan 于2023年7月18日周二 10:01写道: > Hi jacky, > Yes, I noticed this, Thanks for the review. If no other problem, I will > update it when release. >

Re: [VOTE] Release Apache Calcite 1.35.0 (release candidate 2)

2023-07-17 Thread xiong duan
Hi jacky, Yes, I noticed this, Thanks for the review. If no other problem, I will update it when release.

Re: [VOTE] Release Apache Calcite 1.35.0 (release candidate 2)

2023-07-17 Thread xiong duan
a.apache.org/new-committers-guide.html#set-up-security-and-pgp-keys > > I am unable to verify the release as I am unable to import your key via > the ASF's committer key index into GPG. > > Francis > > On 18/07/2023 4:24 am, xiong duan wrote: > > Hi all, > > >

[CANCEL][VOTE] Release Apache Calcite 1.35.0 (release candidate 0)

2023-07-17 Thread xiong duan
Hi all, Cancel this thread, due to some problems in the build. Thanks to Francis for the kind reminder. I have created RC2 for this release.

Re: [VOTE] Release Apache Calcite 1.35.0 (release candidate 0)

2023-07-17 Thread xiong duan
eleases as Ruben Quesada Lopez. > > Julian > > > On Jul 14, 2023, at 7:33 AM, xiong duan wrote: > > > > Hi all, > > > > > > I have created a build for Apache Calcite 1.35.0, release > > > > candidate 0. > > > > > >

[VOTE] Release Apache Calcite 1.35.0 (release candidate 2)

2023-07-17 Thread xiong duan
Hi all, I have created a build for Apache Calcite 1.35.0, release candidate 2. Thanks to everyone who has contributed to this release. You can read the release notes here: https://github.com/apache/calcite/blob/calcite-1.35.0-rc2/site/_docs/history.md The commit to be voted upon:

[VOTE] Release Apache Calcite 1.35.0 (release candidate 0)

2023-07-14 Thread xiong duan
Hi all, I have created a build for Apache Calcite 1.35.0, release candidate 0. Thanks to everyone who has contributed to this release. You can read the release notes here: https://s.apache.org/p3rl9 The commit to be voted upon: https://s.apache.org/8io6t Its hash is

Re: [DISCUSS] Towards Calcite 1.35.0

2023-07-13 Thread xiong duan
Hi All, I have prepared the release log in https://github.com/apache/calcite/pull/3315/files . Please review it. If have any questions or advices, please let me know. xiong duan 于2023年7月13日周四 18:25写道: > Hi All, > > The RC build process is starting and therefore the main branch i

Re: [DISCUSS] Towards Calcite 1.35.0

2023-07-13 Thread xiong duan
ugh to review. > > > >>>> > > > >>>> On 2023/06/28 19:36:16 Julian Hyde wrote: > > > >>>>> I have taken care of 1, 2, 3, 4. > > > >>>>> > > > >>>>> Tanner, can you do 5. > > > >

Re: [DISCUSS] Towards Calcite 1.35.0

2023-07-09 Thread xiong duan
>> > >>>>> Tanner, can you do 5. > >>>>> > >>>>> Of the 12 open issues that are open and have fixVersion = 1.35, most > >>>> have PRs ready for review [1]. Can a few committers each take say 3 > cases > >>>>

Re: Documentation / Resources to help getting started with Elasticsearch Adapter

2023-07-07 Thread xiong duan
Hi Sumanth, As Alessandro mentioned, the document will show how to use the sqlline to search the Elasticsearch. If you have the Calcite Code, we can find some test in Elasticsearch module. And If you want to create Jdbc connection, you can try add the Elasticsearch-Schema-File as the connection

Re: Force push to calcite main

2023-07-07 Thread xiong duan
I would also be +1 for keeping it in place. I know several times it happened to correct the commit information to make the commit info better and format. Using --force-with-lease( If new commits are added to the remote branch (by another developer), this command would not update the remote

Re: Java Doc about RexProgramBuilderBase

2023-07-07 Thread xiong duan
Usually we need to improve the Java Doc or remove the misleading invalid code. Because the right code has the unit test to cover it. Yes, This is a bug and we should improve it. Feel free to submit PR for this. Julian Hyde 于2023年7月8日周六 02:16写道: > People refactoring code should remember that

Re: [ANNOUNCE] New committer: TJ Banghart

2023-07-04 Thread xiong duan
Congratulations, TJ! Welcome! Jacky Lau 于2023年7月4日周二 18:56写道: > Congratulations, TJ! > > Best Jacky! > > Benchao Li 于2023年7月4日周二 17:55写道: > > > Congratulations, TJ! > > > > Zhe Hu 于2023年7月4日周二 17:26写道: > > > > > Congrats! TJ. > > > Replied Message > > > | From | Francis Chuang | > >

Re: [ANNOUNCE] New committer: Dan Zou

2023-07-04 Thread xiong duan
Congratulations, Dan! Welcome. Jacky Lau 于2023年7月4日周二 18:56写道: > Congratulations, Dan! > > Best Jacky! > > Benchao Li 于2023年7月4日周二 17:55写道: > > > Congratulations, Dan! > > > > Zhe Hu 于2023年7月4日周二 17:26写道: > > > > > Congrats! Dan. > > > Replied Message > > > | From | Francis Chuang |

Re: [DISCUSS] Towards Calcite 1.35.0

2023-06-28 Thread xiong duan
to handle it).Thanks. Jacky Lau 于2023年6月26日周一 14:24写道: > hi @xiong duan: > thanks for your review and merged very much, and i forgot there are > also have one pr https://github.com/apache/calcite/pull/3262 > do you also have time to have a look? > > > xiong duan

Re: [ANNOUNCE] New committer: Jacky Lau

2023-06-28 Thread xiong duan
Congratulations, Jacky! Francis Chuang 于2023年6月28日周三 18:57写道: > Congrats, Jacky! > > On 28/06/2023 8:46 pm, Stamatis Zampetakis wrote: > > Apache Calcite's Project Management Committee (PMC) has invited Jacky > Lau to > > become a committer, and we are pleased to announce that they have >

Re: [ANNOUNCE] New committer: Zhe Hu

2023-06-28 Thread xiong duan
Congratulations, Zhe Hu! Francis Chuang 于2023年6月28日周三 19:05写道: > Congrats, Zhe Hu! > > On 28/06/2023 9:04 pm, Stamatis Zampetakis wrote: > > Apache Calcite's Project Management Committee (PMC) has invited Zhe Hu to > > become a committer, and we are pleased to announce that they have >

Re: Virtual key signing party

2023-06-26 Thread xiong duan
] Xiong Duan (CODE SIGNING KEY) sub rsa4096 2023-06-27 [E] Michael Mior 于2023年6月27日周二 02:19写道: > I'll attend if possible. My key needs to be updated. (Not compromised, but > I lost access to my previous signing key.) > > pub rsa4096 2022-06-17 [SC] [expires: 2038-06-13] >

Re: [DISCUSS] Towards Calcite 1.35.0

2023-06-25 Thread xiong duan
https://github.com/apache/calcite/pull/3238 > > https://github.com/apache/calcite/pull/3263 > > > > xiong duan 于2023年6月25日周日 10:31写道: > > > > > I have created CALCITE-5797 to release 1.35.0. If there are no > > objections, > > > I will

Re: [DISCUSS] Towards Calcite 1.35.0

2023-06-24 Thread xiong duan
> comments and just need a few days of time. > >>> > >>> On Thu, Jun 1, 2023 at 3:32 AM Julian Hyde wrote: > >>> > >>>> There's one Jira case we should fix: > >>>> https://issues.apache.org/jira/browse/CALCITE-5737 (support JDK 19 > a

[jira] [Created] (CALCITE-5797) Release Calcite 1.35.0

2023-06-24 Thread xiong duan (Jira)
xiong duan created CALCITE-5797: --- Summary: Release Calcite 1.35.0 Key: CALCITE-5797 URL: https://issues.apache.org/jira/browse/CALCITE-5797 Project: Calcite Issue Type: Test

Re: [ANNOUNCE] New committer: Oliver Lee

2023-06-13 Thread xiong duan
Congratulations Oliver! Dan Zou 于2023年6月13日周二 19:16写道: > Congratulations Oliver! > > Best, > Dan Zou > > > > > > > 2023年6月13日 18:44,Stamatis Zampetakis 写道: > > > > Apache Calcite's Project Management Committee (PMC) has invited Oliver > > Lee to become a committer, and we are pleased to

[jira] [Created] (CALCITE-5769) Optimizing 'CAST(e AS t) IS NOT NULL' to 'e IS NOT NULL'

2023-06-07 Thread xiong duan (Jira)
xiong duan created CALCITE-5769: --- Summary: Optimizing 'CAST(e AS t) IS NOT NULL' to 'e IS NOT NULL' Key: CALCITE-5769 URL: https://issues.apache.org/jira/browse/CALCITE-5769 Project: Calcite

[jira] [Created] (CALCITE-5750) SQL throws exception when the Filter include id = ARRAY [1,2,3]

2023-06-05 Thread xiong duan (Jira)
xiong duan created CALCITE-5750: --- Summary: SQL throws exception when the Filter include id = ARRAY [1,2,3] Key: CALCITE-5750 URL: https://issues.apache.org/jira/browse/CALCITE-5750 Project: Calcite

[jira] [Created] (CALCITE-5749) Join table with different database name and same table name will throw exception

2023-06-04 Thread xiong duan (Jira)
xiong duan created CALCITE-5749: --- Summary: Join table with different database name and same table name will throw exception Key: CALCITE-5749 URL: https://issues.apache.org/jira/browse/CALCITE-5749

Re: [DISCUSS] Towards Calcite 1.35.0

2023-05-30 Thread xiong duan
Yes. I can release 1.35.0 when the PR is handled. Julian Hyde 于2023年5月30日周二 05:46写道: > Mid-June sounds like a good idea. > > I would like to see the following Jira cases finished: > * 5701 NAMED_STRUCT (MasseGuillaume) > * 5640 SAFE_ADD (DanZou) > * 5625 SEARCH (olivrlee) > * 5626

[jira] [Created] (CALCITE-5711) Implement the SINGLE_VALUE aggregation in PostgreSQL Dialect

2023-05-18 Thread xiong duan (Jira)
xiong duan created CALCITE-5711: --- Summary: Implement the SINGLE_VALUE aggregation in PostgreSQL Dialect Key: CALCITE-5711 URL: https://issues.apache.org/jira/browse/CALCITE-5711 Project: Calcite

Re: [ANNOUNCE] New committer: Alex Plehanov

2023-01-11 Thread xiong duan
Welcome, Alex! Andrei Sereda 于2023年1月11日周三 01:16写道: > Welcome, Alex! > > On Tue, Jan 10, 2023, 11:01 Stamatis Zampetakis wrote: > > > Welcome Alex! Looking forward to working with you. > > > > Best, > > Stamatis > > > > On Tue, Jan 10, 2023 at 2:48 AM Chunwei Lei > > wrote: > > > > > Welcome,

Re: [ANNOUNCE] New committer: Dmitry Sysolyatin

2022-11-09 Thread xiong duan
Congratulations and welcome! Michael Mior 于2022年11月10日周四 01:54写道: > Congratulations and welcome Dmitry! > > -- > Michael Mior > mm...@apache.org > > > On Tue, Nov 8, 2022 at 12:44 PM Ruben Q L wrote: > > > Apache Calcite's Project Management Committee (PMC) has invited Dmitry > > Sysolyatin to

[jira] [Created] (CALCITE-5181) Sum aggregate function return wong result

2022-06-05 Thread xiong duan (Jira)
xiong duan created CALCITE-5181: --- Summary: Sum aggregate function return wong result Key: CALCITE-5181 URL: https://issues.apache.org/jira/browse/CALCITE-5181 Project: Calcite Issue Type: Bug

[DISCUSS] REGR_SXX and similar aggregate functions return the wrong data type

2022-06-05 Thread xiong duan
Hi, Followers. I have a problem with CALCITE-4924 . As described in the JIRA, These functions return the wrong data type in some scenes. So I think a long time about how to infer the more accurate data type. Finally, I prepare to calculate

Re: [DISCUSS] Towards Calcite 1.31.0

2022-05-26 Thread xiong duan
+1 for mid-June for the first RC. Benchao Li 于2022年5月26日周四 10:31写道: > +1 for mid-June for the first RC. > Thanks Ruben for driving this, and Andrei for being the RM. > > For me, I have two PRs[1][2] which I think it's good to have them in 1.31.0 > And for other issues which I've not opened pr

Re: [ANNOUNCE] Chunwei Lei joins Calcite PMC

2022-05-24 Thread xiong duan
Congratulations Chunwei! Benchao Li 于2022年5月25日周三 08:45写道: > Congratulations Chunwei! > > Francis Chuang 于2022年5月25日周三 05:54写道: > > > Congrats, Chunwei! > > > > On 25/05/2022 1:48 am, Alessandro Solimando wrote: > > > Congratulations Chunwei, well deserved! > > > > > > On Tue, 24 May 2022 at

Re: [ANNOUNCE] Vladimir Ozerov joins Calcite PMC

2022-05-24 Thread xiong duan
Congratulations Vladimir! Benchao Li 于2022年5月25日周三 08:45写道: > Congratulations Vladimir! > > Francis Chuang 于2022年5月25日周三 05:55写道: > > > Congrats Vladimir! > > > > On 25/05/2022 1:50 am, Alessandro Solimando wrote: > > > Congratulations Vladimir! > > > > > > > > > On Tue, 24 May 2022 at 16:59,

[jira] [Created] (CALCITE-5156) Support implicit type cast for IN Sub-query

2022-05-16 Thread xiong duan (Jira)
xiong duan created CALCITE-5156: --- Summary: Support implicit type cast for IN Sub-query Key: CALCITE-5156 URL: https://issues.apache.org/jira/browse/CALCITE-5156 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5140) The Github CI failed in Linux (OpenJ9 8)

2022-05-08 Thread xiong duan (Jira)
xiong duan created CALCITE-5140: --- Summary: The Github CI failed in Linux (OpenJ9 8) Key: CALCITE-5140 URL: https://issues.apache.org/jira/browse/CALCITE-5140 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-5139) Improve Join print plan to add the CorrelationId info

2022-05-07 Thread xiong duan (Jira)
xiong duan created CALCITE-5139: --- Summary: Improve Join print plan to add the CorrelationId info Key: CALCITE-5139 URL: https://issues.apache.org/jira/browse/CALCITE-5139 Project: Calcite

[jira] [Created] (CALCITE-5138) Join on condition generates wrong plan when the condition is sub-query

2022-05-07 Thread xiong duan (Jira)
xiong duan created CALCITE-5138: --- Summary: Join on condition generates wrong plan when the condition is sub-query Key: CALCITE-5138 URL: https://issues.apache.org/jira/browse/CALCITE-5138 Project

Re: [VOTE] Release Apache Calcite Avatica 1.21.0 (release candidate 0)

2022-05-05 Thread xiong duan
LGTM. +1 Francis Chuang 于2022年5月5日周四 07:32写道: > Hi all, > > I have created a build for Apache Calcite Avatica 1.21.0, release > candidate 0. > > Thanks to everyone who has contributed to this release. > > You can read the release notes here: > >

[jira] [Created] (CALCITE-5132) When the IN-list that include NUll value is converted to Values as a SCALA subquery will return wrong result

2022-05-04 Thread xiong duan (Jira)
xiong duan created CALCITE-5132: --- Summary: When the IN-list that include NUll value is converted to Values as a SCALA subquery will return wrong result Key: CALCITE-5132 URL: https://issues.apache.org/jira/browse

[jira] [Created] (CALCITE-5117) Optimize the EXISTS sub-query by Metadata RowCount

2022-04-26 Thread xiong duan (Jira)
xiong duan created CALCITE-5117: --- Summary: Optimize the EXISTS sub-query by Metadata RowCount Key: CALCITE-5117 URL: https://issues.apache.org/jira/browse/CALCITE-5117 Project: Calcite Issue

[jira] [Created] (CALCITE-5112) Upgrade Jetty version to 9.4.44.v202109272

2022-04-25 Thread xiong duan (Jira)
xiong duan created CALCITE-5112: --- Summary: Upgrade Jetty version to 9.4.44.v202109272 Key: CALCITE-5112 URL: https://issues.apache.org/jira/browse/CALCITE-5112 Project: Calcite Issue Type: Bug

Re: Different behavior bewteen '>' and '='

2022-04-10 Thread xiong duan
Hi BenChao, Thanks to bring this up again. I find another relative issue ISSUE-4993 about the RexSimplify. Because the EQUALS and NOT-EQUALS Operator uses the *LEAST_RESTRICTIVE* strategy to validate the parameter. Other comparators use the

Re: [Discuss] The RexSimplify about "a <> 1 and a = 2"

2022-04-02 Thread xiong duan
=(a, '2') > > 3. UNKNOWN AS FALSE: =(a, '2') > > > > IMHO, this is expected and correct. > > For the first case, the result can be simplified to: > > if a is null: > > null > > else: > > true > > then, for each unknown value, we can evaluate to the results

Re: [DISCUSS] Automated website builds

2022-04-02 Thread xiong duan
se is tagged. See: > > https://github.com/apache/calcite/blob/master/.github/workflows/publish-website-on-release.yml#L48 > > Francis > > On 2/04/2022 6:30 pm, xiong duan wrote: > > Hi Francis, > > This is good to me. And this is very helpful. > >

Re: [DISCUSS] Automated website builds

2022-04-02 Thread xiong duan
Hi Francis, This is good to me. And this is very helpful. But have a little problem, I noticed you removed the The procedure for deploying changes to the website. If we change the Java doc(The Class or the method) in https://calcite.apache.org/javadocAggregate/, maybe we still need this?

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

2022-04-02 Thread xiong duan
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

Re: Draft: board report for 2022 Q1

2022-04-02 Thread xiong duan
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: Broken history after force pushing to master

2022-03-09 Thread xiong duan
Hi. Stamatis. I agree we need to address this issue first. I find some relative descriptions at end of the email https://lists.apache.org/thread/gkvn5hlmm3jlcklgw9k9nodyhxvqmsw4. So it is a force push. Sorry I am not very good at Github job flow. But I think it describes what happened according to

Re: [VOTE] Release Apache Calcite 1.30.0 (release candidate 1)

2022-03-06 Thread xiong duan
Hi, Liya Fan.Thanks for your work. +1. Just a little problem: I noticed the Bug-fixes logs all started with FixI think maybe we should stay the same as JIRA summary or PR commit? Fan Liya 于2022年3月7日周一 14:55写道: > Hi all, > > I have created a build for Apache Calcite 1.30.0, release >

[Discuss] The RexSimplify about "a <> 1 and a = 2"

2022-02-27 Thread xiong duan
Hi followers. When I learned how to simplify the Rexnode in Calcite. I meet a problem and need some help. For example: When we simplify "a <> 1 or a = 1 [a is nullable]", (the result is different according to how to treat the UNKNOW value) : checkSimplify3_(or(ne(vInt(0),

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

2022-02-24 Thread xiong duan (Jira)
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

Re: [DISCUSS] Release Managers

2022-02-24 Thread xiong duan
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

Re: Identifier starting with number parse fail

2022-02-16 Thread xiong duan
I do some search in: PostgreSQL: https://www.postgresql.org/docs/9.1/sql-syntax-lexical.html > don't support SqlServer: https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-ver15 >don't support Oracle:

Re: [DISCUSS] Towards Calcite 1.30.0

2022-02-15 Thread xiong duan
+1 to release 1.30. Feb 28th sounds good to me. Julian Hyde 于2022年2月16日周三 08:27写道: > +1 to release 1.30 soon, to keep up the tempo. Feb 28th sounds good to > me. Thanks for pushing on this, Ruben. > > Andrei, Are you available to be RM for 1.30? When is a good date for you? > > Julian > > On

Re: calcite multi-threading problem

2022-02-11 Thread xiong duan
Yes, It is a dependency issue. I have met the same problem. +1 for Dmitry. Dmitry Sysolyatin 于2022年2月11日周五 21:18写道: > Actually, I had the same problem with spark. Spark 3.2.1 uses the old > version of janino, calcite 1.29 uses the new version of janino and they are > not compatible. > If I

Re: [DISCUSS] New community section for articles/blogs/papers

2022-01-24 Thread Xiong Duan
+1. This will be very helpful. On 2022/01/24 09:47:16 Ruben Q L wrote: > Thanks for the proposal Stamatis. > > I agree that such a section could be very helpful, especially for new > comers. As you suggest, perhaps a new bullet "external resources" (or > something like that) under the community

[jira] [Created] (CALCITE-4993) Simplify EQUALS or NOT-EQUALS with other number comparison

2022-01-21 Thread xiong duan (Jira)
xiong duan created CALCITE-4993: --- Summary: Simplify EQUALS or NOT-EQUALS with other number comparison Key: CALCITE-4993 URL: https://issues.apache.org/jira/browse/CALCITE-4993 Project: Calcite

Re: [ANNOUNCE] New Calcite PMC chair: Ruben Q L

2022-01-21 Thread xiong duan
Congratulations to Ruben and thanks to Haisheng! Danny Chan 于2022年1月21日周五 12:19写道: > Congratulations, Ruben, and good luck! > > Haisheng, Thank you for serving as Chair. > > Yanjing Wang 于2022年1月21日 周五下午12:16写道: > > > Congrats Ruben! > > > > Stamatis Zampetakis 于2022年1月21日周五 06:34写道: > > > > >

[jira] [Created] (CALCITE-4988) ((A IS NOT NULL OR B) AND A) can't be simplify to (A) When A is deterministic

2022-01-17 Thread xiong duan (Jira)
xiong duan created CALCITE-4988: --- Summary: ((A IS NOT NULL OR B) AND A) can't be simplify to (A) When A is deterministic Key: CALCITE-4988 URL: https://issues.apache.org/jira/browse/CALCITE-4988

Re: [DISCUSS] Writing good summaries for Jira cases

2022-01-13 Thread xiong duan
Hi all, I prefer to describe the symptoms the user sees. Because For developers and users both can know what happens when Calcite has a wrong result or unexpected exception. If the user encounters a problem, I guess he wants to find the related symptoms summary in the git log, not the root

Re: Sort getting removed during optimization

2022-01-10 Thread xiong duan
If I understand correctly, If we remove the BINDABLE_SORT_RULE, the result will throw an exception about the Plan transformation. So it looks like a wrong rule's result. If you don't customize the rule, It is a bug, and please test this using Calcite's new version.

Re: Extend parser.jj in calcite, to support the operator '<=>'

2022-01-08 Thread xiong duan
Hi Gunnar, In my opinion, The core parser is supported a common standard operator or syntax in different databases. The Babel parser is supported special grammar for a particular database.

[REQUEST ADVICE] Request advice about the CALCITE-4924

2021-12-28 Thread xiong duan
Hi followers, The [CALCITE-4924] needs some advice on how to fix it. Now, The aggregate functions about Covariance return the wrong data type, According to the ISO-SQL-2016, This is a bug need to fix. And it blocked [CALCITE-4871]

[SITE-IMPROVEMENT] Issue need to confirm about the API web

2021-12-28 Thread xiong duan
After checking the regenerate the Web, I noticed a small problem with the Calcite API URI https://calcite.apache.org/javadocAggregate/ . The doc title should be "Apache Calcite API", but is "Apache Calcite calcite API". Same as Avatica, The doc title should be " Apache Calcite Avatica API", but is

Re: [ANNOUNCE] Apache Calcite 1.29.0 released

2021-12-28 Thread xiong duan
Thanks for being RM, Rui! Chunwei Lei 于2021年12月28日周二 11:56写道: > Thanks for being RM, Rui! > > Best, > Chunwei > > > On Tue, Dec 28, 2021 at 6:33 AM Jacques Nadeau wrote: > > > This is great news! Thanks Rui for being RM. Thanks Julian for helping > > teach/facilitate the process. > > > > On

Re: Release notes preparation via release-drafter

2021-12-22 Thread xiong duan
We can’t request our contributor have a good branch name、title with fixed bug or body include this JIRA number when submitting a PR. So If we want it to work, we need The Contributor who merges the PR to confirm this PR has an appropriate label.

Re: Release notes preparation via release-drafter

2021-12-22 Thread xiong duan
Looks like I find it : https://github.com/marketplace/actions/release-drafter . Autolabeler Thanks.

Re: Release notes preparation via release-drafter

2021-12-22 Thread xiong duan
> Release drafter can automatically add labels based on the filenames. If we add new feature in class and modify the test class to add the feature unit test in one PR. Then the tools can labels this PR is a new feature or fix a bug? I want to know how “automatically” add labels based on the

Re: Release notes preparation via release-drafter

2021-12-22 Thread xiong duan
> Release drafter can automatically add labels based on the filenames. This is an accurate label ? I just want to confirm.

Re: Release notes preparation via release-drafter

2021-12-22 Thread xiong duan
Hi Vladimir, The example results looks very friendly. This will request to add another Label to every PR Then it can auto genarate the release notes. If this can work in Calcite, I am expected. > 2021年12月22日 下午7:36,Vladimir Sitnikov 写道: > > Hi, > > I suggest we start using Release Drafter

Re: [VOTE] Release apache-calcite-1.29.0 (release candidate 0)

2021-12-20 Thread xiong duan
+1. But some notices: 1: [ ] +1 Release this package as Apache Calcite *1.29.0 *not 1.27.0 2: I have added typos in https://github.com/apache/calcite/commit/cbfe0609edcc4a843d71497f159e3687a834119e Rui Wang 于2021年12月21日周二 09:27写道: > Hi all, > > I have created a build for Apache Calcite

Re: [ANNOUNCE] New committer: Alessandro Solimando

2021-12-18 Thread xiong duan
Congratulations Alessandro! Michael Mior 于2021年12月18日周六 22:46写道: > Congratulations Alessandro! > -- > Michael Mior > mm...@apache.org > > Le sam. 18 déc. 2021 à 09:09, Stamatis Zampetakis a > écrit : > > > > Apache Calcite's Project Management Committee (PMC) has invited > Alessandro > >

Re: Committer permissions

2021-12-18 Thread xiong duan
Hi Vladimir, I guess you need to set the Committer authority. Maybe can try https://gitbox.apache.org/setup/ to check your count. It includes three procedures: 1) authority for Apache Count 2) authority for Github Count 3) authority for Apache Organization Vladimir Ozerov 于2021年12月18日周六

Re: [Calcite Release] Preparing for 1.29.0 Release

2021-12-17 Thread xiong duan
Hi, Vladimir. The PR[https://github.com/apache/calcite/pull/2464] looks good. If you have free time Please resolve the conflicts. Then we can merge it. Vladimir Ozerov 于2021年12月18日周六 15:20写道: > Hi, > > Could you please also merge > https://github.com/apache/calcite/pull/2464 ? I guess it got

Re: [GITHUB-HELP] The Committer how to merge a PR correctly

2021-12-03 Thread xiong duan
t master > > > > > git merge > > > > > git push master > > > > is the branch with the commit to merge > > > > is the remote for the ASF Flink repository. > > > > 7. DONE > > > > Best, > > Jing Z

[GITHUB-HELP] The Committer how to merge a PR correctly

2021-12-02 Thread xiong duan
Hi, PMC and Committers. As a newcomer, I have one problem want to know. Do we have a procedure about The Committer how to merge a PR correctly? Every time I merge the PR, I always worried whether have a wrong step. So If have the standard procedure, It will be very helpful.

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2021-11-22 Thread xiong duan
r reasons. > > > > > > > On 11/22/2021 22:26,xiong duan wrote: > Great idea. +1 for an online meetup. > > Justin Swanhart 于2021年11月20日周六 上午12:42写道: > > +1 for an online meetup > > On Fri, Nov 19, 2021, 11:32 AM Jacques Nadeau wrote: > > WRT to talk

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2021-11-22 Thread xiong duan
Great idea. +1 for an online meetup. Justin Swanhart 于2021年11月20日周六 上午12:42写道: > +1 for an online meetup > > On Fri, Nov 19, 2021, 11:32 AM Jacques Nadeau wrote: > > > WRT to talk structure, I propose we do 5 or 10 minute lightning talks as > > opposed to something longer. It ensures a wider

Re: DISCUSS: merge calcite-avatica and calcite repositories

2021-11-08 Thread xiong duan
I have no opinion on merging the two repositories or don't. But If we don't merge it. About CALCITE-4877, Maybe we can: 1) we cancel test Calcite's master branch with Avatica's master branch directly. (It is unreasonable) When have an ISSUE need to submit PR in both, we can try: 1) If the PR is

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

2021-10-28 Thread xiong duan
This problem only occurs in large IN-lists, because small IN-lists - those smaller than SqlToRelConverter.Config.InSubQueryThreshold - are always converted to OR, and converting to OR always gives correct results. For correct results, IN-lists that reference column values must be converted to OR,

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

2021-10-20 Thread xiong duan
Hi Follower, Please help review this PR, So that I can make some improvements. Thanks very much. The XmlFunctions have the default error listener in jdk. And the default listener has two points that need to improvement: 1) As far as I know, In the different Java versions, the default listener has

Re: [VOTE] Release Apache Calcite 1.28.0 (release candidate 0)

2021-10-17 Thread xiong duan
+1 (binding). Have a problem with release notes https://github.com/apache/calcite/blob/calcite-1.28.0-rc0/site/_docs/history.md : *[CALCITE-4742] log '<>' don't handle very well. * Haisheng Yuan 于2021年10月18日周一 上午7:41写道: > Thank you for taking care of this release, Julian. > > 1. Checked

Re: [ANNOUNCE] New committer: Zhaohui Xu

2021-10-17 Thread xiong duan
Congratulations! Danny Chan 于2021年10月17日周日 下午6:13写道: > Congratulations ! > > Danny > > XING JIN 于2021年10月15日周五 下午5:34写道: > > > Congratulations ! > > > > Jin > > > > Michael Mior 于2021年10月15日周五 上午12:56写道: > > > > > Welcome Zhaohui! > > > -- > > > Michael Mior > > > mm...@apache.org > > > > > >

Re: Looking forward to joining the Calcite community

2021-10-17 Thread xiong duan
Hello Zhe Hu, Welcome to the community! We look forward to your contributions. Alessandro Solimando 于2021年10月17日周日 下午11:03写道: > Hello Zhe Hu, > welcome to the community! > > Best regards, > Alessandro > > > Il Dom 17 Ott 2021, 09:38 Francis Chuang ha > scritto: > > > Hey Zhe Hu, > > > >

  1   2   >