Re: [ANNOUNCE] New committer: Dmitry Sysolyatin

2022-11-09 Thread 徐仁和
Congratulations, Dmitry!

Xin Wang  于2022年11月10日周四 09:46写道:

> Congrats Dmitry!
>
> xiong duan  于2022年11月10日周四 09:26写道:
>
> > 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 become a committer, and we are pleased to announce he
> has
> > > > accepted the invitation.
> > > >
> > > > During the last months Dmitry has pushed a lot of high quality
> patches,
> > > > fixing and improving code around several places in Calcite core.
> Apart
> > > from
> > > > code contributions, he has been regularly involved in discussions
> > > regarding
> > > > multiple topics in the mailing list, always with a hardworking and
> > > > courteous spirit.
> > > >
> > > > Dmitry, welcome, thank you for your contributions, and we look
> forward
> > to
> > > > your further interactions with the community! If you wish, please
> feel
> > > free
> > > > to tell us a bit more about yourself and what you are currently
> working
> > > on.
> > > > As your first commit, you can add yourself to the contributors list
> [1]
> > > and
> > > > the community page will re-generate [2].
> > > >
> > > > Ruben (on behalf of the Apache Calcite PMC)
> > > >
> > > > [1]
> > > >
> > https://github.com/apache/calcite/blob/main/site/_data/contributors.yml
> > > > [2] https://calcite.apache.org/community/#project-members
> > > >
> > >
> >
>
>
> --
> Thanks,
> Xin
>


Re: [ANNOUNCE] New committer: Dmitry Sysolyatin

2022-11-09 Thread Xin Wang
Congrats Dmitry!

xiong duan  于2022年11月10日周四 09:26写道:

> 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 become a committer, and we are pleased to announce he has
> > > accepted the invitation.
> > >
> > > During the last months Dmitry has pushed a lot of high quality patches,
> > > fixing and improving code around several places in Calcite core. Apart
> > from
> > > code contributions, he has been regularly involved in discussions
> > regarding
> > > multiple topics in the mailing list, always with a hardworking and
> > > courteous spirit.
> > >
> > > Dmitry, welcome, thank you for your contributions, and we look forward
> to
> > > your further interactions with the community! If you wish, please feel
> > free
> > > to tell us a bit more about yourself and what you are currently working
> > on.
> > > As your first commit, you can add yourself to the contributors list [1]
> > and
> > > the community page will re-generate [2].
> > >
> > > Ruben (on behalf of the Apache Calcite PMC)
> > >
> > > [1]
> > >
> https://github.com/apache/calcite/blob/main/site/_data/contributors.yml
> > > [2] https://calcite.apache.org/community/#project-members
> > >
> >
>


-- 
Thanks,
Xin


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 become a committer, and we are pleased to announce he has
> > accepted the invitation.
> >
> > During the last months Dmitry has pushed a lot of high quality patches,
> > fixing and improving code around several places in Calcite core. Apart
> from
> > code contributions, he has been regularly involved in discussions
> regarding
> > multiple topics in the mailing list, always with a hardworking and
> > courteous spirit.
> >
> > Dmitry, welcome, thank you for your contributions, and we look forward to
> > your further interactions with the community! If you wish, please feel
> free
> > to tell us a bit more about yourself and what you are currently working
> on.
> > As your first commit, you can add yourself to the contributors list [1]
> and
> > the community page will re-generate [2].
> >
> > Ruben (on behalf of the Apache Calcite PMC)
> >
> > [1]
> > https://github.com/apache/calcite/blob/main/site/_data/contributors.yml
> > [2] https://calcite.apache.org/community/#project-members
> >
>


MEASURE type and AGGREGATE aggregate function

2022-11-09 Thread Julian Hyde
Can I get a review for https://github.com/apache/calcite/pull/2965 /
https://issues.apache.org/jira/browse/CALCITE-5105?

It's the first change in what is - in my opinion - a major extension
to SQL, namely being able to define expressions in queries and views
and have those expressions 'expand' in the context where they are
used. It's something that BI tools and multidimensional databases do,
but it is not allowed by the conventional rules of SQL.

