[jira] [Created] (CALCITE-4606) Test case "countStar" throws exception in AggregationTest of elastic-search adapter

2021-05-13 Thread Jacky Yin (Jira)
Jacky Yin created CALCITE-4606: -- Summary: Test case "countStar" throws exception in AggregationTest of elastic-search adapter Key: CALCITE-4606 URL: https://issues.apache.org/jira/browse/CALCITE-4606 Pro

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

2021-05-13 Thread Vladimir Sitnikov
Francis, Thanks for preparing the release. My vote is [x] -1 Do not release this package because... 1) apache-calcite-avatica-1.18.0-src.tar.gz contains compiled code, and it is forbidden to release compiled code in source packages. site/js/html5shiv.min.js site/js/respond.min.js 2) apache-cal

Using Calcite as a Distributed Optimizer

2021-05-13 Thread Atri Sharma
Hi All, Are there examples of using Calcite to compile and optimize queries to be run on a set of nodes, and then merge partial results back? Atri -- Regards, Atri l'apprenant

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

2021-05-13 Thread Francis Chuang
Hey Vladimir, Thanks for taking the time to look at the release. For 1), the discussion in LEGAL-570 [1], suggests that images, PDFs and minified javascript is allowed in the source distribution as they are classified as resources and not code. I am not a Java programmer, but I can definitely

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

2021-05-13 Thread Vladimir Sitnikov
>I can definitely see the utility of the gradle wrapper and was pretty >disappointed that it had to be removed It would be great if you add a comment to 570 on how the wrapper was useful for you. So far the case sounds like "compiled code is forbidden no matter what" and "Vladimir is the only one

Materialization of nested queries

2021-05-13 Thread Scott Fines
Hi all, I’m hoping this question is super easy, but I’m running into a bit of a roadblock while researching Calcite, and thought maybe someone on here might be interested. So imagine that you have a fairly simple nested data structure, like TableName struct { a int, b struct {

Re: Proposal to extend Calcite into a incremental query optimizer

2021-05-13 Thread Rui Wang
I apologize that I had a wrong impression on the meeting time (I thought it should be on Thursday but it is Wednesday). I can follow up your meeting records if you have any. -Rui On Tue, May 11, 2021 at 8:17 PM Botong Huang wrote: > Hi all, > > This is a reminder that we are going to have our

Re: Using Calcite as a Distributed Optimizer

2021-05-13 Thread Atri Sharma
Sorry, didn't realize I had sent to the dev list. I will send to the user list On Thu, 13 May 2021, 15:57 Atri Sharma, wrote: > Hi All, > > Are there examples of using Calcite to compile and optimize queries to > be run on a set of nodes, and then merge partial results back? > > Atri > > -- > Re

Re: Proposal to extend Calcite into a incremental query optimizer

2021-05-13 Thread Julian Hyde
During the meeting we agreed to start progressing this contribution in the usual Apache Way, with conversations on the dev list and in the https://issues.apache.org/jira/browse/CALCITE-4568 JIRA case. So, it should be easy for you to particip

Re: Using Calcite as a Distributed Optimizer

2021-05-13 Thread Julian Hyde
Calcite has no user@ list. So, ask away here! > On May 13, 2021, at 10:52 AM, Atri Sharma wrote: > > Sorry, didn't realize I had sent to the dev list. I will send to the user > list > > On Thu, 13 May 2021, 15:57 Atri Sharma, wrote: > >> Hi All, >> >> Are there examples of using Calcite to

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

2021-05-13 Thread Julian Hyde
Let’s not have a discussion on the vote thread. Feel free to start a new thread, or continue an existing discussion thread. To re-state the rules. Every PMC member has a binding vote. The vote passes if the number of +1 votes exceeds the number of -1 votes by 3 or more. Vladimir is entitled to

Re: Proposal to extend Calcite into a incremental query optimizer

2021-05-13 Thread Rui Wang
Thanks Julian for the sharing! Overall sounds reasonable! >Our side of the bargain, as committers, is that we should review in a timely manner, and not move the goal posts Huge +1. I will be very happy to help during this process. On Thu, May 13, 2021 at 12:47 PM Julian Hyde wrote: > During the

Re: Using Calcite as a Distributed Optimizer

2021-05-13 Thread Atri Sharma
Thank you. So my use case is such that I wish to use Calcite as a two phase optimizer -- Get a SQL query, compile it and optimize it and convert it to a SQL fragment. Then run the query on worker nodes, get results on master and merge results. This question spans both Calcite and Avatica, but I

Re: Using Calcite as a Distributed Optimizer

2021-05-13 Thread Haisheng Yuan
Yes, definitely. Many distributed big data systems use Apache Calcite to optimize queries and generate distributed plans. On 2021/05/13 23:16:10, Atri Sharma wrote: > Thank you. > > So my use case is such that I wish to use Calcite as a two phase optimizer > -- Get a SQL query, compile it and

Re: Using Calcite as a Distributed Optimizer

2021-05-13 Thread Atri Sharma
Is there an example I can refer to? On Fri, 14 May 2021, 04:59 Haisheng Yuan, wrote: > Yes, definitely. Many distributed big data systems use Apache Calcite to > optimize queries and generate distributed plans. > > On 2021/05/13 23:16:10, Atri Sharma wrote: > > Thank you. > > > > So my use case

Re: Using Calcite as a Distributed Optimizer

2021-05-13 Thread Fan Liya
I think you can refer to Flink Best, Liya Fan On Fri, May 14, 2021 at 12:32 PM Atri Sharma wrote: > Is there an example I can refer to? > > On Fri, 14 May 2021, 04:59 Haisheng Yuan, wrote: > > > Yes, definitely. Many distributed big data systems use Apache Calcite to > > optimize queries and g

Re: Proposal to extend Calcite into a incremental query optimizer

2021-05-13 Thread Albert
Thanks for sharing 在 2021年5月14日星期五,Julian Hyde 写道: > During the meeting we agreed to start progressing this contribution in the > usual Apache Way, with conversations on the dev list and in the > https://issues.apache.org/jira/browse/CALCITE-4568 < > https://issues.apache.org/jira/browse/CALCIT

Re: Using Calcite as a Distributed Optimizer

2021-05-13 Thread Roman Kondakov
Hi Atri, you can refer to this list [1]. I also aware that Apache Ignite and Hazelcast made some efforts to employ Calcite as a distributed query planner. [1] https://calcite.apache.org/docs/powered_by.html -- Roman Kondakov On 14.05.2021 14:31, Atri Sharma wrote: Is there an example I ca

Re: Proposal to extend Calcite into a incremental query optimizer

2021-05-13 Thread Forward Xu
Thanks for sharing +1 forward Albert 于2021年5月14日周五 下午2:02写道: > Thanks for sharing > > > 在 2021年5月14日星期五,Julian Hyde 写道: > > > During the meeting we agreed to start progressing this contribution in > the > > usual Apache Way, with conversations on the dev list and in the > > https://issues.apa