Re:Re: Integrating MySQL's JSON functions

2019-02-11 Thread Hongze Zhang
Thanks for the suggestions Julian and Stamatis! I would support the idea about adding a MysqlSqlOperatorTable to Calcite, what I was not sure about is whether to put MySQL's JSON functions to it. I was wandering if user could easily know (e.g.) JSON_TYPE is a MySQL functions and JSON_VALUE is

Re: Failed to parse a PostgreSQL query using the Babel conformance

2019-02-11 Thread Muhammad Gelbana
Your replies are very much appreciated. I'll see what I can do. @Julian, I believe '=' acts as a boolean operator here because the query returns boolean results for that part of the selection. Thanks, Gelbana On Mon, Feb 11, 2019 at 8:38 PM Julian Hyde wrote: > There are a few Postgres-isms

Re: [DISCUSS] Towards Calcite 1.19.0

2019-02-11 Thread Francis Chuang
Thanks for getting this started, Kevin! On 12/02/2019 6:39 am, Julian Hyde wrote: Are there any JIRA cases that should make it into 1.19.0 but are not yet finished? Yes - there are a lot cases that have a PR ready that have not been reviewed / committed. We, the committers, will need to make

Re: [DISCUSS] Towards Calcite 1.19.0

2019-02-11 Thread Julian Hyde
>> Are there any JIRA cases that should make it into 1.19.0 but are not yet >> finished? Yes - there are a lot cases that have a PR ready that have not been reviewed / committed. We, the committers, will need to make a team effort to get as many of these in as possible. Julian > On Feb 11,

Re: [DISCUSS] Towards Calcite 1.19.0

2019-02-11 Thread Michael Mior
Thanks for getting the ball rolling Kevin! -- Michael Mior mm...@apache.org Le lun. 11 févr. 2019 à 09:51, Kevin Risden a écrit : > > Calcite 1.18.0 was released on 2018-12 (coming up on 2 months ago). It is > time to get the ball rolling for the Calcite 1.19.0 release since there > have been

Re: Pushing to site (in svn)

2019-02-11 Thread Michael Mior
Just to clarify that it is *intentional* that master and site are not in sync. For example, the Javadoc should refer to the currently published version of Calcite, not whatever is currently in progress. Also, any documentation on new features or changes should only appear when those are released,

Re: Failed to parse a PostgreSQL query using the Babel conformance

2019-02-11 Thread Julian Hyde
There are a few Postgres-isms in that SQL: The “::” (as a shorthand for cast) in 'typinput='array_in'::regproc The ‘=‘ (as a shorthand for alias) in 'typinput='array_in'::regproc’ Use of a table function without the ’TABLE’ keyword, in 'from generate_series(1, array_upper(current_schemas(false),

Re: [DISCUSS] Move site repositories from svn to gitbox

2019-02-11 Thread Andrei Sereda
+1 On Mon, Feb 11, 2019 at 9:44 AM Julian Feinauer < j.feina...@pragmaticminds.de> wrote: > We also use it for PLC4X and it works flawlessly. > +1 > > Julian > > Am 11.02.19, 11:23 schrieb "Vova Vysotskyi" : > > Great idea! Drill website already uses gitbox [1] > > +1 > > [1]

[DISCUSS] Towards Calcite 1.19.0

2019-02-11 Thread Kevin Risden
Calcite 1.18.0 was released on 2018-12 (coming up on 2 months ago). It is time to get the ball rolling for the Calcite 1.19.0 release since there have been releases every 2-3 months. Calcite currently has 32 JIRA issues tagged for 1.19.0 with 68 commits. Avatica currently has 2 JIRA issues tagged

Re: [DISCUSS] Move site repositories from svn to gitbox

2019-02-11 Thread Julian Feinauer
We also use it for PLC4X and it works flawlessly. +1 Julian Am 11.02.19, 11:23 schrieb "Vova Vysotskyi" : Great idea! Drill website already uses gitbox [1] +1 [1] https://gitbox.apache.org/repos/asf?p=drill-site.git Kind regards, Volodymyr Vysotskyi

Re: Release managers

2019-02-11 Thread Julian Feinauer
Hi Kevin, this should make things easier definitely and speed up the process. Julian Am 11.02.19, 15:39 schrieb "Kevin Risden" : I can volunteer to do the 1.19 2019-02 release. We are getting to midway through February :) Kevin Risden On Thu, Feb 7, 2019 at 3:23

