Re: [RESULT] [VOTE] Release apache-calcite-1.21.0 (release candidate 1)

2019-09-10 Thread Danny Chan
Nice Job, Stamatis ! Best, Danny Chan 在 2019年9月11日 +0800 AM5:28,Stamatis Zampetakis ,写道: > Thanks to everyone who has tested the release candidate and given > their comments and votes. > > The tally is as follows. > > 4 binding +1s: > Julian H., Francis, Vladimir, Stamatis > > 6 non-binding +1s:

Re: Appropriate query syntax for table-value function windowing (e.g. CALCITE-3272)

2019-09-10 Thread Rui Wang
I should have given more context but I think Julian's response is similar and close to (if not just the same as) what I faced. I tried "select * FROM TABLE(TUMBLE_TVF(ORDERS, ROWTIME, INTERVAL '10' MINUTE))" named parameters, TABLE ORDERS, TABLE(ORDERS), DESCRIPTOR(ROWTIME), etc. were not

Re: [RESULT] [VOTE] Release apache-calcite-1.21.0 (release candidate 1)

2019-09-10 Thread Julian Feinauer
Thank you Francis, good job! JulianF Am 10.09.19, 14:34 schrieb "Francis Chuang" : Thanks for getting this massive release out, Stamatis! Francis On 11/09/2019 7:27 am, Stamatis Zampetakis wrote: > Thanks to everyone who has tested the release candidate and given

Re: [RESULT] [VOTE] Release apache-calcite-1.21.0 (release candidate 1)

2019-09-10 Thread Francis Chuang
Thanks for getting this massive release out, Stamatis! Francis On 11/09/2019 7:27 am, Stamatis Zampetakis wrote: Thanks to everyone who has tested the release candidate and given their comments and votes. The tally is as follows. 4 binding +1s: Julian H., Francis, Vladimir, Stamatis 6

[RESULT] [VOTE] Release apache-calcite-1.21.0 (release candidate 1)

2019-09-10 Thread Stamatis Zampetakis
Thanks to everyone who has tested the release candidate and given their comments and votes. The tally is as follows. 4 binding +1s: Julian H., Francis, Vladimir, Stamatis 6 non-binding +1s: Anton, Julian F., Haisheng, Danny, Chunwei, Andrei No 0s or -1s. Therefore I am delighted to announce

Re: Appropriate query syntax for table-value function windowing (e.g. CALCITE-3272)

2019-09-10 Thread Julian Hyde
Are you referring to problems parsing this: SELECT * FROM Tumble ( data => TABLE Bid , timecol => DESCRIPTOR ( bidtime ) , dur => INTERVAL '10' MINUTES , offset => INTERVAL '0' MINUTES ); If so I can see how "TABLE Bid” and "DESCRIPTOR ( bidtime ) “ might cause the validator

Re: Appropriate query syntax for table-value function windowing (e.g. CALCITE-3272)

2019-09-10 Thread Rui Wang
I might have identified the first blocker: I am using sql identifier as parameters for table name and column name (not character literals), which is already how current TUMBLE works as current TUMBLE accepts an identifier as the first parameter to specify the TIMESTAMP column. During planner

Re: JavaScript Avatica client

2019-09-10 Thread Julian Hyde
I have to say… if you wish to contribute this, we would definitely consider it. It would not be the first client in a non-JVM language: Francis wrote the Go driver and now it is part of Calcite/Avatica. Julian > On Sep 10, 2019, at 3:03 AM, Francis Chuang wrote: > > Hi Gabriel, > > It's

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

2019-09-10 Thread Andrei Sereda
+1 (non-binding) Minor correction: sha256 of source distribution (apache-calcite-1.21.0-src.tar.gz) is ccd10264f89a84bc750837cc2d0e66b7d74a81dd825d0a88f501153d4745eee3 Environment: Mac OS X Java version: 11.0.4, vendor: AdoptOpenJDK Maven 3.6.1 mvn clean install - OK sh256 check - OK GPG check

Re: Issues in exposing data via TableFunction vs TableMacro

2019-09-10 Thread Julian Hyde
I always thought of a table function as a lightweight relational operator. You could write your own UNION function, for instance. But the moment you want it to start participating in algebraic rewrites - if you want to push filters through it, for instance - then you had better make it into a

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

2019-09-10 Thread Vladimir Sitnikov
+1 There are OsAdapterTest.testPs and testPsDistinct failures, however they are well known. Vladimir

[jira] [Created] (CALCITE-3338) Error with executeBatch and preparedStatement.

2019-09-10 Thread Jacob Roldan (Jira)
Jacob Roldan created CALCITE-3338: - Summary: Error with executeBatch and preparedStatement. Key: CALCITE-3338 URL: https://issues.apache.org/jira/browse/CALCITE-3338 Project: Calcite Issue

Re: Issues in exposing data via TableFunction vs TableMacro

2019-09-10 Thread Julian Feinauer
Hey, when going through the Code I just had another Idea. Currently a TableFunction is executed as EnumerableTableFunctionScan which gets generated from a LogicalTableFunctionScan by the Rule EnumerableTableFunctionScanRule. What if you just remove that Rule and add a custom Rule of yours which

Re: Issues in exposing data via TableFunction vs TableMacro

2019-09-10 Thread Julian Feinauer
Hi Gabriel, thats an interesting question for me too. Do you need parameters for those "dynamic tables"? If not you could do it similar to what Drill is doing and just implement a Schema which always returns "true" if someone asks for a Table and then returns a Table Implementation that you

Issues in exposing data via TableFunction vs TableMacro

2019-09-10 Thread Gabriel Reid
Hi, I'm currently using a combination of TableFunctions and TableMacros to expose various dynamic (relatively unstructured) data sources via Calcite. The underlying data sources are such that data can only be retrieved by first specifying what you want (i.e. there is no catalog of all data that

Re: JavaScript Avatica client

2019-09-10 Thread Francis Chuang
Hi Gabriel, It's always very exciting to see new clients/drivers for Avatica that are contributed by the community. We maintain a list of clients for Avatica on this page: https://calcite.apache.org/avatica/docs/ Would it be okay to add your Javascript client to that page? Francis On

[jira] [Created] (CALCITE-3337) Support query arrays of Embedded Documents in MongoDB adapter

2019-09-10 Thread Martin Dearnley (Jira)
Martin Dearnley created CALCITE-3337: Summary: Support query arrays of Embedded Documents in MongoDB adapter Key: CALCITE-3337 URL: https://issues.apache.org/jira/browse/CALCITE-3337 Project:

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

2019-09-10 Thread Chunwei Lei
+1 (non-binding) Environment: Mac OS X 10.12.6, JDK 1.8.0_201, Maven 3.5.0 - Checked signatures and checksums - OK - Checked release note - OK - Ran unit tests (mvn clean install) - OK Best, Chunwei On Tue, Sep 10, 2019 at 10:14 AM Danny Chan wrote: > +1 Binding > > Environment:

JavaScript Avatica client

2019-09-10 Thread Gabriel Reid
Hi, I just wanted to let anyone who's interested know that I've recently been working on a JavaScript (i.e. Node.js) client for Avatica. The current status is that it does what I need it to do (i.e. it can execute a query and return the results), and it could potentially be useful to others (as