This change is fairly modest, adding a MEASURE type so that we can
represent measures internally. I believe that I have added sufficient
switches so that people who don't want these extensions in their SQL
dialect don't get them.

A later case, https://issues.apache.org/jira/browse/CALCITE-4496, will
allow you to define measures as part of a query and have them inlined
when you use them in an enclosing query. That case is quite a long way
from completion.

Julian


[DISCUSS] State of the project 2022

2022-11-09 Thread Ruben Q L
Hello community,

A bit more than seven years ago (22 October 2015) Calcite graduated as a
top-level Apache project [1]. At that point, the community decided to have
an annual “state of the project” discussion, and we have arrived to that
time of the year.

We have had three Calcite releases so far in 2022 [2] (many thanks to each
Release Manager), with probably one more coming before the end of the year.
We have seen great evolutions such as new spatial functions, polymorphic
table functions, Firebolt dialect, parsing parenthesized joins (kudos to
Julian Hyde for dealing with this very old issue), improvements on SQL
hints, and many more.

Regarding the sub-project Avatica, we have seen two releases this year, and
two more releases for Avatica Go [3] (special thanks to Francis Chuang for
being the Release Manager for all of them). These were all basically
maintenance releases. It is clear that Avatica has fewer users,
contributors and evolutions than Calcite. More of them will be very
welcome, although I am not sure about how we could promote it.

We have also faced several vulnerabilities for both Calcite and Avatica
during the last year, including the famous log4j issues, and we were able
to deal with them in a swiftly and collaboratively manner.

In terms of community, I think this has been a great year. Calcite
continues to increase steadily its contributors. We see more and more
people participating in email discussions, Jira tickets and Github PRs. Our
list of committers has grown with Jing Zhang, Benchao Li, Bertil Chapuis
and Dmitry Sysolyatin; and so has our PMC with Chunwei Lei, Vladimir Ozerov
and Andrei Sereda. Calcite grows and evolves because of (and thanks to) its
community, so I would like to thank everyone for being part of this family
and working together in a respectful and motivating environment.

We started the year with an online meetup, which was a great opportunity
for the community to virtually meet and share some interesting
presentations. Perhaps we could begin the discussions to try to organize
another one in the near future (beginning of 2023?), in order to try to
hold at least one every year.

In a less positive aspect, it is probably worth mentioning that we continue
to struggle on PR reviewing. Our pull-requests list continues to increase
and frequently it is hard to have people reviewing / merging them, and this
can be frustrating for non-committers. This is an old problem of our
project. We have tried several things to improve it (like metrics and
credit on our quarterly reports; or sporadic "reviewing campaigns",
especially before a release). Any ideas on improving this situation will be
highly appreciated.

To conclude, I will repeat the questions from previous years:
1) What else are we doing well in the project?
2) What areas do we need to do better?

Please take some time to share your thoughts!
Note that this discussion is for everyone, not only for committers / PMC
members; even if you have never sent an email to the dev list before, now
it is a good time to do so :)

Finally, it has been a privilege to serve as Calcite's PMC Chair this year.
I have learnt a lot and I am very grateful for the opportunity that I was
given. Following our yearly rotation tradition, I will step down as Chair
by the end of the year, and a new one will have to be chosen. As we
discussed some time ago [4], if you have any suggestion and you would like
to put someone forward as a potential next Chair, please send an email to
priv...@calcite.apache.org (the PMC will study all proposals, discuss and
vote).

Best regards,
Ruben

[1] http://calcite.apache.org/news/2015/10/22/calcite-graduates/
[2] https://calcite.apache.org/news/
[3] https://calcite.apache.org/avatica/news/
[4] https://lists.apache.org/thread/gplfqs4snr1b6h62cngyvb65sz41z3fk


Re: [ANNOUNCE] New committer: Dmitry Sysolyatin

