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

2022-01-19 Thread 953396112
Congratulations to Ruben!   Thanks for serving as Chair, Haisheng! Best regards, Zhaohui Xu --  -- ??: "dev"

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

2022-01-19 Thread Francis Chuang
Congrats Ruben! On 20/01/2022 4:23 pm, Zhe Hu wrote: Congratulations to Ruben! Thanks for serving as Chair during the last year, Haisheng! Best regards, ZheHu On 01/20/2022 13:09,Jacques Nadeau wrote: Ditto, thanks Haisheng and congrats Ruben! On Wed, Jan 19, 2022, 6:35 PM Julian Hyde

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

2022-01-19 Thread Zhe Hu
Congratulations to Ruben! Thanks for serving as Chair during the last year, Haisheng! Best regards, ZheHu On 01/20/2022 13:09,Jacques Nadeau wrote: Ditto, thanks Haisheng and congrats Ruben! On Wed, Jan 19, 2022, 6:35 PM Julian Hyde wrote: Congratulations, Ruben, and good luck! Haishe

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

2022-01-19 Thread Jacques Nadeau
Ditto, thanks Haisheng and congrats Ruben! On Wed, Jan 19, 2022, 6:35 PM Julian Hyde wrote: > Congratulations, Ruben, and good luck! > > Haisheng, Thank you for serving as Chair. > > Julian > > On Wed, Jan 19, 2022 at 6:29 PM Haisheng Yuan wrote: > > > > Calcite community members, > > > > I am

Re: [DISCUSS] Refactoring tests

2022-01-19 Thread Jacques Nadeau
Unfortunately, the last minute attendance of the meetup today threw my schedule off and I won't be able to look at this for at least a few days. Don't feel obligated to hold up for me. On Wed, Jan 19, 2022, 9:04 AM Jacques Nadeau wrote: > FYI, I'm trying to do a thorough review today (as much as

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2022-01-19 Thread Gavin Ray
Thank you for hosting this, and it was nice to listen to the discussion and learn. I was sad Julian did not make it, I hoped he might be there to share wisdom. There were two things I wanted to drop as a note really quick: 1) If there's enough interest, maybe these sorts of meetups could happen

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

2022-01-19 Thread Julian Hyde
Congratulations, Ruben, and good luck! Haisheng, Thank you for serving as Chair. Julian On Wed, Jan 19, 2022 at 6:29 PM Haisheng Yuan wrote: > > Calcite community members, > > I am pleased to announce that we have a new PMC chair and VP as per our > tradition of rotating the chair once a year.

[ANNOUNCE] New Calcite PMC chair: Ruben Q L

2022-01-19 Thread Haisheng Yuan
Calcite community members, I am pleased to announce that we have a new PMC chair and VP as per our tradition of rotating the chair once a year. I have resigned, and Ruben Q L was duly elected by the PMC and approved unanimously by the Board. Please join me in congratulating Ruben! Best, Haisheng

Re: New rule for Converting UNION ALL with same inputs but different filters to single input with OR FILTER

2022-01-19 Thread Julian Hyde
Justin, For planning table or index scans, I would recommend using a single TableScan with a Filter that uses a Sarg, rather than using multiple TableScans connected by a Union. So I think this rule will be useful. But I do agree that this proposed rule is not a “no brainer”. It may not do wha

Re: New rule for Converting UNION ALL with same inputs but different filters to single input with OR FILTER

2022-01-19 Thread Justin Swanhart
Hi, Note that this will negate the optimization that one usually is looking for when writing such queries: Select * from TAB where a = 1 UNION ALL Select * from TAB where b = 1 In a database with indexes (most databases) this will allow indexes to be used on both the a column and the b column. D

Re: New rule for Converting UNION ALL with same inputs but different filters to single input with OR FILTER

2022-01-19 Thread Julian Hyde
Can you log a Jira case for this? I think you should make your rule work for N-way Union, not just 2-way Union. And I think you should make it work whether or not a Project is present. > On Jan 19, 2022, at 1:25 PM, Julian Hyde wrote: > > It sounds useful. > > What do you think the rule shoul

Re: New rule for Converting UNION ALL with same inputs but different filters to single input with OR FILTER

2022-01-19 Thread Julian Hyde
It sounds useful. What do you think the rule should be called? UnionFilterTransposeRule, perhaps? A challenge when writing the rule will be to ensure that all of the inputs to the Union are the same. The Volcano framework is not very good at that. You should be careful of the case that the cond

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2022-01-19 Thread Eugen Stan
Hi, I published my presentation here https://ieugen.github.io/calcite-clj/ for anyone who is interested. Once the video is up I will add a link to it as well. It was nice meeting with you! Regards, -- Eugen Stan +40770 941 271 / https://www.netdava.combegin:vcard fn:Eugen Stan n:Stan;Eugen

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2022-01-19 Thread Jacques Nadeau
In future, I suggest we just post the zoom link here. This one is still going here: https://cloudera.zoom.us/j/91701199263 On Wed, Jan 19, 2022 at 10:33 AM Julian Hyde wrote: > For what it’s worth, I had trouble logging into Meetup.com (from both an > iPhone and a macOS laptop) and so missed th

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2022-01-19 Thread Julian Hyde
For what it’s worth, I had trouble logging into Meetup.com (from both an iPhone and a macOS laptop) and so missed the meetup. > On Jan 19, 2022, at 9:08 AM, Jacques Nadeau wrote: > > Shoot, totally missed that this was using meetup.com. Figured the date/time > would be discussed here. In the fu

