Re: [Calcite Release] Finalizing 1.29.0 release

2021-12-29 Thread Rui Wang
delay to Maven > central. We should adjust HOWTO accordingly. > > One last nitpick. Rui sent a result email with subject ‘Re: [VOTE]’. The > subject should have been ‘[RESULT] [VOTE]’. > > Julian > > > > On Dec 25, 2021, at 10:10 PM, Rui Wang wrote: > > > &g

Fwd: [ANNOUNCE] Apache Calcite 1.29.0 released

2021-12-26 Thread Rui Wang
Hi Community, I am happy to announce that 1.29.0 is released and the Calcite main branch is unlocked now. -Rui -- Forwarded message - From: Rui Wang Date: Sun, Dec 26, 2021 at 9:15 PM Subject: [ANNOUNCE] Apache Calcite 1.29.0 released To: The Apache Calcite team is pleased

Re: [Calcite Release] Finalizing 1.29.0 release

2021-12-25 Thread Rui Wang
Thanks Francis! -Rui On Sat, Dec 25, 2021 at 9:27 PM Francis Chuang wrote: > Hey Rui, > > I just registered 1.29.0 as released on 2021-12-26. > > Francis > > On 26/12/2021 4:23 pm, Rui Wang wrote: > > Hi community, > > > > Can a PMC member help upd

[Calcite Release] Finalizing 1.29.0 release

2021-12-25 Thread Rui Wang
Hi community, Can a PMC member help update the 1.29.0 release version and date at https://reporter.apache.org/addrelease.html?calcite? For the release date please use 12-26-2021 UTC time. -Rui

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

2021-12-23 Thread Rui Wang
> > > - Verified GPG signature - OK > > > - Verified SHA512 - OK > > > - Checked release notes - OK > > > - Ran gradle tests - OK > > > > > > Environment: > > > macOS Big Sur, Java 17+35-LTS-2724 > > > Gradle 7.3 > > &

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

2021-12-21 Thread Rui Wang
contains contributions from 23 authors, and resolves 47 issues’ . I > would definitely mention the upgrade to log4j2. Others at your discretion. > > Julian > > > > On Dec 20, 2021, at 5:27 PM, Rui Wang wrote: > > > > Hi all, > > > > I have created a bui

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

2021-12-20 Thread Rui Wang
Hi all, I have created a build for Apache Calcite 1.29.0, release candidate 0. Thanks to everyone who has contributed to this release. You can read the release notes here: https://github.com/apache/calcite/blob/calcite-1.29.0-rc0/site/_docs/history.md The commit to be voted upon:

[jira] [Created] (CALCITE-4955) Release Calcite 1.29.0

2021-12-20 Thread Rui Wang (Jira)
Rui Wang created CALCITE-4955: - Summary: Release Calcite 1.29.0 Key: CALCITE-4955 URL: https://issues.apache.org/jira/browse/CALCITE-4955 Project: Calcite Issue Type: Task Reporter

Re: [Calcite Release] Preparing for 1.29.0 Release

2021-12-20 Thread Rui Wang
After I switched from Mac to Ubuntu, the dependency check starts to work :) -Rui On Mon, Dec 20, 2021 at 11:47 AM Rui Wang wrote: > I am Generate a report of vulnerabilities that occur among dependencies > when running `./gradlew :dependencyCheckUpdate`, I consistently hit >

Re: [Calcite Release] Preparing for 1.29.0 Release

2021-12-20 Thread Rui Wang
nyone seen it in the past? -Rui On Sun, Dec 19, 2021 at 6:26 PM Rui Wang wrote: > Hi community, > > Now the main branch is locked at [1]. I will work toward RC0. > > > [1] > https://github.com/apache/calcite/commit/7a7b37fc1f4bd2121643539b0fd8e9c4f0f8ed09 > > > -Rui > &

Re: [Calcite Release] Preparing for 1.29.0 Release

2021-12-19 Thread Rui Wang
> I have merged https://github.com/apache/calcite/pull/2628 ( > https://issues.apache.org/jira/browse/CALCITE-4917) into master. > > Best regards, > Alessandro > > On Sat, 18 Dec 2021 at 21:21, Rui Wang wrote: > > > Thanks for more information Julian. Then t

Re: [Calcite Release] Preparing for 1.29.0 Release

2021-12-18 Thread Rui Wang
< > > https://github.com/apache/calcite/pull/2464>] looks good. If you > > >>>>> have > > >>>>> free time Please resolve the conflicts. Then we can merge it. > > >>>>> > > >>>>> Vladimir Oz

Re: [Calcite Release] Preparing for 1.29.0 Release

