Re: [DISCUSS] Towards Calcite 1.33.0

2023-02-07 Thread Stamatis Zampetakis
Strange error; did you run the publishDist task more than once? Other than that, I see the release was propagated to the mirrors[1] so I don't think there is anything else pending apart from the remaining steps (announcements etc.). Best, Stamatis [1] https://dlcdn.apache.org/calcite/apache-calc

Re: [DISCUSS] Towards Calcite 1.33.0

2023-02-07 Thread Jess Balint
I ran it more than once because it failed the first time. I didn't realize there might be side effects. Thanks for the confirmation. I'll setup the announcement. On Tue, Feb 7, 2023 at 7:56 AM Stamatis Zampetakis wrote: > Strange error; did you run the publishDist task more than once? > > Other

Re: [DISCUSS] Towards Calcite 1.33.0

2023-02-07 Thread Julian Hyde
Jess, Please let us know when main is open. > On Feb 7, 2023, at 8:59 AM, Jess Balint wrote: > > I ran it more than once because it failed the first time. I didn't realize > there might be side effects. Thanks for the confirmation. I'll setup the > announcement. > > On Tue, Feb 7, 2023 at 7:56

RE: [DISCUSS] Apache Calcite Meetup March 2023

2023-02-07 Thread Mihai Budiu
Hello, I would like to propose the following presentation for a meetup. Thank you, Mihai Budiu - Building a streaming incremental view maintenance engine with Calcite Speaker: Mihai Budiu - VMware Research Duration: 20-40 minutes The DBSP open-source project (https://github.c

Re: [DISCUSS] Towards Calcite 1.33.0

2023-02-07 Thread Jess Balint
Can a PMC member please set the release date? r59936 at 2023-02-06 21:29:21 + (Mon, 06 Feb 2023) Promoting Apache Calcite calcite-1.33.0-rc0 -> calcite-1.33.0 to release area If you are a PMC member of this project, we ask that you log on to: https://reporter.apache.org/addrelease.html?calcit

Re: [DISCUSS] Towards Calcite 1.33.0

2023-02-07 Thread Julian Hyde
Happy to do that. What’s the release date? We have only ~4 hours left of 2023-02-07 UTC. > On Feb 7, 2023, at 11:27 AM, Jess Balint wrote: > > Can a PMC member please set the release date? > > r59936 at 2023-02-06 21:29:21 + (Mon, 06 Feb 2023) > Promoting Apache Calcite calcite-1.33.0-rc0

Re: [DISCUSS] Towards Calcite 1.33.0

2023-02-07 Thread Jess Balint
I thought it would be the svn commit date mentioned above (2023-02-06). Otherwise today works. I'm working on the site updates. On Tue, Feb 7, 2023 at 1:32 PM Julian Hyde wrote: > Happy to do that. > > What’s the release date? We have only ~4 hours left of 2023-02-07 UTC. > > > On Feb 7, 2023, a

Re: [DISCUSS] Towards Calcite 1.33.0

2023-02-07 Thread Julian Hyde
The date can be whatever you decide as release manager. It’s important that the date in the news item matches, because the downloads page is generated from that. Back in the day I had trouble generating the site when local date <> UTC date, or when the news item date was in the future. When I s

Re: [DISCUSS] Apache Calcite Meetup March 2023

2023-02-07 Thread Julian Hyde
That would be very interesting. (I see Frank McSherry among your co-authors and everything Frank does is very interesting.) > On Feb 7, 2023, at 11:13 AM, Mihai Budiu wrote: > > Hello, > > I would like to propose the following presentation for a meetup. > > Thank you, > Mihai Budiu > >

RE: Re: Why does timestamp diff return a value inconsistent with the time unit?

2023-02-07 Thread Ian Bertolacci
Hm. Is what I am seeing then the effect of Avatica/JDBC ? Another piece of this is that the result differs when using TIMESTAMPDIFF/TIMESTAMPADD, which gives the correct integer value for that time unit. I mention this because the Calcite docs claim that TIMESTAMPDIFF and TIMESTAMPADD are equiv

Re: Why does timestamp diff return a value inconsistent with the time unit?

2023-02-07 Thread Julian Hyde
Maybe JDBC is involved. Remember SQLLine uses JDBC too. Maybe SQLLine calls getString and you are calling getInt. I don’t know. Regarding the behavior of TIMESTAMPDIFF when the timestamps cross unit boundaries. There was some discussion of this in one of the Jira cases to add support for BigQue

Re: Declaring monotonic columns in schema for streaming queries.

2023-02-07 Thread Vignesh
Hi, To do this, I will need to define an implementation of CalciteCatalogReader, override the getTable method and return an implementation of PreparingTable that returns the right thing for getMonotonicity

[ANNOUNCE] Apache Calcite 1.33.0 released

2023-02-07 Thread Jess Balint
The Apache Calcite team is pleased to announce the release of Apache Calcite 1.33.0. Calcite is a dynamic data management framework. Its cost-based optimizer converts queries, represented in relational algebra, into executable plans. Calcite supports many front-end languages and back-end data engi

Re: [DISCUSS] Towards Calcite 1.33.0

2023-02-07 Thread Jess Balint
Release is complete and main branch is open for commits! Thanks for your patience. On Tue, Feb 7, 2023 at 1:42 PM Julian Hyde wrote: > The date can be whatever you decide as release manager. It’s important > that the date in the news item matches, because the downloads page is > generated from t

[jira] [Created] (CALCITE-5517) Nested (correlated) subqueries fail at validation | No SELECT scope for inner subquery

2023-02-07 Thread Zine eddine Zidane (Jira)
Zine eddine Zidane created CALCITE-5517: --- Summary: Nested (correlated) subqueries fail at validation | No SELECT scope for inner subquery Key: CALCITE-5517 URL: https://issues.apache.org/jira/browse/CALCITE-

Re: Volcano Planner Issue

2023-02-07 Thread Benchao Li
Hi Suchit, FYI, I've reproduced the problem with your example, however, I cannot tell the reason for now, it may take a while. I would be great if someone else who's interested with the problem could also take a look at it. Suchit Kumar 于2023年2月7日周二 11:17写道: > Hi, > > I have attached 4 files y

Re: Volcano Planner Issue

2023-02-07 Thread Suchit Kumar
Hi, Thanks for your reply could you guide me if there is any way I can execute my query without an optimizer? I am not sure whom I can reach can you tell me any channel where I can post this issue? Thanks, Suchit Kumar On Wed, Feb 8, 2023 at 7:57 AM Benchao Li wrote: > Hi Suchit, > > FYI, I'

Re: Declaring monotonic columns in schema for streaming queries.

2023-02-07 Thread Benchao Li
Yes, I think you are in the right direction. Vignesh 于2023年2月8日周三 05:31写道: > Hi, > > To do this, I will need to define an implementation of > CalciteCatalogReader, override the getTable method and return an > implementation of PreparingTable that returns the right thing for > getMonotonicity > <