Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-11 Thread Volodymyr Vysotskyi
Both blocking the release issues were fixed and almost all "nice to have" fixes from the list were merged into the master, thanks a lot for this to everyone! Regarding PRs which may be included into the release, looks like work for CALCITE-2366

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-11 Thread Stamatis Zampetakis
Hello, I would like to bring your attention towards a new issue namely https://issues.apache.org/jira/browse/CALCITE-2404 concerning access on structured types. Basically, any query involving fields of Record type cannot be executed by the runtime (in Enumerable/Bindable convention). At least for

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-11 Thread Volodymyr Vysotskyi
Hello Stamatis, Do you have ETA for the fix for this Jira? If it will be solved in the next couple of days, we can include it to 1.17. Kind regards, Volodymyr Vysotskyi ср, 11 лип. 2018 о 13:30 Stamatis Zampetakis пише: > Hello, > > I would like to bring your attention towards a new issue nam

[jira] [Created] (CALCITE-2409) SparkAdapterTest fails on Windows

2018-07-11 Thread Sergey Nuyanzin (JIRA)
Sergey Nuyanzin created CALCITE-2409: Summary: SparkAdapterTest fails on Windows Key: CALCITE-2409 URL: https://issues.apache.org/jira/browse/CALCITE-2409 Project: Calcite Issue Type: Bug

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-11 Thread Michael Mior
It would be good if someone else could also have a look at the PR below for CALCITE-2331 as it's basically ready to merge pending a decision on a behaviour change. https://github.com/apache/calcite/pull/755 -- Michael Mior mm...@uwaterloo.ca Le mer. 11 juil. 2018 à 06:30, Stamatis Zampetakis a

[jira] [Created] (CALCITE-2410) Enable ProjectSetOpTransposeRule for UNION (distinct) SetOp operator

2018-07-11 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created CALCITE-2410: Summary: Enable ProjectSetOpTransposeRule for UNION (distinct) SetOp operator Key: CALCITE-2410 URL: https://issues.apache.org/jira/browse/CALCITE-2410 Projec

Stream-stream joins

2018-07-11 Thread Piotr Nowojski
Hi, In Flink we are now discussing how to implement “enrichment joins” (stream to stream) in SQL. I have create a document with our proposal how to implement it [1] (relevant to this email is “Syntax / SQL / querying” section). I was working on top of the Julian’s document from 2016 [2]. In [2

[jira] [Created] (CALCITE-2411) expose a table for each ES index (by default)

2018-07-11 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2411: -- Summary: expose a table for each ES index (by default) Key: CALCITE-2411 URL: https://issues.apache.org/jira/browse/CALCITE-2411 Project: Calcite Issue T

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-11 Thread Andrei Sereda
Hello, If people on this list don't mind, I would like to finish two more issues for ES adapter: 1) CALCITE-2408 enable aggregate functions in ES adapter 2) CALCITE-2411 expose a table for each ES index (by default) - this was discussed on dev list la

Calcite-Master - Build # 329 - Still Failing

2018-07-11 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #329) Status: Still Failing Check console output at https://builds.apache.org/job/Calcite-Master/329/ to view the results.

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-11 Thread Julian Hyde
I think this release train has waited long enough. We should wait for issues that people are fixing themselves, within the next 24 hours. And review PRs that have already been submitted. We release regularly, so there will be another train in a couple of months. Julian > On Jul 11, 2018, at 07

Avatica/Calcite tests against Windows

2018-07-11 Thread Sergey Nuyanzin
Hello all Are there future plans to have regular check that at least mvn clean install works fine on Windows? Unfortunately Travis does not support Windows [1]. Currently I use Appveyor to do that on my own e.g. [2], [3]. However it would be great if anything similar will be in Avatica/Calcite rep

Re: Avatica/Calcite tests against Windows

2018-07-11 Thread Michael Mior
If you have an Appveyor setup that works, I don't see an obvious reason why we couldn't merge that in and use it. Others may have concerns, so I'll let them chime in. One question I have is why it seems your Appveyor setup includes DOCKER_USER and DOCKER_PASS since it seems like there aren't any ac

Re: Avatica/Calcite tests against Windows

2018-07-11 Thread Julian Hyde
To answer Sergey’s original question: there are no plans. I try to build and test on Windows before each release. If you can do more that would be great. > On Jul 11, 2018, at 9:22 AM, Michael Mior wrote: > > If you have an Appveyor setup that works, I don't see an obvious > reason why we could

Re: Stream-stream joins

2018-07-11 Thread Julian Hyde
Just to clarify the subject. We’re not talking about stream-to-stream joins but stream joining to a temporal table. It’s not an equi-join: when an order occurs, we look for the applicable rate for that order. If I am mistaken in this, please let me know. All 3 syntaxes look reasonable in princi

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-11 Thread Stamatis Zampetakis
Hi Volodymyr, I hope to be done with https://issues.apache.org/jira/browse/CALCITE-2404 before the end of next week. Personally, I don't mind if it does not make it to this release since for my use-case I can patch the code directly. Best, Stamatis 2018-07-11 17:13 GMT+02:00 Julian Hyde : > I t

[jira] [Created] (CALCITE-2412) Avatica/Calcite tests against Windows via Appveyor

2018-07-11 Thread Sergey Nuyanzin (JIRA)
Sergey Nuyanzin created CALCITE-2412: Summary: Avatica/Calcite tests against Windows via Appveyor Key: CALCITE-2412 URL: https://issues.apache.org/jira/browse/CALCITE-2412 Project: Calcite

Re: Avatica/Calcite tests against Windows

2018-07-11 Thread Sergey Nuyanzin
Michael, Julian thank you for your responses I created a ticket with PRs https://issues.apache.org/jira/browse/CALCITE-2412 P.S. about DOCKER_USER and DOCKER_PASS: sorry it were artifact of some personal tests On Wed, Jul 11, 2018 at 7:53 PM, Julian Hyde wrote: > To answer Sergey’s original que

User defined functions

2018-07-11 Thread subbarao mitta
Hi how to add existing user defined functions in Oracle database to schema in calcite.I am connected Oracle database using schema but I don't know how to add existing user defined functions to schema.

A very urgent question, please help me, thanks

2018-07-11 Thread 吴亮亮
hello: I have reading calcite source code about Elasticsearch adapter, when I debug the code ,I find that the Elasticsearch adapter can not support UDF ( I wrote a UDF , and rigister it),what's more , the function of calcite own support is also Invalid ,such as lower() or concat() . What should