2021-12-17 Thread Rui Wang
Thanks Julian! Now we will just decide whether to merge CALCITE-4907 or not, then I will lock the main branch and start the release process. -Rui On Fri, Dec 17, 2021 at 10:29 PM Julian Hyde wrote: > Rui, I have merged CALCITE-4946. > > > On Dec 17, 2021, at 10:21 PM, Rui

Re: [Calcite Release] Preparing for 1.29.0 Release

2021-12-17 Thread Rui Wang
ed CALCITE-4948 to mitigate the concerns around CALCITE-4898 and > maven repositories and category x licenses. > > On Fri, Dec 17, 2021 at 1:02 PM Rui Wang wrote: > > For the list of 1.29 fix Jira, several Jira have been marked as resolved > since this Monday. I will do another pass

Re: [Calcite Release] Preparing for 1.29.0 Release

2021-12-17 Thread Rui Wang
tps://issues.apache.org/jira/browse/CALCITE-4907 < > > https://issues.apache.org/jira/browse/CALCITE-4907> (Francesco Gini) > > > > What’s the status on those? > > > > Julian > > > > [1] https://github.com/apache/calcite/pull/2622 < > > http

Re: [DISCUSS] Do we need a Avatica release before Calcite 1.29.0 release?

2021-12-13 Thread Rui Wang
eed an > Avatica release afterall... > > Let's see how that discussion resolves. > > On Thu, Dec 9, 2021 at 12:47 PM Rui Wang wrote: > > > Ack thanks! > > > > If there is no objection until the end of this week I will just go for > the > > 1.29.0 release process. &g

Re: [DISCUSS] Do we need a Avatica release before Calcite 1.29.0 release?

2021-12-09 Thread Rui Wang
onfigurable > SPNEGO Jetty implementation (6 weeks ago) > > * 95c1eb06e - [CALCITE-4828] Standard exception console output (7 weeks > ago) > > * e462b09d4 - [CALCITE-4837] FLOOR/CEIL for DECADE, CENTURY, MILLENIUM > return wrong results (8 weeks ago) > > * ef277ff34 -

Re: [DISCUSS] Calcite 1.29.0 release