2022-11-09 Thread Michael Mior
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 become a committer, and we are pleased to announce he has
> accepted the invitation.
>
> During the last months Dmitry has pushed a lot of high quality patches,
> fixing and improving code around several places in Calcite core. Apart from
> code contributions, he has been regularly involved in discussions regarding
> multiple topics in the mailing list, always with a hardworking and
> courteous spirit.
>
> Dmitry, welcome, thank you for your contributions, and we look forward to
> your further interactions with the community! If you wish, please feel free
> to tell us a bit more about yourself and what you are currently working on.
> As your first commit, you can add yourself to the contributors list [1] and
> the community page will re-generate [2].
>
> Ruben (on behalf of the Apache Calcite PMC)
>
> [1]
> https://github.com/apache/calcite/blob/main/site/_data/contributors.yml
> [2] https://calcite.apache.org/community/#project-members
>


Re: [ANNOUNCE] New committer: Dmitry Sysolyatin

2022-11-09 Thread Jiajun Xie
Congratulations, Dimitry! Your work looks great

On Wed, 9 Nov 2022 at 18:39, Dmitry Sysolyatin 
wrote:

> Hi!
> Thanks everyone for your kind words. I'm honored to be a part of the
> calcite community.
>
> Few words about myself. I'm currently working at Intertrust Technologies
> [1] company. The company has a lot of projects. Currently, I'm working on
> Intertrust Platform [2] which is an ecosystem to securely and efficiently
> manage distributed data.
>
> Besides work, I'm interested in random graphs and application of it in
> systems simulating.
>
> [1] https://www.intertrust.com/
> [2] https://www.intertrust.com/platform/
>
> On Wed, Nov 9, 2022 at 2:57 AM Benchao Li  wrote:
> >
> > Congratulations, Dimitry! Looking forward to further interactions with
> you.
> >
> > Bertil Chapuis  于2022年11月9日周三 06:23写道:
> >
> > > Congratulations, Dimitry!
> > >
> > > Bertil
> > >
> > > > On 8 Nov 2022, at 23:08, Andrei Sereda  wrote:
> > > >
> > > > Congratulations!
> > > >
> > > > On Tue, Nov 8, 2022, 16:08 Francis Chuang 
> > > wrote:
> > > >
> > > >> Congratulations, Dmitry!
> > > >>
> > > >> Francis
> > > >>
> > > >> On 9/11/2022 6:13 am, Julian Hyde wrote:
> > > >>> Congratulations, Dmitry! Thanks for the great work you’ve already
> done
> > > >> for the project.
> > > >>>
> > > >>> Julian
> > > >>>
> > > >>>
> > >  On Nov 8, 2022, at 10:56 AM, Alessandro Solimando <
> > > >> alessandro.solima...@gmail.com> wrote:
> > > 
> > >  Congrats Dmitry, welcome to Calcite!
> > > 
> > >  On Tue 8 Nov 2022, 18:44 Ruben Q L,  wrote:
> > > 
> > > > Apache Calcite's Project Management Committee (PMC) has invited
> > > Dmitry
> > > > Sysolyatin to become a committer, and we are pleased to announce
> he
> > > has
> > > > accepted the invitation.
> > > >
> > > > During the last months Dmitry has pushed a lot of high quality
> > > patches,
> > > > fixing and improving code around several places in Calcite core.
> > > Apart
> > > >> from
> > > > code contributions, he has been regularly involved in discussions
> > > >> regarding
> > > > multiple topics in the mailing list, always with a hardworking
> and
> > > > courteous spirit.
> > > >
> > > > Dmitry, welcome, thank you for your contributions, and we look
> > > forward
> > > >> to
> > > > your further interactions with the community! If you wish, please
> > > feel
> > > >> free
> > > > to tell us a bit more about yourself and what you are currently
> > > >> working on.
> > > > As your first commit, you can add yourself to the contributors
> list
> > > >> [1] and
> > > > the community page will re-generate [2].
> > > >
> > > > Ruben (on behalf of the Apache Calcite PMC)
> > > >
> > > > [1]
> > > >
> > > >>
> https://github.com/apache/calcite/blob/main/site/_data/contributors.yml
> > > > [2] https://calcite.apache.org/community/#project-members
> > > >
> > > >>>
> > > >>
> > >
> > >
> >
> > --
> >
> > Best,
> > Benchao Li
>


[jira] [Created] (CALCITE-5374) Upgrade jackson version to 2.14.0