Re: Projection for SELECT COUNT(*)

2022-01-19 Thread Jacques Nadeau
I think Viliam's complaint is that the fields aren't being trimmed from the scan. I don't remember the details but my question is whether this code is running [1] And whether it is behaving as expected. I assume you've enabled trim fields [2] on SqlToRel? [1] https://github.com/apache/calcite/bl

Re: Projection for SELECT COUNT(*)

2022-01-19 Thread Justin Swanhart
Hi, So what you are saying is when the TableScan gets a zero length record (no projections means no record is projected so it has a length of zero) it treats that as a request to read all columns instead of zero columns? That sounds like a bug in the TableScan. On Wed, Jan 19, 2022 at 10:32 AM V

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2022-01-19 Thread Jacques Nadeau
Shoot, totally missed that this was using meetup.com. Figured the date/time would be discussed here. In the future would be helpful to also mention time/date on the mailing list. On Wed, Jan 19, 2022, 8:43 AM Stamatis Zampetakis wrote: > Forgo the link to the event: > https://www.meetup.com/Apac

Re: [DISCUSS] Refactoring tests

2022-01-19 Thread Jacques Nadeau
FYI, I'm trying to do a thorough review today (as much as possible with patch this size). On Wed, Jan 19, 2022, 4:36 AM Michael Mior wrote: > Thanks for doing this Julian! I haven't been able to do a detailed review, > but from my skim of the PR, this looks like a nice improvement. I think > it'

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2022-01-19 Thread Stamatis Zampetakis
Forgo the link to the event: https://www.meetup.com/Apache-Calcite/events/282836907/ On Wed, Jan 19, 2022 at 5:42 PM Stamatis Zampetakis wrote: > Small reminder: the meetup starts in ~15 minutes. > > Best, > Stamatis > > On Wed, Jan 12, 2022 at 11:30 PM Stamatis Zampetakis > wrote: > >> Hi, >>

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2022-01-19 Thread Stamatis Zampetakis
Small reminder: the meetup starts in ~15 minutes. Best, Stamatis On Wed, Jan 12, 2022 at 11:30 PM Stamatis Zampetakis wrote: > Hi, > > I read the previous emails about the GraphQL project and it looks > very interesting. > @Gavin: Please send us a title, abstract, and duration of the talk. > Do

Re: Projection for SELECT COUNT(*)

2022-01-19 Thread Viliam Durina
The issue here is not with zero-field records. The issue is that when doing `SELECT COUNT(*)`, the sql-to-rel conversion doesn't produce a projection with just a dummy constant to have one field, but there's no projection at all and all fields are read from the TableScan. Viliam On Wed, 19 Jan 20

Re: Apache Calcite - Usage of Querable table/Querable/RawQueryable/etc interfaces

2022-01-19 Thread Gavin Ray
My apologies, I didn't realize that the updated search wasn't public now (it opened for me a few days ago) Regular GH links: https://github.com/search?q=rawqueryable+language%3AJava&type=code Searching "CalciteConnection" across all repos, but removing "apache/calcite" from the results: https://g

Re: [DISCUSS] Refactoring tests

2022-01-19 Thread Michael Mior
Thanks for doing this Julian! I haven't been able to do a detailed review, but from my skim of the PR, this looks like a nice improvement. I think it's always been a bit difficult for new Calcite developers to write good tests, especially for new modules. So anything that helps that experience is v

Re: New rule for Converting UNION ALL with same inputs but different filters to single input with OR FILTER

2022-01-19 Thread Yanjing Wang
A simple example is converting *SELECT a, b FROM t WHERE c = 1 UNION ALL SELECT a, b FROM t WHERE c = 2 *to *SELECT a, b FROM t WHERE c in (1, 2)* Yanjing Wang 于2022年1月19日周三 18:35写道: > Hi, community > > Here I recommend a new rule for converting UNION ALL sub plan to a single > input with an OR

New rule for Converting UNION ALL with same inputs but different filters to single input with OR FILTER

2022-01-19 Thread Yanjing Wang
Hi, community Here I recommend a new rule for converting UNION ALL sub plan to a single input with an OR filter, the following is its conversion diagram. [image: UnionAllToOrRule.jpg] The conversion prerequisites are 1. left filter range has no intersection with right filter range. 2. Project and