Re: discussion about the mehtod quoteStringLiteral in SqlDialect.java

[Yanjing Wang]

I have the same doubt, why don't we remove the prepending charset name?

Saurabh Gupta  于2021年6月25日周五 上午9:23写道：

> Hi ,
> The method  quoteStringLiteral(StringBuilder buf, @Nullable String
> charsetName,String val)
>
> Will convert non Ascii characters to UNICODE. Also if charset is specified
> then it would append the charset name after the literal. Can you put some
> light
> on why we are doing this ?
>
> So here we treat literal as default ? Can we change this behaviour?
>

discussion about the mehtod quoteStringLiteral in SqlDialect.java

[Saurabh Gupta]

Hi ,
The method  quoteStringLiteral(StringBuilder buf, @Nullable String
charsetName,String val)

Will convert non Ascii characters to UNICODE. Also if charset is specified
then it would append the charset name after the literal. Can you put some light
on why we are doing this ?

So here we treat literal as default ? Can we change this behaviour?

Re: [ANNOUNCE] New committer: Vladimir Ozerov

[Julian Hyde]

Welcome, Vladimir!

> On Jun 24, 2021, at 6:00 PM, Albert  wrote:
> 
> Congrats.
> just found the blog: https://www.querifylabs.com/author/vladimir-ozerov
> 
> On Thu, Jun 24, 2021 at 2:27 PM Alessandro Solimando <
> alessandro.solima...@gmail.com> wrote:
> 
>> Congratulations Vladimir, well deserved, I had the chance to read some
>> of the blog posts and I have appreciated them very much.
>> 
>> Best regards,
>> Alessandro
>> 
>> On Thu, 24 Jun 2021 at 07:58, Viliam Durina  wrote:
>>> 
>>> Congratulations!
>>> 
>>> Viliam
>>> 
>>> On Thu, 24 Jun 2021 at 06:58, Forward Xu  wrote:
>>> 
 Congratulations!
 
 
 Best，
 
 Forward
 
 Danny Chan  于2021年6月24日周四 上午11:51写道：
 
> Congrats, Vladimir!
> 
> Best,
> Danny Chan
> 
> Yanjing Wang  于2021年6月24日周四 上午11:41写道：
> 
>> Congrats, Vladimir!
>> 
>> Roman Kondakov  于2021年6月24日周四
>> 上午11:22写道：
>> 
>>> Congratulations, Vladimir!
>>> 
>>> Roman Kondakov
>>> 
>>> On 24.06.2021 12:23, 段雄 wrote:
 Congratulations!
 
 XING JIN  于2021年6月24日周四 上午10:21写道：
 
> Congratulations ~
> 
> Best,
> Jin
> 
> guangyuan wang  于2021年6月24日周四
>> 上午9:50写道：
> 
>> Congratulations!
>> 
>> Francis Chuang  于2021年6月24日周四
 上午6:39写道：
>> 
>>> Congrats, Vladimir!
>>> 
>>> Francis
>>> 
>>> On 24/06/2021 7:48 am, Haisheng Yuan wrote:
 Congratulations and thanks for your contributions,
>> Vladimir!
 
 Regards,
 Haisheng
 
 On 2021/06/23 21:34:40, Stamatis Zampetakis <
>> zabe...@gmail.com
> 
> wrote:
> Apache Calcite's Project Management Committee (PMC) has
 invited
>> Vladimir
> Ozerov to
> become a committer, and we are pleased to announce that
>> he has
>> accepted.
> 
> Vladimir is among the few people who know very well the
 internal
>>> workings
> of the
> Calcite optimizer. He started and participated in many
> discussions
>> about
> the core engine and contributed ideas and code for making
>> it
>> better.
> Moreover, Vladimir has blogged and talked about Calcite in
> various
> conferences and meetups giving publicity and showcasing
>> the
>>> capabilities of
> the project.
> 
> Vladimir, 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 more about yourself and what you are working on.
> 
> Stamatis (on behalf of the Apache Calcite PMC)
> 
>>> 
>> 
> 
 