2021-12-09 Thread Rui Wang
Thank you! -Rui On Thu, Dec 9, 2021 at 2:36 AM Stamatis Zampetakis wrote: > Done ;) > > On Wed, Dec 8, 2021 at 9:10 PM Rui Wang wrote: > > > Can a PMC member help to add my public key[[1] to the Calcite KEYs > file[2] > > ? > > > > > > [1]: https

[DISCUSS] Do we need a Avatica release before Calcite 1.29.0 release?

2021-12-08 Thread Rui Wang
Hi community, Do you think we need an Avatica release before Calcite 1.29.0? -Rui

Re: [DISCUSS] Calcite 1.29.0 release

2021-12-08 Thread Rui Wang
ocs/howto.html#making-a-release-candidate < > https://calcite.apache.org/docs/howto.html#making-a-release-candidate> > > > On Dec 6, 2021, at 1:36 PM, Rui Wang wrote: > > > > I am planning to spend some time this week to learn about the Calcite > > release pr

Re: [DISCUSS] Calcite 1.29.0 release

2021-12-06 Thread Rui Wang
Rui Wang wrote: > Thanks Julian. That sounds good. I will revisit the release process at the > beginning of Dec to check what preparation work I need to do. > > > -Rui > > On Tue, Nov 23, 2021 at 8:34 AM Julian Hyde > wrote: > >> In my opinion, the more often

Re: [DISCUSS] Calcite 1.29.0 release

2021-11-23 Thread Rui Wang
ter contributors, who are the next > generation of committers and PMC members. > > Julian > > > On Nov 22, 2021, at 6:26 PM, Rui Wang wrote: > > > > Hi community, > > > > 1.28.0 was released on around 10/15. I volunteered to release > > Calcite 1.29.0. I am

[DISCUSS] Calcite 1.29.0 release

2021-11-22 Thread Rui Wang
Hi community, 1.28.0 was released on around 10/15. I volunteered to release Calcite 1.29.0. I am wondering what is the expected date/week to work toward to 1.29.0? Should we expect to cut in this December or wait until early next year? I will need to reserve my time, probably a week, once we

Re: Requesting a review on a PR----[CALCITE-4661]

2021-07-01 Thread Rui Wang
I will take a look within this week. -Rui On Wed, Jun 30, 2021 at 6:55 PM xiong duan wrote: > Hi Follower, Please review this PR, So that I can make some improvements. > Thank you. >

Re: [DISCUSS] Release Managers

2021-06-04 Thread Rui Wang
In another related thread I volunteered for releasing 1.29.0. I think I can still do it. -Rui On Thu, Jun 3, 2021 at 7:09 PM Fan Liya wrote: > Hi Haisheng, > > I am interested in volunteering. > > Best, > Liya Fan > > On Fri, Jun 4, 2021 at 6:50 AM Julian Hyde wrote: > > > Yes, I am release

Re: [DISCUSS] Towards Calcite 1.27.0

2021-05-24 Thread Rui Wang
Please tag me on PRs that you need my help. I will check those soon. -Rui On Mon, May 24, 2021 at 11:06 AM Julian Hyde wrote: > We still need 5 committers to review 5 PRs each. Please reply to this > email to volunteer. > > On Fri, May 21, 2021 at 3:41 PM Stamatis Zampetakis > wrote: > > > >

Re: Calcite development using IntelliJ

2021-05-18 Thread Rui Wang
Also occasionally, I found that some of the issues might go away if I have the project compiled by command line. -Rui On Tue, May 18, 2021 at 10:39 AM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > > I had to "build.gradle.kts Right Click->Import as Gradle Project" > > Just

Re: Proposal to extend Calcite into a incremental query optimizer

2021-05-13 Thread Rui Wang
It should be the main example > we use in conference talks, blog posts, etc. When people understand that > case, we can explain how we generalize from K=2 to arbitrary K. > > Julian > > > > On May 13, 2021, at 9:51 AM, Rui Wang wrote: > > > > I apologize that I

Re: Proposal to extend Calcite into a incremental query optimizer

2021-05-13 Thread Rui Wang
time to clean up > our > >> > code > >> > > > > base > >> > > > > >>>> and > >> > > > > >>>> > publicly release it (which will be out soon) for a quick > >> peek. > >> > > &g

Re: PR Review

2021-03-07 Thread Rui Wang
Hi Malte, Thanks for your PR. I will take a look soon (<1d). -Rui On Sun, Mar 7, 2021 at 2:21 AM Malte Bellmann wrote: > Hello, > > I've updated a PR I started in August last year. It got buried by now, can > someone have a look? > > The PR is https://github.com/apache/calcite/pull/2118 < >

Re: Google Summer of Code 2021

2021-03-05 Thread Rui Wang
> > Best, > Stamatis > > On Mon, Mar 1, 2021 at 5:46 AM Rui Wang wrote: > > > Sounds good. > > > > My understanding at this moment is that, if there is an interesting idea, > > make sure creating a JIRA and label that by "mentor" and "gs

Re: mapPartitions

2021-03-04 Thread Rui Wang
ite/rel/logical/LogicalTableFunctionScan.html > Can i model a mapPartitions T -> U as ^ ? > > On Thu, Mar 4, 2021 at 12:06 PM Rui Wang wrote: > > > I feel like the mapPartitions can be implemented as a SELECT + GROUP BY, > > where GROUP BY is to partition the data, then per partition

Re: mapPartitions

2021-03-04 Thread Rui Wang
ns and flatMapGroupsWithState, and it looks > as > > >> if you are talking about Apache Spark operations. Can you give some > > >> examples of typical queries that would use these operations? > > >> > > >> It’s possible that these operations accomplish t

Re: mapPartitions

2021-03-03 Thread Rui Wang
Well I think the expected approach is to translate other operations to relational operators by yourself ;-) I think Calcite won't be the place to have extensions for such translation. The main concern is that those non relational operations are "non-standard". -Rui On Wed, Mar 3, 2021 at 10:12

Re: Google Summer of Code 2021

2021-02-28 Thread Rui Wang
tps://lists.apache.org/thread.html/f0ea9594f151e7f6ad9b7f305fc2c87d99f64acac2cc76e179a1a1f7%40%3Cdev.calcite.apache.org%3E > > > > I would definitely love to see this happen. It would be a great > > opportunity for students to learn something new and interesting and a > &g

Google Summer of Code 2021

2021-02-25 Thread Rui Wang
Hi community, Does Calcite ever participate in Google Summer of Code (GSoC) [1]. What do you think of creating smaller projects and allowing students to pick them up? I used to host two GSoC students for Apache Beam and I found the collaboration was smooth and students could add valuable

Re: [ANNOUNCE] New committer: Liya Fan

2021-02-10 Thread Rui Wang
Congratulations Liya! -Rui On Wed, Feb 10, 2021 at 6:39 AM Michael Mior wrote: > Congratulations and welcome Liya! > -- > Michael Mior > mm...@apache.org > > Le mer. 10 févr. 2021 à 05:23, Francis Chuang > a écrit : > > > > Congrats Liya and well deserved! > > > > Francis > > > > On

Re: [DISCUSS] Release Managers

