Re: Re:Query planner structure

2024-08-14 Thread Stamatis Zampetakis
Hey Mihai, Putting the rules together and building a good query planner is a pretty challenging task. I don't know if there is a perfect solution out there but there are certainly some available planners that you can have a look at. Apache Hive's logical optimizer [1] is built using Calcite and h

Re: [ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread Cancai Cai
Congratulations Norman! > 2024年8月14日 20:23,Alessandro Solimando 写道: > > Congratulations, Norman, very well deserved! > > On Wed, Aug 14, 2024, 13:43 Benchao Li wrote: > >> Congratulations Norman! >> >> Ruben Q L 于2024年8月14日周三 19:15写道: >>> >>> Congratulations Norman!!! >>> >>> >>> On Wed,

[jira] [Created] (CALCITE-6532) Postgres RANDOM() is not flagged as non-deterministic

2024-08-14 Thread Adam Kennedy (Jira)
Adam Kennedy created CALCITE-6532: - Summary: Postgres RANDOM() is not flagged as non-deterministic Key: CALCITE-6532 URL: https://issues.apache.org/jira/browse/CALCITE-6532 Project: Calcite I

Re: Re:Query planner structure

2024-08-14 Thread Mihai Budiu
I have tried this approach, but the decorrelator fails to decorrelate many queries. Here is a simple query where after decorrelation there are still LogicalCorrelate nodes left: SELECT 3 in (SELECT empno FROM emp) Maybe I am missing some optimization steps? >From my reading of the code, the Ca

Re: [ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread Sergey Nuyanzin
Congratulations Norman! On Wed, Aug 14, 2024, 16:49 suibianwanwan wrote: > Congratulations Norman! > > On 2024/08/14 10:07:31 Stamatis Zampetakis wrote: > > Apache Calcite's Project Management Committee (PMC) has invited Norman > Jordan to > > become a committer, and we are pleased to announce t

[jira] [Created] (CALCITE-6531) Correct Javadoc example in SqlStaticAggFunction#constant

2024-08-14 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-6531: -- Summary: Correct Javadoc example in SqlStaticAggFunction#constant Key: CALCITE-6531 URL: https://issues.apache.org/jira/browse/CALCITE-6531 Project: Calcite Issu

RE: [ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread suibianwanwan
Congratulations Norman! On 2024/08/14 10:07:31 Stamatis Zampetakis wrote: > Apache Calcite's Project Management Committee (PMC) has invited Norman Jordan > to > become a committer, and we are pleased to announce that they have accepted. > > Norman has contributed some high quality patches to Cal

[jira] [Created] (CALCITE-6530) HTTP Sessions are never exipred in Avatica server

2024-08-14 Thread Istvan Toth (Jira)
Istvan Toth created CALCITE-6530: Summary: HTTP Sessions are never exipred in Avatica server Key: CALCITE-6530 URL: https://issues.apache.org/jira/browse/CALCITE-6530 Project: Calcite Issue T

Re: [ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread Alessandro Solimando
Congratulations, Norman, very well deserved! On Wed, Aug 14, 2024, 13:43 Benchao Li wrote: > Congratulations Norman! > > Ruben Q L 于2024年8月14日周三 19:15写道: > > > > Congratulations Norman!!! > > > > > > On Wed, Aug 14, 2024 at 12:05 PM Michael Mior wrote: > > > > > Congratulations Norman! > > > -

Re: [ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread Benchao Li
Congratulations Norman! Ruben Q L 于2024年8月14日周三 19:15写道: > > Congratulations Norman!!! > > > On Wed, Aug 14, 2024 at 12:05 PM Michael Mior wrote: > > > Congratulations Norman! > > -- > > Michael Mior > > mm...@apache.org > > > > > > On Wed, Aug 14, 2024 at 6:09 AM Stamatis Zampetakis > > wrote:

Re: [ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread Ruben Q L
Congratulations Norman!!! On Wed, Aug 14, 2024 at 12:05 PM Michael Mior wrote: > Congratulations Norman! > -- > Michael Mior > mm...@apache.org > > > On Wed, Aug 14, 2024 at 6:09 AM Stamatis Zampetakis > wrote: > > > Apache Calcite's Project Management Committee (PMC) has invited Norman > > Jo

Re: [ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread Michael Mior
Congratulations Norman! -- Michael Mior mm...@apache.org On Wed, Aug 14, 2024 at 6:09 AM Stamatis Zampetakis wrote: > Apache Calcite's Project Management Committee (PMC) has invited Norman > Jordan to > become a committer, and we are pleased to announce that they have accepted. > > Norman has c

Re: [ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread Francis Chuang
Congratulations, Norman! On 14/08/2024 8:07 pm, Stamatis Zampetakis wrote: Apache Calcite's Project Management Committee (PMC) has invited Norman Jordan to become a committer, and we are pleased to announce that they have accepted. Norman has contributed some high quality patches to Calcite ove

[jira] [Created] (CALCITE-6529) Use persistent sessionContext in AvaticaCommonsHttpClientImpl

2024-08-14 Thread Istvan Toth (Jira)
Istvan Toth created CALCITE-6529: Summary: Use persistent sessionContext in AvaticaCommonsHttpClientImpl Key: CALCITE-6529 URL: https://issues.apache.org/jira/browse/CALCITE-6529 Project: Calcite

[ANNOUNCE] New committer: Norman Jordan

2024-08-14 Thread Stamatis Zampetakis
Apache Calcite's Project Management Committee (PMC) has invited Norman Jordan to become a committer, and we are pleased to announce that they have accepted. Norman has contributed some high quality patches to Calcite over the past few months bringing many improvements and fixes around Postgres and

[jira] [Created] (CALCITE-6528) JoinUnifyRule may alter semantics in some cases

2024-08-14 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6528: -- Summary: JoinUnifyRule may alter semantics in some cases Key: CALCITE-6528 URL: https://issues.apache.org/jira/browse/CALCITE-6528 Project: Calcite Issue