>>> 
>> 
> 
 
>>> 
>>> 
>>> --
>>> Viliam Durina
>>> Jet Developer
>>>  hazelcast®
>>> 
>>>   2 W 5th Ave, Ste 300 | San Mateo, CA
>> 94402 |
>>> USA
>>> +1 (650) 521-5453 | hazelcast.com 
>>> 
>>> --
>>> This message contains confidential information and is intended only for
>> the
>>> individuals named. If you are not the named addressee you should not
>>> disseminate, distribute or copy this e-mail. Please notify the sender
>>> immediately by e-mail if you have received this e-mail by mistake and
>>> delete this e-mail from your system. E-mail transmission cannot be
>>> guaranteed to be secure or error-free as information could be
>> intercepted,
>>> corrupted, lost, destroyed, arrive late or incomplete, or contain
>> viruses.
>>> The sender therefore does not accept liability for any errors or
>> omissions
>>> in the contents of this message, which arise as a result of e-mail
>>> transmission. If verification is required, please request a hard-copy
>>> version. -Hazelcast
>> 
> 
> 
> -- 
> ~~~
> no mistakes
> ~~

Re: [ANNOUNCE] New committer: Vladimir Ozerov

[Albert]

Congrats.
just found the blog: https://www.querifylabs.com/author/vladimir-ozerov

On Thu, Jun 24, 2021 at 2:27 PM Alessandro Solimando <
alessandro.solima...@gmail.com> wrote:

> Congratulations Vladimir, well deserved, I had the chance to read some
> of the blog posts and I have appreciated them very much.
>
> Best regards,
> Alessandro
>
> On Thu, 24 Jun 2021 at 07:58, Viliam Durina  wrote:
> >
> > Congratulations!
> >
> > Viliam
> >
> > On Thu, 24 Jun 2021 at 06:58, Forward Xu  wrote:
> >
> > > Congratulations!
> > >
> > >
> > > Best，
> > >
> > > Forward
> > >
> > > Danny Chan  于2021年6月24日周四 上午11:51写道：
> > >
> > > > Congrats, Vladimir!
> > > >
> > > > Best,
> > > > Danny Chan
> > > >
> > > > Yanjing Wang  于2021年6月24日周四 上午11:41写道：
> > > >
> > > > > Congrats, Vladimir!
> > > > >
> > > > > Roman Kondakov  于2021年6月24日周四
> 上午11:22写道：
> > > > >
> > > > > > Congratulations, Vladimir!
> > > > > >
> > > > > > Roman Kondakov
> > > > > >
> > > > > > On 24.06.2021 12:23, 段雄 wrote:
> > > > > > > Congratulations!
> > > > > > >
> > > > > > > XING JIN  于2021年6月24日周四 上午10:21写道：
> > > > > > >
> > > > > > >> Congratulations ~
> > > > > > >>
> > > > > > >> Best,
> > > > > > >> Jin
> > > > > > >>
> > > > > > >> guangyuan wang  于2021年6月24日周四
> 上午9:50写道：
> > > > > > >>
> > > > > > >>> Congratulations!
> > > > > > >>>
> > > > > > >>> Francis Chuang  于2021年6月24日周四
> > > 上午6:39写道：
> > > > > > >>>
> > > > > >  Congrats, Vladimir!
> > > > > > 
> > > > > >  Francis
> > > > > > 
> > > > > >  On 24/06/2021 7:48 am, Haisheng Yuan wrote:
> > > > > > > Congratulations and thanks for your contributions,
> Vladimir!
> > > > > > >
> > > > > > > Regards,
> > > > > > > Haisheng
> > > > > > >
> > > > > > > On 2021/06/23 21:34:40, Stamatis Zampetakis <
> zabe...@gmail.com
> > > >
> > > > > > >> wrote:
> > > > > > >> Apache Calcite's Project Management Committee (PMC) has
> > > invited
> > > > > > >>> Vladimir
> > > > > > >> Ozerov to
> > > > > > >> become a committer, and we are pleased to announce that
> he has
> > > > > > >>> accepted.
> > > > > > >>
> > > > > > >> Vladimir is among the few people who know very well the
> > > internal
> > > > > >  workings
> > > > > > >> of the
> > > > > > >> Calcite optimizer. He started and participated in many
> > > > discussions
> > > > > > >>> about
> > > > > > >> the core engine and contributed ideas and code for making
> it
> > > > > better.
> > > > > > >> Moreover, Vladimir has blogged and talked about Calcite in
> > > > various
> > > > > > >> conferences and meetups giving publicity and showcasing
> the
> > > > > >  capabilities of
> > > > > > >> the project.
> > > > > > >>
> > > > > > >> Vladimir, 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 more about yourself and what you are working on.
> > > > > > >>
> > > > > > >> Stamatis (on behalf of the Apache Calcite PMC)
> > > > > > >>
> > > > > > 
> > > > > > >>>
> > > > > > >>
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> >
> > --
> > Viliam Durina
> > Jet Developer
> >   hazelcast®
> >
> >    2 W 5th Ave, Ste 300 | San Mateo, CA
> 94402 |
> > USA
> > +1 (650) 521-5453 | hazelcast.com 
> >
> > --
> > This message contains confidential information and is intended only for
> the
> > individuals named. If you are not the named addressee you should not
> > disseminate, distribute or copy this e-mail. Please notify the sender
> > immediately by e-mail if you have received this e-mail by mistake and
> > delete this e-mail from your system. E-mail transmission cannot be
> > guaranteed to be secure or error-free as information could be
> intercepted,
> > corrupted, lost, destroyed, arrive late or incomplete, or contain
> viruses.
> > The sender therefore does not accept liability for any errors or
> omissions
> > in the contents of this message, which arise as a result of e-mail
> > transmission. If verification is required, please request a hard-copy
> > version. -Hazelcast
>