2022-11-09 Thread Sergey Nuyanzin (Jira)
Sergey Nuyanzin created CALCITE-5374:


 Summary: Upgrade jackson version to 2.14.0
 Key: CALCITE-5374
 URL: https://issues.apache.org/jira/browse/CALCITE-5374
 Project: Calcite
  Issue Type: Improvement
  Components: avatica
Reporter: Sergey Nuyanzin


Seems I forgot to make similar update for avatica.

At the same time a newer version 2.14.0 is already available



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (CALCITE-5373) Upgrade bouncycastle version to 1.70

2022-11-09 Thread Sergey Nuyanzin (Jira)
Sergey Nuyanzin created CALCITE-5373:


 Summary: Upgrade bouncycastle version to 1.70
 Key: CALCITE-5373
 URL: https://issues.apache.org/jira/browse/CALCITE-5373
 Project: Calcite
  Issue Type: Improvement
  Components: avatica
Reporter: Sergey Nuyanzin


It was not updated for a while and current version has a CVE 
https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-15522



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


Re: [ANNOUNCE] New committer: Dmitry Sysolyatin

2022-11-09 Thread Dmitry Sysolyatin
Hi!
Thanks everyone for your kind words. I'm honored to be a part of the
calcite community.

Few words about myself. I'm currently working at Intertrust Technologies
[1] company. The company has a lot of projects. Currently, I'm working on
Intertrust Platform [2] which is an ecosystem to securely and efficiently
manage distributed data.

Besides work, I'm interested in random graphs and application of it in
systems simulating.

[1] https://www.intertrust.com/
[2] https://www.intertrust.com/platform/

On Wed, Nov 9, 2022 at 2:57 AM Benchao Li  wrote:
>
> Congratulations, Dimitry! Looking forward to further interactions with
you.
>
> Bertil Chapuis  于2022年11月9日周三 06:23写道:
>
> > Congratulations, Dimitry!
> >
> > Bertil
> >
> > > On 8 Nov 2022, at 23:08, Andrei Sereda  wrote:
> > >
> > > Congratulations!
> > >
> > > On Tue, Nov 8, 2022, 16:08 Francis Chuang 
> > wrote:
> > >
> > >> Congratulations, Dmitry!
> > >>
> > >> Francis
> > >>
> > >> On 9/11/2022 6:13 am, Julian Hyde wrote:
> > >>> Congratulations, Dmitry! Thanks for the great work you’ve already
done
> > >> for the project.
> > >>>
> > >>> Julian
> > >>>
> > >>>
> >  On Nov 8, 2022, at 10:56 AM, Alessandro Solimando <
> > >> alessandro.solima...@gmail.com> wrote:
> > 
> >  Congrats Dmitry, welcome to Calcite!
> > 
> >  On Tue 8 Nov 2022, 18:44 Ruben Q L,  wrote:
> > 
> > > Apache Calcite's Project Management Committee (PMC) has invited
> > Dmitry
> > > Sysolyatin to become a committer, and we are pleased to announce
he
> > has
> > > accepted the invitation.
> > >
> > > During the last months Dmitry has pushed a lot of high quality
> > patches,
> > > fixing and improving code around several places in Calcite core.
> > Apart
> > >> from
> > > code contributions, he has been regularly involved in discussions
> > >> regarding
> > > multiple topics in the mailing list, always with a hardworking and
> > > courteous spirit.
> > >
> > > Dmitry, welcome, thank you for your contributions, and we look
> > forward
> > >> to
> > > your further interactions with the community! If you wish, please
> > feel
> > >> free
> > > to tell us a bit more about yourself and what you are currently
> > >> working on.
> > > As your first commit, you can add yourself to the contributors
list
> > >> [1] and
> > > the community page will re-generate [2].
> > >
> > > Ruben (on behalf of the Apache Calcite PMC)
> > >
> > > [1]
> > >
> > >>
https://github.com/apache/calcite/blob/main/site/_data/contributors.yml
> > > [2] https://calcite.apache.org/community/#project-members
> > >
> > >>>
> > >>
> >
> >
>
> --
>
> Best,
> Benchao Li


Jenkins build is back to normal : Calcite » Calcite-snapshots #271

2022-11-09 Thread Apache Jenkins Server
See