2021-02-02 Thread Rui Wang
I can also help on releasing (haven't done one for Calcite). -Rui On Tue, Aug 18, 2020 at 2:32 PM Julian Hyde wrote: > I haven't been RM for a while. I'll do 1.27, then Stamatis can do 1.28. > > On Sun, Aug 16, 2020 at 1:57 AM Stamatis Zampetakis > wrote: > > > > Depending on the timing I

Re: Proposal to extend Calcite into a incremental query optimizer

2021-01-28 Thread Rui Wang
For me to participate in the discussion for the above questions, I will need to read a lot more to know relevant context and likely ask lots of questions :-). A editable doc is probably good for questions and back and forward discussion. -Rui On Thu, Jan 28, 2021 at 10:50 AM Rui Wang wrote

Re: Proposal to extend Calcite into a incremental query optimizer

2021-01-28 Thread Rui Wang
I am also happy to help push this work into Calcite (review code and doc, etc.). While you can share your code so people can have more idea how it is implemented, I think it would be also nice to have a doc to discuss open questions above. Some points that I copy those to here: 1. Can this

Re: Adding new operators to Calcite

2021-01-28 Thread Rui Wang
I think your ANY operator's signature is ANY(column_name, )? In this case you might use Descriptor operator as an example to see how does a operator that accepts column name work:

Re: custom Operator or customExpression

2021-01-27 Thread Rui Wang
Could you clarify your goal a bit more? Are you trying to add a function named "INFIX_CAST" starting from the parser? -Rui On Tue, Jan 26, 2021 at 6:38 PM laughing.sh...@qq.com wrote: > Hi,community: > 1. when I add binaryOpratorsTokens in default_config.fmpp, like > binaryOperatorsTokens:

Re: [DISCUSS] Draft board report for Jan 2021

2021-01-12 Thread Rui Wang
This draft looks good overall! Thanks Haisheng for your work! -Rui On Tue, Jan 12, 2021 at 3:48 PM Haisheng Yuan wrote: > Stamatis, > Thanks a lot for the numbers you collected, I will add them into the > report. > > Julian, > Thanks for the remind, I will add the mention of new chair and our

Re: Proposal to extend Calcite into a incremental query optimizer

2021-01-11 Thread Rui Wang
Congratulations on your work! And thanks for considering contributing it to Calcite! I tried to have a pass on your paper, and have a question: It seems like for concrete implementations for merge operator and delta query for joins/aggregation, the paper adopts some algorithms and ideas that

Re: [DISCUSS] Apache Calcite Online Meetup January 2021

2020-11-29 Thread Rui Wang
). Duration: 20~30 mins On Tue, Nov 24, 2020 at 8:56 AM Slim Bouguerra wrote: > this is a great idea thanks @Statmatis looking forward to learning more > about Calcite especially the Streaming work. > > On Mon, Nov 23, 2020 at 2:19 PM Rui Wang wrote: > > > Sorry for the la

Re: [DISCUSS] Apache Calcite Online Meetup January 2021

2020-11-23 Thread Rui Wang
t; > > > > > +1 for the online meeting, nice idea ~ > > > > > > > > Best, > > > > Danny Chan > > > > 在 2020年10月22日 +0800 PM5:58,JiaTao Tao ,写道: > > > > > I think it's a nice idea, hope to hear Julian's topic about > > l

Re: [Question] How to leverage Calcite adaptor for federated SQL query without using Calcite parser

2020-11-23 Thread Rui Wang
I think Michael has said points that I can say. Just try to understand your problem after reads existing threads: Sounds like, you need to do two things: 1. Reuse Calcite adaptors and combine that with your parser to parse queries. 2. Convert results from 1. to RelNode and let Calcite optimize,

Re: Status of JIRA tasks labeled "newbie"

2020-11-16 Thread Rui Wang
Alternatively, for the trait push down optimization effort, there are some well defined tasks: https://issues.apache.org/jira/browse/CALCITE-4052. If you are interested, you can pick up some tasks from there :) I am happy to help you get familiar with those tasks and review your code. -Rui On

Re: [DISCUSS] State of the project 2020

2020-11-11 Thread Rui Wang
Thanks Stamatis for serving as the PMC chair for Calcite in 2020! One of the highlights I want to give for the PR reviewing/merging area was the practice we started to adopt in recent releases: we started to check each JIRA marked with the right release version and see whether there is a PR in a

Re: [DISCUSS] Make SqlNodeList implement ListSqlNode>

2020-11-05 Thread Rui Wang
+1 on potential performance gain. If I have some time, I will try to research and understand how fast the space preallocation can offer. -Rui On Thu, Nov 5, 2020 at 12:34 AM Fan Liya wrote: > IMO, the major advantage of Iterable over List is that we do not need to > know all the elements

Re: [DISCUSS] Support Oracle Polymorphic Table Function Syntax