-- 
~~~
no mistakes
~~

[jira] [Created] (CALCITE-4666) Implement PERCENTILE_CONT and PERCENTILE_DISC as logical rewrites

[Rafay A (Jira)]

Rafay A created CALCITE-4666:


 Summary: Implement PERCENTILE_CONT and PERCENTILE_DISC as logical 
rewrites
 Key: CALCITE-4666
 URL: https://issues.apache.org/jira/browse/CALCITE-4666
 Project: Calcite
  Issue Type: New Feature
  Components: core
Reporter: Rafay A


We plan to implement percentile functions as logical rewrites to use window 
functions and/or aggregations and joins.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Re: [Question] Obtaining aliases for group columns in aggregate (especially after AGGREGATE_PROJECT_MERGE)

[Stamatis Zampetakis]

Hi Ishan,

Why do you need to do logical -> physical -> logical transformation?

Regarding aliases, there is no guarantee that they will be retained.
There are various places where there is some effort to keep them intact but
your code shouldn't rely on this.

Best,
Stamatis

On Tue, Jun 15, 2021 at 4:37 AM Sharma, Ishan 
wrote:

> Hi folks,
> There exists an API to get the column name for the aggregate column (
> *getNamedAggCalls*), I can't seem to find a similar API for group columns,
> is there a way to obtain the same in *LogicalAggregate*?
>
> Currently, I am optimizing the logical plan into a physical plan (in
> bindable convention) and then converting it back to a plan with logical
> nodes via *ToLogicalConverter. *As a consequence of
> *AGGREGATE_PROJECT_MERGE* rule, the project gets removed and hence
> information about the column aliases for the group columns in aggregate
> does not seem to be available. I guess I am missing something minor.
>
> Thanks,
> Ishan
>

Re: [ANNOUNCE] New committer: Vladimir Ozerov

