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

2023-07-19 Thread Chunwei Lei
Thanks Xiong Duan for being RM for this release. - Checked release notes on tag: some comments > Some improvements in simplify an expression. Some improvements in simplifying an expression. > [CALCITE-5717] RelBuilder.project of literals on a single-row `Aggregate` should create a Values I

Re: [ANNOUNCE] New committer: TJ Banghart

2023-07-09 Thread Chunwei Lei
Congrats, TJ! Best, Chunwei On Thu, Jul 6, 2023 at 4:02 AM Marieke Gueye wrote: > Yay TJ ! Well done > > On Wed, Jul 5, 2023 at 11:45 AM Julian Hyde > wrote: > > > Welcome, TJ! Thank you for your work on both Calcite and Avatica. > > > > As you’re my colleague, I know what you do, but

Re: [ANNOUNCE] New committer: Dan Zou

2023-07-09 Thread Chunwei Lei
Congratulations, Dan! Best, Chunwei On Thu, Jul 6, 2023 at 9:49 PM Tanner Clary wrote: > Congrats, Dan! It has been great working with you on some of the functions, > welcome! > > Best, > Tanner > > On Wed, Jul 5, 2023 at 12:12 PM Julian Hyde > wrote: > > > Welcome, Dan! And thank you for

Re: Employ bloom filters in joins

2023-05-04 Thread Chunwei Lei
It sounds like a Runtime Filter[1], which is commonly used by many systems. As Stamatis mentioned, integrating it into the cost model is much more challenging than implementing the rule. Fortunately, we can refer to the practices of other systems. [1]

Re: PR Approval for CI

