Re: [ANNOUNCE] New committer: Alessandro Solimando

Congrats Alessandro ! Well deserved. On Sat, Dec 18, 2021 at 9:46 AM Zoltan Haindrich wrote: > Congartulations Alessandro! > > On 12/18/21 4:42 PM, Enrico Olivelli wrote: > > Congrats! > > Enrico > > > > Il Sab 18 Dic 2021, 16:00 Alessandro Solimando < > > alessandro.solima...@gmail.com> ha

Re: [ANNOUNCE] New committer: Vineet Garg

Congratulations Vineet ! -Aman On Sat, Apr 25, 2020 at 7:15 PM Feng Zhu wrote: > Congratulations, well deserved! > > best, > Feng > > Chunwei Lei 于2020年4月26日周日 上午10:12写道： > > > Congrats, Vineet! > > > > > > Best, > > Chunwei > > > > > > On Sun, Apr 26, 2020 at 8:24 AM Haisheng Yuan wrote: >

[jira] [Created] (CALCITE-3390) ITEM expression does not get pushed to the right input of left-outer-join

Aman Sinha created CALCITE-3390: --- Summary: ITEM expression does not get pushed to the right input of left-outer-join Key: CALCITE-3390 URL: https://issues.apache.org/jira/browse/CALCITE-3390 Project

Re: Selectivity of BETWEEN predicates

alcite. > > Julian > > > > On Feb 23, 2019, at 10:07 PM, Aman Sinha wrote: > > > > Hi devs, > > I am trying to estimate the selectivity of BETWEEN predicates using > > histograms. Calcite will convert it to a conjunction. > > e.g WHERE c1 BETWEEN

Selectivity of BETWEEN predicates

Hi devs, I am trying to estimate the selectivity of BETWEEN predicates using histograms. Calcite will convert it to a conjunction. e.g WHERE c1 BETWEEN 10 and 20 ==> WHERE c1 >= 10 AND c1 <= 20 The question is : what's the formula for the selectivity of the top level AND expression ?

Re: [ANNOUNCE] New Calcite PMC chair: Francis Chuang

Congratulations Francis ! Thanks for your efforts. -Aman On Fri, Dec 21, 2018 at 11:58 PM Stamatis Zampetakis wrote: > Congrats for the new role Francis! > > Michael, thanks a lot for the all time and effort you put serving as a > chair! > > Calcite community is lucky to have you both. > >

Re: [DISCUSS] Where do we draw the line?

My 2 cents: I hope Vladimir realizes that there is a small community of developers who understand query optimizers and are willing to contribute to it. Its a complex area and he cannot do it alone. His constructive comments are welcome but not the arrogance/mockery in the code review. Those will

Re: [ANNOUNCE] Volodymyr Vysotskyi joins Calcite PMC

Congratulations Volodymyr ! On Mon, Jul 9, 2018 at 7:09 AM Arina Yelchiyeva wrote: > Congratulations Vova! > > Kind regards, > Arina > > On Mon, Jul 9, 2018 at 4:58 PM Michael Mior wrote: > > > I'm pleased to announce that Volodymyr has accepted an invitation to > > join the Calcite PMC.

Re: DISTINCT ON clause

DISTINCT ON does. > > > > Also, per-key limit is something that a sort-limit physical operator > could > > usefully and efficiently do. > > > > > On Mar 4, 2018, at 8:09 PM, Aman Sinha <amansi...@apache.org> wrote: > > > > > > So far, I haven't had muc

Re: DISTINCT ON clause

, Aman Sinha <amansi...@apache.org> wrote: > I will try to find out more about this during the next few dayswhat do > Oracle, SQL Server, DB2 support. > > On Wed, Feb 21, 2018 at 2:12 PM, Julian Hyde <jh...@apache.org> wrote: > >> Can you do some research,

Re: Google Summer of Code 2018

Good discussion. Some thoughts in no particular priority order: - I think we should also look at the SQL extensions that have been proposed in SQL++ [1] .. for instance the WHERE clause can contain a QuantifiedExpression such as QuantifiedExpression ::= ( (|) | )

Re: DISTINCT ON clause

R BY clause. So > there > >> will be a bizarre interaction if DISTINCT ON is used with UNION and > ORDER > >> BY. > >> > >> By the way, good ol’ MySQL doesn’t have this problem; you can just write > >> > >> SELECT a, b, c FROM t GROUP BY a

Re: DISTINCT ON clause

about MySQL, so let’s not emulate it. :) > > Julian > > > > On Feb 21, 2018, at 12:44 PM, Aman Sinha <amansi...@apache.org> wrote: > > > > The DISTINCT 'ON' clause is not supported but I am trying to see if there > > are other people who have run into this. One

DISTINCT ON clause

The DISTINCT 'ON' clause is not supported but I am trying to see if there are other people who have run into this. One of the use cases I have intuitively maps to something like this: SELECT DISTINCT *ON (a)*, b, c FROM T Here suppose 'a' is an INT and b, c are some complex types such as

Re: Release apache-calcite-1.15.0 (release candidate 0)

appears when the "test" > target finishes, but this time there was a crash, so the directory was > left around. The should not be there. It is empty, so I consider it a > minor cosmetic problem, but we should change our release process so > that it is not there next time. > > O

Re: Release apache-calcite-1.15.0 (release candidate 0)

Downloaded the source tar file on my Linux VM and untarred. I see an empty extraneous directory 'scott.tmp' in the source. It wasn't present in the prior release. Is this expected ? drwxr-xr-x jhyde/jhyde 0 2017-01-20 18:22 apache-calcite-1.15.0-src/ *scott*.tmp/ Other than the source

Re: [ANNOUNCE] New Calcite PMC chair: Michael Mior

Congratulations Michael ! On Wed, Nov 15, 2017 at 12:05 PM, Julian Hyde wrote: > Another year, another peaceful transition of power, another talented chair > with unique skills and perspectives. Well done, Calcite project! > > Jesus, Thank you for your diligence & leadership

Re: Drill query planning error

[Since this is Drill specific, I put dev@calcite on BCC]. If you have two aggregates: Count(distinct a), Count(distinct b), the Calcite logical plan consists of a cartesian join of 2 subqueries each of which first does a group-by on the distinct column followed by a count aggregate. By default,

Re: [VOTE] Release apache-calcite-1.12.0 (release candidate 1)

+1 Downloaded the source tarball to my Linux VM and built, ran unit tests. Encountered 1 failure in PigRelBuilderStyleTest.testImplWithGroupByCountDistinct which is similar to Calcite-1561 but re-running within the suite succeeded, so I am inclined to go with +1. All other tests passed.