[Alessandro Solimando]

Congratulations Vladimir, well deserved, I had the chance to read some
of the blog posts and I have appreciated them very much.

Best regards,
Alessandro

On Thu, 24 Jun 2021 at 07:58, Viliam Durina  wrote:
>
> Congratulations!
>
> Viliam
>
> On Thu, 24 Jun 2021 at 06:58, Forward Xu  wrote:
>
> > Congratulations!
> >
> >
> > Best，
> >
> > Forward
> >
> > Danny Chan  于2021年6月24日周四 上午11:51写道：
> >
> > > Congrats, Vladimir!
> > >
> > > Best,
> > > Danny Chan
> > >
> > > Yanjing Wang  于2021年6月24日周四 上午11:41写道：
> > >
> > > > Congrats, Vladimir!
> > > >
> > > > Roman Kondakov  于2021年6月24日周四 上午11:22写道：
> > > >
> > > > > Congratulations, Vladimir!
> > > > >
> > > > > Roman Kondakov
> > > > >
> > > > > On 24.06.2021 12:23, 段雄 wrote:
> > > > > > Congratulations!
> > > > > >
> > > > > > XING JIN  于2021年6月24日周四 上午10:21写道：
> > > > > >
> > > > > >> Congratulations ~
> > > > > >>
> > > > > >> Best,
> > > > > >> Jin
> > > > > >>
> > > > > >> guangyuan wang  于2021年6月24日周四 上午9:50写道：
> > > > > >>
> > > > > >>> Congratulations!
> > > > > >>>
> > > > > >>> Francis Chuang  于2021年6月24日周四
> > 上午6:39写道：
> > > > > >>>
> > > > >  Congrats, Vladimir!
> > > > > 
> > > > >  Francis
> > > > > 
> > > > >  On 24/06/2021 7:48 am, Haisheng Yuan wrote:
> > > > > > Congratulations and thanks for your contributions, Vladimir!
> > > > > >
> > > > > > Regards,
> > > > > > Haisheng
> > > > > >
> > > > > > On 2021/06/23 21:34:40, Stamatis Zampetakis  > >
> > > > > >> wrote:
> > > > > >> Apache Calcite's Project Management Committee (PMC) has
> > invited
> > > > > >>> Vladimir
> > > > > >> Ozerov to
> > > > > >> become a committer, and we are pleased to announce that he has
> > > > > >>> accepted.
> > > > > >>
> > > > > >> Vladimir is among the few people who know very well the
> > internal
> > > > >  workings
> > > > > >> of the
> > > > > >> Calcite optimizer. He started and participated in many
> > > discussions
> > > > > >>> about
> > > > > >> the core engine and contributed ideas and code for making it
> > > > better.
> > > > > >> Moreover, Vladimir has blogged and talked about Calcite in
> > > various
> > > > > >> conferences and meetups giving publicity and showcasing the
> > > > >  capabilities of
> > > > > >> the project.
> > > > > >>
> > > > > >> Vladimir, 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 more about yourself and what you are working on.
> > > > > >>
> > > > > >> Stamatis (on behalf of the Apache Calcite PMC)
> > > > > >>
> > > > > 
> > > > > >>>
> > > > > >>
> > > > > >
> > > > >
> > > >
> > >
> >
>
>
> --
> Viliam Durina
> Jet Developer
>   hazelcast®
>
>    2 W 5th Ave, Ste 300 | San Mateo, CA 94402 |
> USA
> +1 (650) 521-5453 | hazelcast.com 
>
> --
> This message contains confidential information and is intended only for the
> individuals named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and
> delete this e-mail from your system. E-mail transmission cannot be
> guaranteed to be secure or error-free as information could be intercepted,
> corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.
> The sender therefore does not accept liability for any errors or omissions
> in the contents of this message, which arise as a result of e-mail
> transmission. If verification is required, please request a hard-copy
> version. -Hazelcast