2023-04-24 Thread Chunwei Lei
Hi, Zhe. The PR has been approved for CI. Best, Chunwei On Sun, Apr 23, 2023 at 10:47 PM Zhe Hu wrote: > Hi, community! > I’ve submitted a PR(https://github.com/apache/calcite/pull/3173) for > supporting CONVERT/TRANSLATE(value USING transcodingName), which requires > approval from a

Re: [DISCUSS] Sharing the load of reviewing PRs

2023-04-11 Thread Chunwei Lei
Thanks Julian for sharing the proposal. I am +1 for it. I have been busy in the past few months, so I have only had a quick look at the new JIRA. However, I will have more time in the coming months, and I would be more than happy to review any pull requests. Best, Chunwei On Tue, Apr 11, 2023

Re: Draft: board report for 2023 Q1

2023-04-11 Thread Chunwei Lei
+1 Thanks Stamatis! Best, Chunwei On Tue, Apr 11, 2023 at 9:59 AM LakeShen wrote: > +1, Thanks Stamatis.It clearly helps me to understand the latest progress > of Calcite community > > Best, > Lake Shen > > Dan Zou 于2023年4月7日周五 20:43写道: > > > +1, Thanks Stamatis > > Best, > > Dan Zou > > > >

Re: CI requiring approval for external contributors

2023-03-28 Thread Chunwei Lei
+1 for changing it back. Best, Chunwei On Wed, Mar 29, 2023 at 4:27 AM Francis Chuang wrote: > +1 This is a good idea and reduces the burden on committers to approve > the workflows. > > On 29/03/2023 12:37 am, Benchao Li wrote: > > I'm +1 for changing it back. > > > > I was also thinking

Re: [ANNOUNCE] New committer: Jiajun Xie

2023-02-12 Thread Chunwei Lei
Congratulations, Jiajun! Best, Chunwei On Mon, Feb 13, 2023 at 2:36 PM Sergey Nuyanzin wrote: > Congratulations, Jiajun! > > On Mon, Feb 13, 2023 at 3:06 AM 163 wrote: > > > Congratulations, Jiajun! > > > > > > Best, > > Dan Zou > > > > > > > > > > > > > 2023年2月11日 10:06,Benchao Li 写道: > >

Re: [DISCUSS] Drop unused branches from git repos

2023-01-27 Thread Chunwei Lei
+1 for the cleanup. Best, Chunwei On Thu, Jan 26, 2023 at 9:05 AM Benchao Li wrote: > +1, thanks for the effort. > > Sergey Nuyanzin 于2023年1月23日周一 20:02写道: > > > +1 for cleanup > > > > On Mon, Jan 23, 2023 at 9:53 AM Ruben Q L wrote: > > > > > +1 for the cleanup. > > > > > > Best, > > >

Re: [ANNOUNCE] New committer: Istvan Toth

2023-01-27 Thread Chunwei Lei
Congrats and welcome Istvan! Best, Chunwei On Fri, Jan 27, 2023 at 12:58 AM Istvan Toth wrote: > Thanks for the warm welcome to everyone! > > A few words about myself: > > I am from Hungary, and I work for Cloudera. > My focus is Apache Phoenix, and its sub-projects, but I also contribute to

Re: [ANNOUNCE] Benchao Li joins Calcite PMC

2023-01-27 Thread Chunwei Lei
Congrats, Benchao! Best, Chunwei On Fri, Jan 27, 2023 at 9:01 PM Michael Mior wrote: > Congratulations and welcome Benchao! > > -- > Michael Mior > mm...@apache.org > > > On Fri, Jan 27, 2023 at 4:51 AM Stamatis Zampetakis > wrote: > > > I am pleased to announce that Benchao has accepted an

Re: How to match the arbitrary number of RelNodes

2023-01-09 Thread Chunwei Lei
Hi, Aitozi. I think you can check RelRule#unorderedInputs[1]. One of its uses is PruneEmptyRules. [1] https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/plan/RelRule.java#L219 Best, Chunwei On Tue, Jan 10, 2023 at 12:32 AM Ruben Q L wrote: > Hello Aitozi, > >

Re: [ANNOUNCE] New committer: Alex Plehanov

2023-01-09 Thread Chunwei Lei
Welcome, Alex! Best, Chunwei On Sun, Jan 8, 2023 at 3:59 PM Alex Plehanov wrote: > Hello, > > Thanks for the warm welcome! A couple of words about myself: In Apache > Ignite we are developing the new SQL engine (based on Apache Calcite) as a > replacement for the old SQL engine. The old

Re: Draft: board report for 2022 Q4

2023-01-09 Thread Chunwei Lei
Thanks Ruben for preparing the report. It looks good to me. Best, Chunwei On Mon, Jan 9, 2023 at 4:02 PM Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Hello everyone, > thanks Ruben for preparing the report, it looks good to me. > > Best regards, > Alessandro > > On Sun, 8

Re: [ANNOUNCE] New committer: Bertil Chapuis

2022-10-18 Thread Chunwei Lei
Congratulations Bertil, welcome! Best, Chunwei On Mon, Oct 17, 2022 at 9:20 PM Michael Mior wrote: > Thank you and welcome Bertil! > > -- > Michael Mior > mm...@apache.org > > > On Sun, Oct 16, 2022 at 5:29 PM Julian Hyde wrote: > > > Apache Calcite's Project Management Committee (PMC) has

Re: [ANNOUNCE] Andrei Sereda joins Calcite PMC

2022-08-14 Thread Chunwei Lei
Congratulations, Andrei! Best, Chunwei On Sun, Aug 14, 2022 at 4:05 PM Jiajun Xie wrote: > Congratulations, Andrei! > > On Sun, 14 Aug 2022 at 10:50, Benchao Li wrote: > > > Congratulations Andrei! > > > > Francis Chuang 于2022年8月13日周六 09:53写道: > > > > > Congratulations Andrei! > > > > > >

Re: Question - Better human readable plan functionality

2022-08-09 Thread Chunwei Lei
Hi, Jay. As far as I know, there is no existing functionality that can do this job. We have the same requirement, especially when having to check whether the plan is correct. So I'm more than glad to have this feature. P.S. Apache Flink has done the job for its physical plan. Best, Chunwei

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

2022-07-31 Thread Chunwei Lei
Thanks Andrei for working on this. Mac OS X 10.16 x86_64,jdk 1.8.0_271,Gradle 7.3 - Checksum and signature: ok - Gradle test: ok - Went over release note: ok My vote is: +1 (binding) Best, Chunwei On Sat, Jul 30, 2022 at 10:10 PM Stamatis Zampetakis wrote: > Ubuntu 20.04.4 LTS,

Re: [ANNOUNCE] New committer: Jing Zhang

2022-07-03 Thread Chunwei Lei
Congratulations! Best, Chunwei On Mon, Jul 4, 2022 at 1:31 PM Forward Xu wrote: > Congratulations! > > > Best, > > ForwardXu > > Benchao Li 于2022年7月4日周一 13:11写道: > > > Congratulations Jing! > > > > Francis Chuang 于2022年7月4日周一 10:43写道: > > > > > Congrats! > > > > > > On 4/07/2022 12:42 pm,

Re: [ANNOUNCE] New committer: Benchao Li

2022-07-03 Thread Chunwei Lei
Congratulations! Best, Chunwei On Mon, Jul 4, 2022 at 1:32 PM Forward Xu wrote: > Congratulations! > > > Best, > > ForwardXu > > Francis Chuang 于2022年7月4日周一 10:21写道: > > > Congrats! > > > > On 4/07/2022 12:13 pm, Jiajun Xie wrote: > > > Congrat Benchao Li, Well deserved! > > > > > > On

Re: [DISCUSS] How we choose a PMC chair

2022-07-03 Thread Chunwei Lei
+1 to the improvement. Best, Chunwei On Mon, Jul 4, 2022 at 1:37 PM Forward Xu wrote: > +1 > > Haisheng Yuan 于2022年7月4日周一 08:32写道: > > > +1 to the improvement. > > > > On 2022/07/04 00:13:58 Francis Chuang wrote: > > > +1 I think this is a good idea. We have a lot of capable PMC members >

[jira] [Created] (CALCITE-5195) ArrayIndexOutOfBoundsException when inferring more equal conditions from join condition for semi join

2022-06-21 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-5195: Summary: ArrayIndexOutOfBoundsException when inferring more equal conditions from join condition for semi join Key: CALCITE-5195 URL: https://issues.apache.org/jira/browse

[jira] [Created] (CALCITE-5193) Push filter whose conditions include join keys and are composed by OR into inputs of full join

2022-06-15 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-5193: Summary: Push filter whose conditions include join keys and are composed by OR into inputs of full join Key: CALCITE-5193 URL: https://issues.apache.org/jira/browse/CALCITE-5193

Re: [ANNOUNCE] Chunwei Lei joins Calcite PMC

2022-06-06 Thread Chunwei Lei
Thanks everyone! It is a great honor to join the Calcite PMC. Best, Chunwei On Fri, May 27, 2022 at 10:26 AM Yanjing Wang wrote: > Congrats, Chunwei! > > Forward Xu 于2022年5月25日周三 15:17写道: > > > Congratulations, Chunwei! > > > > > > Best, > > > > Forwardxu > > > > Stamatis Zampetakis

Re: SQL column names - double quoted

2022-05-26 Thread Chunwei Lei
Hi Sandeep, In my project, I used the same way as what Yanjing proposed and it works well. Best, Chunwei On Fri, May 27, 2022 at 8:34 AM Yanjing Wang wrote: > Hi Sandeep, > > try select.toSqlString(new > >

Re: [DISCUSS] Towards Calcite 1.31.0

2022-05-25 Thread Chunwei Lei
Thank you for taking care of this, Ruben. +1 for mid-June for the first RC. Best, Chunwei On Wed, May 25, 2022 at 4:26 PM Ruben Q L wrote: > Hello, > > It has been more than two months since our last release [1], and I think we > should make an effort to continue keeping the rhythm of one

Re: [ANNOUNCE] Vladimir Ozerov joins Calcite PMC

2022-05-24 Thread Chunwei Lei
Congrats Vladimir! Best, Chunwei On Wed, May 25, 2022 at 9:17 AM xiong duan wrote: > 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

[jira] [Created] (CALCITE-5162) RelMdUniqueKeys can return more precise unique keys for Aggregate

2022-05-19 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-5162: Summary: RelMdUniqueKeys can return more precise unique keys for Aggregate Key: CALCITE-5162 URL: https://issues.apache.org/jira/browse/CALCITE-5162 Project: Calcite

Re: Join support in materialized view rewrite

2022-05-18 Thread Chunwei Lei
Hi Wang, As Stamatis said, the paper[1] indicates that the rewriting algorithm can be extended to support outer join. But I think it is not as easy as it says. Another paper[2] is about how to support outer join in rewriting. Hope it helps. [1]

[jira] [Created] (CALCITE-5149) Refine RelMdColumnUniqueness for Window by considering partition keys

2022-05-12 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-5149: Summary: Refine RelMdColumnUniqueness for Window by considering partition keys Key: CALCITE-5149 URL: https://issues.apache.org/jira/browse/CALCITE-5149 Project

Re: What is difference between The UnifyRule and MaterializedViewRule?

2022-05-09 Thread Chunwei Lei
Hi, LakeShen. You may find the answer in this doc[1]. [1] https://calcite.apache.org/docs/materialized_views.html Best, Chunwei On Sat, May 7, 2022 at 9:17 AM LakeShen wrote: > Hi community, > I recently looked at the Calcite materialized view, there are two ways > to rewrite the sql

Re: fixVersion

2022-05-08 Thread Chunwei Lei
Totally agree with Julian. Maybe we can also change the status of the issue to 'IN PROGRESS' if someone is working on it. Best, Chunwei On Mon, May 9, 2022 at 7:27 AM Francis Chuang wrote: > When releasing a version in jira, there's an option to transition issues > that were not resolved

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

2022-05-06 Thread Chunwei Lei
Mac OS X 10.16 x86_64, jdk 1.8.0_271, Gradle 7.3 - Checked the release note OK - Checked signatures and checksums OK - Built and ran tests OK +1 (non-binding) Best, Chunwei On Sat, May 7, 2022 at 6:04 AM Stamatis Zampetakis wrote: > Ubuntu 20.04.4 LTS, jdk1.8.0_251, Gradle wrapper, Gradle

[jira] [Created] (CALCITE-5131) Remove redundant type cast

2022-05-04 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-5131: Summary: Remove redundant type cast Key: CALCITE-5131 URL: https://issues.apache.org/jira/browse/CALCITE-5131 Project: Calcite Issue Type: Improvement

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

2021-12-28 Thread Chunwei Lei
Sounds reasonable to me. Best, Chunwei On Wed, Dec 29, 2021 at 6:44 AM xiong duan wrote: > 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

Re: [ANNOUNCE] Apache Calcite 1.29.0 released

2021-12-27 Thread Chunwei Lei
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 Mon, Dec 27, 2021 at 11:55 AM Stamatis Zampetakis > wrote: > > > Many thanks for being

Re: [DISCUSS] State of the project 2021

2021-12-19 Thread Chunwei Lei
Thank you for your work as chair, Haisheng. This year I saw many new contributors and committers, which inspires me a lot. And I also see that a number of issues are resolved, some of which exist for quite some time. What I have to mention is that we still have many pull requests and we owe them

Re: JIRA perm issues?

2021-12-13 Thread Chunwei Lei
I am able to resolve things in jira. Do you log in? Best, Chunwei On Tue, Dec 14, 2021 at 8:17 AM Jacques Nadeau wrote: > Hey all, I am no longer able to resolve things in jira (across multiple > projects). Are others seeing the same thing? The buttons are just gone and > most fields are no

Re: [VOTE] Move to GitHub PR-centric development workflow, phase out JIRA

2021-12-06 Thread Chunwei Lei
It's just my preference. I do not think current workflow is so painful that we have to replace it. Would the GitHub workflow boost our review? I doubt it somehow. Actually, I like the current workflow. Not only because I am used to it, but also it is easier to review all the discussions. Best,

Re: [VOTE] Move to GitHub PR-centric development workflow, phase out JIRA

2021-12-05 Thread Chunwei Lei
-1 I think JIRA works well. Best, Chunwei On Sat, Dec 4, 2021 at 1:39 PM Julian Hyde wrote: > -1 > > I’m happy with the status quo. > > > On Dec 3, 2021, at 9:34 AM, Vladimir Sitnikov < > sitnikov.vladi...@gmail.com> wrote: > > > > Hi, > > > > Let us have a vote for PR-centric workflow for

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

2021-11-29 Thread Chunwei Lei
+1 for the online meetup. Best, Chunwei On Fri, Nov 26, 2021 at 10:32 PM Florent Martineau wrote: > 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

回复:[DISCUSS] JIRA vs GitHub Issues

2021-11-29 Thread Chunwei Lei
+1 keep using ASF JIRA for issue management. I agree with all the advantages in Jing's apply. I think JIRA issues work well and navigating from PR to issue is not a big deal. Best, Chunwei -- 发件人:Jing Zhang

Re: Why calcite does not support outer join in materialized view

2021-11-23 Thread Chunwei Lei
Hi, Hongkang. Calcite has two ways to do query-rewriting, namely substitution, and rules[1]. MaterializedViewRule builds on the ideas presented in the paper[2], which does not talk much about outer-join rewriting. If you want to support outer join, you can try to use

[jira] [Created] (CALCITE-4895) MAP type in UDF cannot be externalized from json correctly

2021-11-19 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4895: Summary: MAP type in UDF cannot be externalized from json correctly Key: CALCITE-4895 URL: https://issues.apache.org/jira/browse/CALCITE-4895 Project: Calcite

[jira] [Created] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4893: Summary: JsonParseException happens when externalizing expressions with escape character from JSON Key: CALCITE-4893 URL: https://issues.apache.org/jira/browse/CALCITE-4893

[jira] [Created] (CALCITE-4884) Provide a new constructor for RelJsonWriter to allow customized JsonBuilder

2021-11-10 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4884: Summary: Provide a new constructor for RelJsonWriter to allow customized JsonBuilder Key: CALCITE-4884 URL: https://issues.apache.org/jira/browse/CALCITE-4884

[jira] [Created] (CALCITE-4883) The traitset of Exchange operator losses the distribution when externalizing Exchange operator from JSON

2021-11-10 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4883: Summary: The traitset of Exchange operator losses the distribution when externalizing Exchange operator from JSON Key: CALCITE-4883 URL: https://issues.apache.org/jira/browse

Re: Is there a mechanism for constant folding in Calcite?

2021-10-25 Thread Chunwei Lei
Hi, Ian. ReduceExpressionsRule is always used to do constant folding. Best, Chunwei On Tue, Oct 26, 2021 at 4:34 AM Ian Bertolacci wrote: > Howdy, > Does Calcite have any mechanism for applying constant folding to RexNodes > in a query? > > We’ve been wondering why expressions like `1 + 2`

Re: [ANNOUNCE] New committer: Xiong Duan

2021-10-25 Thread Chunwei Lei
Congratulations, Xiong! Best, Chunwei On Sun, Oct 24, 2021 at 6:34 AM Haisheng Yuan wrote: > Congrats, Xiong! > > On 2021/10/23 21:23:59, Francis Chuang wrote: > > Congratulations! > > > > On 24/10/2021 12:03 am, Stamatis Zampetakis wrote: > > > Apache Calcite's Project Management Committee

Re: Looking forward to joining the Calcite community

2021-10-17 Thread Chunwei Lei
Welcome to the community, Zhe Hu. Best, Chunwei On Mon, Oct 18, 2021 at 12:05 AM xiong duan wrote: > 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! > >

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

2021-10-17 Thread Chunwei Lei
+1 (non-binding). - Checked release notes - OK - Ran Gradle test - OK - Checked checksum and signature - OK Best, Chunwei On Mon, Oct 18, 2021 at 9:03 AM xiong duan wrote: > +1 (binding). > Have a problem with release notes > >

Re: [DISCUSS] Draft board report for Oct 2021

2021-10-17 Thread Chunwei Lei
Looks good to me. Thank you for your job, Haisheng! Best, Chunwei On Fri, Oct 15, 2021 at 1:41 AM Julian Hyde wrote: > The contributors are the people who have made commits that appear in > this release. You can generate the list as follows: > > $ ./sqlsh "select distinct author from

Re: [ANNOUNCE] New committer: Vladimir Ozerov

2021-06-28 Thread Chunwei Lei
Congratulations, Vladimir! Best, Chunwei On Sat, Jun 26, 2021 at 3:03 AM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > Vladimir, welcome! > > >consistent signal from the "field" - lack of documentation blocks > > I wonder if logging "missing sections" would help. > The catch here

Re: Issue with generating a basic physical plan

2021-03-14 Thread Chunwei Lei
Hi, Ishan. >From what I can see, that is because the table scan is not converted to BindableTableScan. Best, Chunwei On Sat, Mar 13, 2021 at 2:41 PM Sharma, Ishan wrote: > Hi Folks, > We are working on a dataflow system > and are using

Re: pull request submit

2021-03-10 Thread Chunwei Lei
Hi, sheng. Thank you for your PR. I would like to review the PR. Best, Chunwei On Wed, Mar 10, 2021 at 5:10 PM laughing.sh...@qq.com wrote: > > I have submit a fix about > https://issues.apache.org/jira/browse/CALCITE-4526, can community help me > to review it? > > > laughing.sh...@qq.com >

Re: Performance degradation during query planning (vs Calcite 1.25)

2021-02-21 Thread Chunwei Lei
Thank you for your work, Lgor. Would love to review the PR. Best, Chunwei On Fri, Feb 12, 2021 at 1:49 AM Igor Lozynskyi wrote: > Hi Calcite community! > > Before the upcoming 1.27 release, in a downstream project, my team started > the migration procedure. We had to accommodate our code

Re: [ANNOUNCE] New committer: Liya Fan

2021-02-21 Thread Chunwei Lei
Congratulations Liya! Best, Chunwei On Fri, Feb 12, 2021 at 5:28 PM Fan Liya wrote: > Dear all, > > I want to express my sincere gratitude to you for all your kind help. > I feel honored to have the opportunity of working with you in this awesome > community. > > In the past years, I have

Re: [DISCUSS] Apache Calcite Online Meetup January 2021

2021-01-14 Thread Chunwei Lei
, 2021 at 10:57 AM Chunwei Lei wrote: > Hi, Stamatis. > > How can I submit my PGP key? (It's my first time to attend an online > meetup~~) > > > > Best, > Chunwei > > > -- > 发件人:Stamatis Zampetakis

回复:[DISCUSS] Apache Calcite Online Meetup January 2021

2021-01-14 Thread Chunwei Lei
Hi, Stamatis. How can I submit my PGP key? (It's my first time to attend an online meetup~~) Best, Chunwei -- 发件人:Stamatis Zampetakis 发送时间:2021年1月15日(星期五) 07:10 收件人:dev 主 题:Re: [DISCUSS] Apache Calcite Online Meetup January

Re: [HELP] Local build fails

2020-12-09 Thread Chunwei Lei
Vladimir, Julian, Liya, thank you very much for your help. It works now. Best, Chunwei On Thu, Dec 10, 2020 at 4:12 AM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > Fixed. > > Vladimir >

Re: [HELP] Local build fails

2020-12-08 Thread Chunwei Lei
I have tried jdk1.8.0_271. But I still get the error. > Task :plus:forbiddenApisMain FAILED > Task :release:distTar Source distribution is created: /Users/chunwei.lcw/Desktop/dev_src/calcite/release/build/distributions/apache-calcite-1.27.0-SNAPSHOT-src.tar.gz Build calcite FAILURE reason:

Re: [Bug Report]RelToSqlConverter stack error in 1.24-1.26

2020-12-07 Thread Chunwei Lei
Hi, Tao. Thank you for your report. It would be great if you can file an JIRA and provide a test case that can reproduce the error. Best, Chunwei On Tue, Dec 8, 2020 at 2:33 PM tonytao wrote: > Hi folks, > > I found a RelToSqlConverter bug existed in 1.24-1.26. > > I has a logical plan as

[jira] [Created] (CALCITE-4429) createCastRel should throw an exception when the field count of the row type to to be converted and desired row type is not equal

2020-12-07 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4429: Summary: createCastRel should throw an exception when the field count of the row type to to be converted and desired row type is not equal Key: CALCITE-4429 URL: https

Re: [HELP] Local build fails

2020-12-04 Thread Chunwei Lei
My Java version is: java version "1.8.0_151" Java(TM) SE Runtime Environment (build 1.8.0_151-b12) Java HotSpot(TM) 64-Bit Server VM (build 25.151-b12, mixed mode) The exception happened recently. I would try the latest JDK. Thank you very much for your suggestion, Vladimir. Best, Chunwei

[HELP] Local build fails

2020-12-04 Thread Chunwei Lei
Hi, all. Currently when I build the Calcite code using the following command: > dev_src/calcite$ ./gradlew build It fails with an exception: > Task :plus:forbiddenApisMain FAILED Build calcite FAILURE reason: Execution failed for task ':plus:forbiddenApisMain': Caused by:

Re: TpchTest#testQuery07 timeout when running continuous-integration/appveyor/pr

2020-12-03 Thread Chunwei Lei
Thank you for your effort, Aron. I am wondering if you can file a jira issue and paste your findings. I would like to look into it if I find some time. Best, Chunwei On Thu, Dec 3, 2020 at 1:15 PM JiaTao Tao wrote: > Hi Vladimir > Thanks for your reply: > 1. I run TpchTest#testQuery07 in my

[jira] [Created] (CALCITE-4421) AssertionError is thrown with empty message

2020-11-29 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4421: Summary: AssertionError is thrown with empty message Key: CALCITE-4421 URL: https://issues.apache.org/jira/browse/CALCITE-4421 Project: Calcite Issue Type

Re: How to convert a logical operator into multiple physical operators

2020-11-26 Thread Chunwei Lei
Hi, Bhavya. I think all you need to do is to create the node correctly. You can refer to how the EnumerableMergeJoin is created[1]. [1] https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/adapter/enumerable/EnumerableJoinRule.java#L86 Best, Chunwei On Fri, Nov

Re: [DISCUSS] Does anybody think this is debuging unfriendly: "call.transformTo(relBuilder.build())"

2020-11-24 Thread Chunwei Lei
I have the same feeling. But I am +0 on this change considering: 1) we can not forbid users to write such code. 2) there might be other codes that are not debug-friendly and we can not change them all. Best, Chunwei On Tue, Nov 24, 2020 at 10:59 AM JiaTao Tao wrote: > Hi James > My point is

Re: Decouple core from linq4j and Avatica

2020-11-24 Thread Chunwei Lei
I like the idea. But I have the same worry as Haisheng. Best, Chunwei On Wed, Nov 25, 2020 at 3:07 PM Xin Wang wrote: > +1 for this idea. We only use the parser/optimizer part. > > JiaTao Tao 于2020年11月25日周三 下午2:38写道: > > > +1 for this idea, I have been developing Calcite for a long

Re: Status of JIRA tasks labeled "newbie"

2020-11-15 Thread Chunwei Lei
Welcome, Louis. You can take over some tickets that do not have an assignee. Best, Chunwei On Mon, Nov 16, 2020 at 4:22 AM Xiaowei Kuang wrote: > Hi everyone, > > I'm trying to learn more and build up my understanding about > Calcite's system internals by working on small beginner tasks. The

Re: [DISCUSS] State of the project 2020

2020-11-08 Thread Chunwei Lei
Hi Stamatis, Thank you for sharing this detailed information and appreciate your excellent work as our chair. It's an honor to be part of this awesome project. As we can see, we have more and more people who are willing to contribute. But some of them might do not know our convention. So the

Re: [DISCUSS] Make SqlNodeList implement List

2020-11-04 Thread Chunwei Lei
Thank you for raising this, Julian. How much performance improvement can we get? Best, Chunwei On Thu, Nov 5, 2020 at 5:32 AM Julian Hyde wrote: > Currently class SqlNodeList [1] implements Iterable but it > does not implement List. How do people feel about doing that? > (Or Collection?) >

[jira] [Created] (CALCITE-4368) TopDownOptTest fails if applying non-substitution rule first

2020-10-30 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4368: Summary: TopDownOptTest fails if applying non-substitution rule first Key: CALCITE-4368 URL: https://issues.apache.org/jira/browse/CALCITE-4368 Project: Calcite

[jira] [Created] (CALCITE-4360) Should apply SubstituteRule first in top-down driven rule apply

2020-10-27 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4360: Summary: Should apply SubstituteRule first in top-down driven rule apply Key: CALCITE-4360 URL: https://issues.apache.org/jira/browse/CALCITE-4360 Project: Calcite

Re: Why ProjectJoinTransposeRule not in Calcite default rule set.

2020-10-26 Thread Chunwei Lei
Note that RelOptUtil#registerDefaultRules is marked as experimental and it excludes quite a few rules. It might not be as perfect as expected. Feel free to improve it if needed. Best, Chunwei On Tue, Oct 27, 2020 at 2:13 AM Rui Wang wrote: > If you include "ProjectJoinTransposeRule" as a

Re: JavaCC version being used in Calcite?

2020-10-22 Thread Chunwei Lei
Hi, Rui. I think the javaCC version is 4.0. I used the following command: ./gradlew core:dependencies | grep javacc javaccClaspath \--- net.java.dev.javacc:javacc:4.0 Best, Chunwei On Thu, Oct 22, 2020 at 12:03 PM Rui Wang wrote: > Hi community, > > Where to find the current JavaCC used

Re: Physical Query Plan Generation

2020-10-18 Thread Chunwei Lei
Hi Shubh, I think some test cases in Calcite would help you a lot. For example, you can refer to TopDownOptTest to see how it works. [1] https://github.com/apache/calcite/blob/master/core/src/test/java/org/apache/calcite/test/TopDownOptTest.java Best, Chunwei On Sun, Oct 18, 2020 at 10:00 PM

Re: [DISCUSS] Apache Calcite Online Meetup January 2021

2020-10-15 Thread Chunwei Lei
It would be great! I am glad to attend such a meetup. Best, Chunwei On Fri, Oct 16, 2020 at 12:50 PM Julian Hyde wrote: > Nice idea, Stamatis. I'm happy to give a talk if people want to hear > it - possible topics include geospatial in Calcite, quick intro to > RelBuilder, and

Re: TableScan#explainTerms may be not enough for digest

2020-10-12 Thread Chunwei Lei
I agree with Danny. In our system, we also have to override the RelOptTable#getQualifiedName to get more information except for the table name. Best, Chunwei On Sat, Oct 10, 2020 at 10:37 AM JiaTao Tao wrote: > Hi Haishen > See this: > HepPlanner#addRelToGraph > > Pair> key =

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

2020-10-12 Thread Chunwei Lei
Thank you for your work, Ruben! Rlease is not easy for the first time. It would be great if every new release manager can make some improvements to the doc. Best, Chunwei On Wed, Oct 7, 2020 at 6:22 PM Ruben Q L wrote: > Thanks Danny. > > It is hard work (especially the first time), but our

Re: [DISCUSS] Towards Calcite 1.26.0

2020-09-24 Thread Chunwei Lei
Thank you for driving this, Ruben. The schedule looks good to me. Best, Chunwei On Thu, Sep 24, 2020 at 3:26 AM Rui Wang wrote: > Thanks for all your help! Will experiment how it works best for me! > > > -Rui > > On Wed, Sep 23, 2020 at 12:06 PM Ruben Q L wrote: > > > Rui, > > I am not a

Re: [ANNOUNCE] New committer: Rui Wang

2020-09-09 Thread Chunwei Lei
Congratulations, Rui! Well deserved! Best, Chunwei On Thu, Sep 10, 2020 at 10:28 AM Feng Zhu wrote: > Congrats Rui! > Good Job in Streams, well deserved! > > Best, > Feng > > Stamatis Zampetakis 于2020年9月10日周四 上午5:51写道: > > > Apache Calcite's Project Management Committee (PMC) has invited

[jira] [Created] (CALCITE-4239) RelMdUniqueKeys returns wrong unique keys for Aggregate with grouping sets

2020-09-09 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4239: Summary: RelMdUniqueKeys returns wrong unique keys for Aggregate with grouping sets Key: CALCITE-4239 URL: https://issues.apache.org/jira/browse/CALCITE-4239 Project

Re: How about add a method for "RelNode" that can get the same string like RelOptUtil.toString

2020-09-03 Thread Chunwei Lei
Tips: we can discuss in JIRA[1]. [1] https://issues.apache.org/jira/browse/CALCITE-4224 Best, Chunwei On Thu, Sep 3, 2020 at 4:49 PM JiaTao Tao wrote: > As a calcite dev, I call this method dozens of times, especially in > debugging, it's not so convenient. > > "RelNode" has an API for its

[jira] [Created] (CALCITE-4223) Introducing column statistics to RelOptTable

2020-09-03 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4223: Summary: Introducing column statistics to RelOptTable Key: CALCITE-4223 URL: https://issues.apache.org/jira/browse/CALCITE-4223 Project: Calcite Issue Type

[jira] [Created] (CALCITE-4203) RelMdUniqueKeys should not return empty when meeting Intersect and Minus if its input has unique keys

2020-08-31 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4203: Summary: RelMdUniqueKeys should not return empty when meeting Intersect and Minus if its input has unique keys Key: CALCITE-4203 URL: https://issues.apache.org/jira/browse

Re: [DISCUSS] Sarg (search argument) to generalize and replace IN in RexCall

2020-08-30 Thread Chunwei Lei
Hi, Julian. I would like to review it. Best, Chunwei On Sat, Aug 29, 2020 at 5:19 AM Julian Hyde wrote: > I now have a PR for this change. Can some people review? > > https://github.com/apache/calcite/pull/2124 < > https://github.com/apache/calcite/pull/2124> > > There are legitimate

Re: Where to config elasticsearch username/password?

2020-08-30 Thread Chunwei Lei
Hi, I hope the doc[1] helps. [1] https://calcite.apache.org/docs/elasticsearch_adapter.html. Best, Chunwei On Tue, Aug 25, 2020 at 2:08 PM 发给官兵 wrote: > Hi, the dev of calcite: > I asked a question at JIRA. > > >

Re: [DISCUSS] Open SVN dist access to committers

2020-08-13 Thread Chunwei Lei
Awesome! It really helps for the committers as release manager. Best, Chunwei On Fri, Aug 14, 2020 at 6:58 AM Julian Hyde wrote: > Thanks for the clarification, Sebb. We now know, and accept, that the risk > is non-zero. > > > On Aug 13, 2020, at 2:17 PM, sebbaz wrote: > > > > > > > > On

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

2020-08-12 Thread Chunwei Lei
> Once this release is done, we should consider whether we should give committers write access to SVN to avoid these issues in the future. I am not sure if this is possible or if this is just the way ASF's infra is set up, but it's worth a look. I cannot agree more. Thank you for pointing out,

Re: [ANNOUNCE] Apache Calcite 1.24.0 released

2020-07-27 Thread Chunwei Lei
Julian, I have sent the email to annou...@apache.org. [image: image.png] But now I found that it failed because I didn't use the apache email address. [image: image.png] I will send it again. Sorry about that. Best, Chunwei On Tue, Jul 28, 2020 at 6:02 AM Julian Hyde wrote: > Chunwei,

Re: [ANNOUNCE] Apache Calcite 1.24.0 released

2020-07-27 Thread Chunwei Lei
Jul 27, 2020 at 9:53 AM Chunwei Lei wrote: > > The link address of the Presto dialect implementation seems to be wrong. > > Oops, you're right. I will update it as soon as possible. Thanks for your > kindly reminder, Forward. > > > Best, > Chunwei > > > On Mon,

Re: [ANNOUNCE] Apache Calcite 1.24.0 released

2020-07-26 Thread Chunwei Lei
elease! > > > > -Rui > > On Sun, Jul 26, 2020 at 1:48 AM Forward Xu wrote: > > > Thanks! Chunwei! Good job. > > > > The link address of the Presto dialect implementation in > > https://calcite.apache.org/news/2020/07/24/release-1.24.0/ seems to be > > wrong. &g

Master branch is open for commits

2020-07-25 Thread Chunwei Lei
Hi, all. Apache Calcite 1.24.0 has been released, therefor the master is open for commits now. Best, Chunwei

Re: [ANNOUNCE] Apache Calcite 1.24.0 released

2020-07-25 Thread Chunwei Lei
aracter literals as column aliases), 4128 (refactor CSV/file adapters). > > Julian > > > > On Jul 25, 2020, at 9:19 AM, Stamatis Zampetakis > wrote: > > > > Thanks Chunwei for leading this and of course all of our contributors for > > their high quality work.

Re: Changing JIRAs' status to “Closed”

2020-07-25 Thread Chunwei Lei
93%40%3Cdev.calcite.apache.org%3E > > On 2020/07/25 07:55:00, Francis Chuang wrote: > > I've added you to the administrator role. You should be able to do that > now. > > > > Francis > > > > On 25/07/2020 4:45 pm, Chunwei Lei wrote: > > > Hi, >

[ANNOUNCE] Apache Calcite 1.24.0 released

2020-07-25 Thread Chunwei Lei
The Apache Calcite team is pleased to announce the release of Apache Calcite 1.24.0. Calcite is a dynamic data management framework. Its cost-based optimizer converts queries, represented in relational algebra, into executable plans. Calcite supports many front-end languages and back-end data

Changing JIRAs' status to “Closed”

2020-07-25 Thread Chunwei Lei
Hi, I tried to do a bulk update changing JIRAs' status to “Closed”. But I can not find the button. Is it because I don't have such permission? Appreciate your help! Best, Chunwei

  1   2   3   >