Re: Release managers

2019-02-11 Thread Kevin Risden
I can volunteer to do the 1.19 2019-02 release. We are getting to midway through February :) Kevin Risden On Thu, Feb 7, 2019 at 3:23 AM Julian Feinauer wrote: > Hey all, > > I don't know if this is unusual or undoable due to permission issues as > I'm no commiter. > But I'd like to offer my

Re: Failed to parse a PostgreSQL query using the Babel conformance

2019-02-11 Thread Stamatis Zampetakis
Hi Gelbana, In order to use the Babel parser you need to also set an appropriate factory to your parser configuration since setting only the conformance is not enough. Try adding the following: ... configBuilder().setParserFactory(SqlBabelParserImpl.FACTORY); Having said that I am not sure if

[GitHub] rubenada commented on a change in pull request #1020: [CALCITE-2812] Add algebraic operators to allow expressing recursive queries (Ruben Quesada Lopez)

2019-02-11 Thread GitBox
rubenada commented on a change in pull request #1020: [CALCITE-2812] Add algebraic operators to allow expressing recursive queries (Ruben Quesada Lopez) URL: https://github.com/apache/calcite/pull/1020#discussion_r255524984 ## File path:

Re: Re: Integrating MySQL's JSON functions

2019-02-11 Thread Stamatis Zampetakis
Hi Hongze, Qianjin, I apologise fo the late response. I still don't understand why it is problematic to create a separate MySQLOperatorTable. You can easily combine operator tables (using ChainedSqlOperatorTable for instance) and pass them around to places were otherwise you would put a single

SQL auditing for Calcite JDBC

2019-02-11 Thread Hanan Yehudai
Hi, I’m new to the group  what is the best way to log the incoming SQL statements into my Calcite adapter via JDBC. As well as to monitoring the performance. I looked for Loggers in the code and could not found one that logs that actual SQL. and nothing seems to be logged into the predefined

Re: [DISCUSS] Move site repositories from svn to gitbox

2019-02-11 Thread Vova Vysotskyi
Great idea! Drill website already uses gitbox [1] +1 [1] https://gitbox.apache.org/repos/asf?p=drill-site.git Kind regards, Volodymyr Vysotskyi On Mon, Feb 11, 2019 at 12:01 PM Francis Chuang wrote: > Hey all, > > ASF project sites have the ability to use git instead of subversion as >

Re: [DISCUSS] Move site repositories from svn to gitbox

2019-02-11 Thread Vladimir Sitnikov
Francis> How do you guys feel about moving our site's repository from svn to GitBox? +1 Vladimir

[DISCUSS] Move site repositories from svn to gitbox

2019-02-11 Thread Francis Chuang
Hey all, ASF project sites have the ability to use git instead of subversion as their repository for web site content [1]. It has been available since 2015 and appears to be quite stable. Quite a few other projects have also moved their websites to git and subsequently, Gitbox (for using

[GitHub] rubenada commented on a change in pull request #1020: [CALCITE-2812] Add algebraic operators to allow expressing recursive queries (Ruben Quesada Lopez)

2019-02-11 Thread GitBox
rubenada commented on a change in pull request #1020: [CALCITE-2812] Add algebraic operators to allow expressing recursive queries (Ruben Quesada Lopez) URL: https://github.com/apache/calcite/pull/1020#discussion_r255430050 ## File path:

[GitHub] rubenada commented on a change in pull request #1020: [CALCITE-2812] Add algebraic operators to allow expressing recursive queries (Ruben Quesada Lopez)

2019-02-11 Thread GitBox
rubenada commented on a change in pull request #1020: [CALCITE-2812] Add algebraic operators to allow expressing recursive queries (Ruben Quesada Lopez) URL: https://github.com/apache/calcite/pull/1020#discussion_r255429972 ## File path:

[GitHub] XuQianJin-Stars commented on a change in pull request #1013: [CALCITE-2791]Add the JSON_TYPE function

2019-02-11 Thread GitBox
XuQianJin-Stars commented on a change in pull request #1013: [CALCITE-2791]Add the JSON_TYPE function URL: https://github.com/apache/calcite/pull/1013#discussion_r255426711 ## File path: site/_docs/reference.md ## @@ -567,6 +567,7 @@ JSON, **JSON_OBJECT**,