2020-10-30 Thread Rui Wang
's not use TUMBLE (or HOP, or SESSION) as the main example. It is > > > somewhat built-in (i.e. has special treatment in the code). Let's work > > > in terms of, say, the RAMP user-defined function. It is used in > > > several tests [1]. > > > >

Re: [DISCUSS] Screenshots of stack traces, code, and debugger sessions

2020-10-29 Thread Rui Wang
>People who write to dev@ list and attach the stacktrace as an image don't >really know if the list accepts images or not. >Making images forbidden does not help to teach people to >attach stacktraces as text. I guess the way will be when we see those cases, we reply to ask to replace the image

Re: [DISCUSS] Support Oracle Polymorphic Table Function Syntax

2020-10-29 Thread Rui Wang
In terms of SQL grammar to support omitting TABLE, there are actually two changes for SELECT * FROM TABLE(TUMBLE(TABLE Bid, DESCRIPTOR(bidtime), INTERVAL '10' MINUTES)); You can support omitting the TABLE after the FROM, which makes the query become: SELECT * FROM TUMBLE(TABLE Bid,

Re: Why ProjectJoinTransposeRule not in Calcite default rule set.

2020-10-26 Thread Rui Wang
If you include "ProjectJoinTransposeRule" as a default rule, what impact will it have? Will some unit tests need to be updated? -Rui On Mon, Oct 26, 2020 at 2:14 AM Fan Liya wrote: > I also think the ProjectJoinTransposeRule should be included in the main > optimizer process. > > Best, > Liya

Re: [DISCUSS] Some quesitons about the new introduced window table functions (TUMBLE, HOP and SESSION)

2020-10-23 Thread Rui Wang
nsavaSE2JeE4 > > > Danny Chan 于2020年10月22日周四 下午7:40写道: > > > Rui Wang, can you help to consult with the author of the window TVF > syntax > > ? We want to hear more suggestions. > > > > cc @Rui Wang > > > > Rui Wang 于2020年10月22日周四 下午1

Re: JavaCC version being used in Calcite?

2020-10-22 Thread Rui Wang
> > > > Best, > Chunwei > > > On Thu, Oct 22, 2020 at 12:03 PM Rui Wang wrote: > > > Hi community, > > > > Where to find the current JavaCC used in Calcite? What I can tell is > > Calcite core is using a JavaCC plugin [1], but after that I have lost the &

JavaCC version being used in Calcite?

2020-10-21 Thread Rui Wang
Hi community, Where to find the current JavaCC used in Calcite? What I can tell is Calcite core is using a JavaCC plugin [1], but after that I have lost the track to locate the version number? [1]:

Re: Physical Query Plan Generation

2020-10-16 Thread Rui Wang
You can refer to function to understand Calcite planner API at higher level: https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/java/org/apache/beam/sdk/extensions/sql/impl/CalciteQueryPlanner.java#L155 -Rui On Fri, Oct 16, 2020 at 1:58 PM Shubh Sharma wrote: >

Re: [DISCUSS] Apache Calcite Online Meetup January 2021

2020-10-15 Thread Rui Wang
I can give a small talk (10 to 20 mins) about changes of Calcite to support streaming. -Rui On Thu, Oct 15, 2020 at 7:19 AM Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Hi Stamatis, > that's a very nice idea, I am definitely interested in attending a meetup > and hearing

Re: I'd like to join the calcite community

2020-10-13 Thread Rui Wang
Welcome! BTW, If you share your JIRA username then people here can give you permission then you will be able to assign Jira to yourseulf. -Rui On Tue, Oct 13, 2020 at 7:23 AM guangyuan wang wrote: > Hello, everyone. > My name is Guangyuan Wang. I'm a java software engineer and also an Apache

Re: [ DISCUSS] The window table functions join syntax

2020-09-24 Thread Rui Wang
; > > > The problem is with the semantics of these particular table functions > > > - HOP, TUMBLE, SESSION - and what semantics are desirable depends on > > > how people will typically use them. Is it common to follow TUMBLE with > > > TUMBLE? What would a user

Re: [DISCUSS] Towards Calcite 1.26.0

2020-09-23 Thread Rui Wang
quickly back it out with a force push to > > master. > > > > Maybe I'm a git dinosaur, but I always use the command line to merge > > my own and others' changes. I don't trust the github UI to do exactly > > what I want. > > > > On Wed, Sep 23, 2020 at 11:

Re: [DISCUSS] Towards Calcite 1.26.0

2020-09-23 Thread Rui Wang
Thanks Ruben for kicking off 1.26.0 release! Can I ask a question here: how can I squash commits to merge https://github.com/apache/calcite/pull/2160? I am worried that if I click the "rebase and merge", it will push two commits into the Calcite main branch. -Rui On Wed, Sep 23, 2020 at 11:38

Re: [ DISCUSS] The window table functions join syntax

2020-09-23 Thread Rui Wang
> > > You can also use > > > > > > SELECT L.f0, R.f2, L.window_start, L.window_end > > > FROM > > > Tumble(table T1, descriptor(T1.ts), INTERVAL ‘5’ MINUTE) L > > > JOIN > > > Tumble(table T2, descriptor(T2.ts), INTERVAL ‘5’ M

Re: [ DISCUSS] The window table functions join syntax

2020-09-23 Thread Rui Wang
Regarding to **L.window_start = R.window_start AND L.window_end = R.window_end**: In general, the current table function windowing model is to append window metadata to table directly, thus window metadata becomes a part of table (or call it data). So as a part of table, these two columns should

Re: [ DISCUSS] The window table functions join syntax

2020-09-22 Thread Rui Wang
Hi Danny, seems like the "Red" syntax is missing? I am guessing you were talking about "L.window_start = R.window_start AND L.window_end = R.window_end"? Can you use ** to indicate the red part. Two additional questions: > The Join action is triggered by the watermark of the stream So sounds

[jira] [Created] (CALCITE-4269) Improvement on enumerable implementation for HOP and SESSION

2020-09-20 Thread Rui Wang (Jira)
Rui Wang created CALCITE-4269: - Summary: Improvement on enumerable implementation for HOP and SESSION Key: CALCITE-4269 URL: https://issues.apache.org/jira/browse/CALCITE-4269 Project: Calcite

Re: [ANNOUNCE] New committer: Rui Wang

2020-09-09 Thread Rui Wang
; > Feng > > > > Stamatis Zampetakis 于2020年9月10日周四 上午5:51写道: > > > > > Apache Calcite's Project Management Committee (PMC) has invited Rui > Wang > > to > > > become a committer, and we are pleased to announce that he has > accepted. > > > > &g

[jira] [Created] (CALCITE-4176) Key descriptor can be optional in SESSION table function

2020-08-13 Thread Rui Wang (Jira)
Rui Wang created CALCITE-4176: - Summary: Key descriptor can be optional in SESSION table function Key: CALCITE-4176 URL: https://issues.apache.org/jira/browse/CALCITE-4176 Project: Calcite Issue

Re: [DISCUSS] Open SVN dist access to committers

2020-08-13 Thread Rui Wang
+1 if well used/tested svn commands for releasing are documented, committers without experience on release or svn can still use those properly. -Rui On Thu, Aug 13, 2020 at 3:09 PM Stamatis Zampetakis wrote: > +1 > > I always thought that committers had access to the dist repo and I was >

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

2020-08-12 Thread Rui Wang
Congrats, Ruben! Well deserved! -Rui On Wed, Aug 12, 2020 at 9:24 AM Enrico Olivelli wrote: > Congrats Ruben! > > Enrico > > Il Mer 12 Ago 2020, 18:05 Michael Mior ha scritto: > > > Congrats Reuben! > > > > -- > > Michael Mior > > mm...@apache.org > > > > Le mer. 12 août 2020 à 09:32, Ruben

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

2020-08-09 Thread Rui Wang
t; OpenJDK Runtime Environment (build 14.0.2+12-46) > > OpenJDK 64-Bit Server VM (build 14.0.2+12-46, mixed mode, sharing) > > > > My vote is: +1 (binding) > > > > Francis > > > > On 10/08/2020 4:10 am, Rui Wang wrote: > > > +1 (non-binding) > > > >

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

2020-08-09 Thread Rui Wang
+1 (non-binding) platform: ubuntu16 + java8 run tests locally on: ok verify the commit hash in git tag: ok check sha512: ok verify signature by gpg: ok one thing can be fixed after vote: CALCITE-4114 does not belong to "breaking changes" in the release note. That change happened in core/test

Re: [DISCUSS] Towards Calcite 1.25.0

2020-08-08 Thread Rui Wang
Is the highlight section a right place for [1] as it has bigger impact? [1] https://github.com/apache/calcite/commit/19edf52c76c6a1507721f5bd37f2a33497aa0c4c -Rui On Fri, Aug 7, 2020 at 9:48 PM Andrei Sereda wrote: > Hello, > > Does anybody want to mention any highlights for 1.25 besides

[jira] [Created] (CALCITE-4164) Create a Spec doc for EMIT syntax

2020-08-06 Thread Rui Wang (Jira)
Rui Wang created CALCITE-4164: - Summary: Create a Spec doc for EMIT syntax Key: CALCITE-4164 URL: https://issues.apache.org/jira/browse/CALCITE-4164 Project: Calcite Issue Type: Sub-task

Re: Re: Implementation of DISTINCT and ORDER BY

2020-08-04 Thread Rui Wang
[name_last] DESC > > So, just wanted to make sure that this is the right approach. > > Regards, > Hrudaya > > -Original Message- > From: Rui Wang > Sent: Monday, August 3, 2020 10:08 PM > To: dev@calcite.apache.org > Subject: [EXTERNAL] Re: Implementation of DISTI

Re: Implementation of DISTINCT and ORDER BY

2020-08-03 Thread Rui Wang
I did a test locally and I found your example syntax is correct. I used "select distinct deptno, empno from emp order by empno desc" and Calcite generates this plan: LogicalSort(sort0=[$1], dir0=[DESC]) LogicalAggregate(group=[{0, 1}]) LogicalProject(DEPTNO=[$7], EMPNO=[$0])

[jira] [Created] (CALCITE-4153) Implement EMIT AFTER WATERMARK

2020-08-03 Thread Rui Wang (Jira)
Rui Wang created CALCITE-4153: - Summary: Implement EMIT AFTER WATERMARK Key: CALCITE-4153 URL: https://issues.apache.org/jira/browse/CALCITE-4153 Project: Calcite Issue Type: Sub-task

Re: Avatica and HepPlanner

2020-08-02 Thread Rui Wang
I tried to dig into the Calcite codebase and found there is likely no way to enable JDBC codepath: 1. There is no planner config in CalciteConnectionProperty [1]. 2. In CalcitePrepareImpl, there is only one createPlannerFactory with one createPlanner, in which VolcanoPlanner is used [2]. If my

[jira] [Created] (CALCITE-4146) Implement EMIT AFTER WATERMARK

2020-07-28 Thread Rui Wang (Jira)
Rui Wang created CALCITE-4146: - Summary: Implement EMIT AFTER WATERMARK Key: CALCITE-4146 URL: https://issues.apache.org/jira/browse/CALCITE-4146 Project: Calcite Issue Type: Sub-task

Re: [ANNOUNCE] Apache Calcite 1.24.0 released

2020-07-26 Thread Rui Wang
Thanks Chunwei for leading this release! -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. > > Best, > Forward > >

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

2020-07-21 Thread Rui Wang
+1 (non-binding) - downloaded the artifacts, checked hash, verified signature, built and ran tests. All are OK - use `diff -r` to compare the artifact and the git tag. Like what Julian has pointed out, I can find a difference about license but it can be addressed after this vote. -Rui On Tue,

Re: [DISCUSS] New RexNode: RexListCmp

2020-07-20 Thread Rui Wang
Hi Haisheng, Do you know what is the impact on Enumerable implementation? Will RexListCmp still be converted AND/OR something else in that layer or there will be new logic introduced to generate code for RexListCmp? -Rui On Sun, Jul 19, 2020 at 10:13 PM Enrico Olivelli wrote: > Il Lun 20 Lug

Re: [DISCUSS] Remove "final" from AbstractRelNode#getRelTypeName

2020-07-16 Thread Rui Wang
is sometimes used intentionally to limit the API surface area. > > > > Julian > > > > [1] > > > https://github.com/apache/calcite/commit/6bb7e2d0b65ec3c7a0d82c92ca0564f8caec4af5 > > > > On Thu, Jul 16, 2020 at 10:33 AM Rui Wang wrote: > > > > >

Re: [DISCUSS] Remove "final" from AbstractRelNode#getRelTypeName

2020-07-16 Thread Rui Wang
+1 to make getRelTypeName overridable. Not a java language expert, to me when there are cases that a public API with final cannot solve, it's a good sign to remove that final to allow customization to solve those specific use cases. -Rui On Thu, Jul 16, 2020 at 8:58 AM Haisheng Yuan wrote: >

Re: [DISCUSS] Towards Calcite 1.24.0

2020-07-15 Thread Rui Wang
Regarding CALCITE-4000, the PR should be ready to merge now. Thanks for all the help from Feng, Danny and Chuwei! -Rui On Tue, Jul 14, 2020 at 11:11 PM Chunwei Lei wrote: > Thank you for all your effort. > > Now there're only two issues(CALCITE-4000[1] and CALCITE-4118[2]) to > be fixed in

Re: Calcite and Enum Type

2020-07-15 Thread Rui Wang
Hi Talat, I am guessing when you say logical type, you mean something like this in Beam [1]. My question is why do you need Calcite to support ENUM? If you use logical type, you can define a ENUM by yourself and the underlying type can be a Map. Map is supported by Calcite. So ENUM will be

Re: Calcite PR CI offten failed due to elasticsearch:test

2020-07-13 Thread Rui Wang
Here Andrei, Here is an example of a failed PR check that was failed due to elasticsearch:test: https://ci.appveyor.com/project/ApacheSoftwareFoundation/calcite/builds/33662741 See that failed Jdk11 check log. -Rui On Sun, Jul 12, 2020 at 4:31 PM Andrei Sereda wrote: > Hello, > > Can

Re: [DISCUSS] Towards Calcite 1.24.0

2020-07-09 Thread Rui Wang
Thanks Chunwei, I am actively working on getting CALCITE-4000 and CALCITE-4015 reviewed and merged by next week. Question: are you planning to follow the practice of the last release (i.e. lock master branch and clean up JIRA with fix version 1.24.0 marked before re-open master branch?) -Rui

Re: [DISCUSS] Make RexNode serializable

2020-07-08 Thread Rui Wang
BTW, if use 'externalize', what is the opposite side of it? Is it `internalize` (which doesn't sound right)? Or call it "de-externalize"? -Rui On Wed, Jul 8, 2020 at 4:02 PM Rui Wang wrote: > O got it :-) > > > -Rui > > On Wed, Jul 8, 2020 at 3:55 PM Julian H

Re: [DISCUSS] Make RexNode serializable

2020-07-08 Thread Rui Wang
O got it :-) -Rui On Wed, Jul 8, 2020 at 3:55 PM Julian Hyde wrote: > Please call it 'externalize'. 'Serialize' gives some folks PTSD. :) > > On Wed, Jul 8, 2020 at 2:26 PM Rui Wang wrote: > > > > Thanks everyone for your inputs. Now it sounds like RexNode serializati

Re: [DISCUSS] Make RexNode serializable

2020-07-08 Thread Rui Wang
9c3/core/src/test/java/org/apache/calcite/plan/RelWriterTest.java#L88 > > > > > > -- > > > Roman Kondakov > > > > > > On 07.07.2020 22:13, Enrico Olivelli wrote: > > > > Rui > > > > > > > > Il Mar 7 Lug 2020, 20:30 Rui Wa

Re: Correlated subquery losing aggregator operator in inner join?

2020-07-07 Thread Rui Wang
Since this discussion is moved to email thread, I just copy something I found and replied in that JIRA for the reference: SqlToRelConverter ends with creating a RexSubQuery for that subquery, and leaves it to JOIN condition. The string representation of RexSubQuery seems just $7. If you check

[DISCUSS] Make RexNode serializable

2020-07-07 Thread Rui Wang
Hi Community, In Apache Beam we are facing a use case where we need to keep RexNode in our distributed primitives. Because of the nature of distributed computing, Beam requires the usage of those primitives be serializable (thus those primitives can be sent over the network to backend/workers for

Re: Using the Calcite Babel Parser as a Blackbox

2020-06-27 Thread Rui Wang
Hi, I created a maven project and used 1.22.0 Calcite artifacts to make your code work: https://github.com/amaliujia/CalciteParser. Does this work for you? -Rui On Fri, Jun 26, 2020 at 12:44 PM Subin Lee wrote: > Hello! > > I hope this email finds you well. My name is Subin and I am an

Re: Help to parse spark dialect

2020-06-26 Thread Rui Wang
There was a relevant thread about PostgresQL dialect, you might check it as a reference: https://lists.apache.org/thread.html/r906f15c3f7a276ae5e2c68f79a11dc111c5862579848ab8f379b9925%40%3Cdev.calcite.apache.org%3E -Rui On Fri, Jun 26, 2020 at 1:26 PM Tang, Mingjun wrote: > Hi dear calcite

Re: Question about timestampdiff

2020-06-21 Thread Rui Wang
I think it is because there is no clear mapping for how to convert a month (and then same to year) in interval to seconds/milliseconds. Does a month have 30 days, 31 days, 28 days or 29 days? (Probably can find an answer in SQL standard). -Rui On Sun, Jun 21, 2020 at 4:00 PM Rommel

Re: Nested data handling in Caclite

2020-06-19 Thread Rui Wang
If it goes back to make struct flattening configurable (thus can be turned off), you could check this thread for some context: https://lists.apache.org/thread.html/6bc9fd2e4c8d09e71740b0544df0982acf0d64321b9d5dc68db6acf1%40%3Cdev.calcite.apache.org%3E -Rui On Fri, Jun 19, 2020 at 1:21 AM Danny

Re: Nested data handling in Caclite

2020-06-15 Thread Rui Wang
>Also I am thinking about turning off the flatten stage but not sure this is >going to happen (seems like a pandora box kind of flag where you do not >know what to expect) It is not happening to make flattener optional by setting a flag (see [1]). If there is anything that is not properly

Re: Why migrate from Maven to Gradle

2020-06-12 Thread Rui Wang
2) you might work it around in your own fork. Additional question: why do you want to migrate back to Maven? -Rui On Fri, Jun 12, 2020 at 11:07 AM Rui Wang wrote: > This email thread contains some discussions: > https://lists.apache.org

  1   2   3   >