[jira] [Created] (CALCITE-2840) Simplification may use narrower UnknownAs modes during AND/OR simplification

Zoltan Haindrich created CALCITE-2840: - Summary: Simplification may use narrower UnknownAs modes during AND/OR simplification Key: CALCITE-2840 URL: https://issues.apache.org/jira/browse/CALCITE-2840

Re: Another Calcite-related paper accepted for SIGMOD -- "One SQL to Rule Them All"

Excellent! Really glad to see all the work that has been happening on streaming SQL in the Apache community get recognized. -- Michael Mior mm...@apache.org Le mar. 12 févr. 2019 à 08:11, Edmon Begoli a écrit : > > Dear Calcite community, > > I want to let you know that another significant paper

Use of noDag parameter in HepPlanner

Hi all, I don't understand what is the correct way to set the noDag [1] parameter in HepPlanner. I understand what it does (internal query graph becomes a tree or a DAG) but I don't see why should I use the one or the other and when. Is it performance related? Are there implications on the rules

[jira] [Created] (CALCITE-2842) Computing digest of IN expressions leads to Exceptions

Zoltan Haindrich created CALCITE-2842: - Summary: Computing digest of IN expressions leads to Exceptions Key: CALCITE-2842 URL: https://issues.apache.org/jira/browse/CALCITE-2842 Project: Calcite

[jira] [Created] (CALCITE-2841) Simplification: push negation into Case expression

Zoltan Haindrich created CALCITE-2841: - Summary: Simplification: push negation into Case expression Key: CALCITE-2841 URL: https://issues.apache.org/jira/browse/CALCITE-2841 Project: Calcite

Re: Another Calcite-related paper accepted for SIGMOD -- "One SQL to Rule Them All"

Congratulations Edmon Begoli 于2019年2月12日周二 下午9:11写道： > Dear Calcite community, > > I want to let you know that another significant paper featuring Calcite > (alongside Apache Flink and Beam) has been accepted for SIGMOD 2019. > > The full title of the paper is: > One SQL to Rule Them All – an

Re: [DISCUSS] Towards Calcite 1.19.0

In order to enable Calcite on a downstream project I need to patch the official release with the PRs of the following Jiras. [CALCITE-2464] Allow to set nullability for columns of structured types [1] [CALCITE-2677] Struct types with one field are not mapped correctly to Java Classes [2]

[jira] [Created] (CALCITE-2844) Babel parser doesn't parse PostgreSQL table function

Muhammad Gelbana created CALCITE-2844: - Summary: Babel parser doesn't parse PostgreSQL table function Key: CALCITE-2844 URL: https://issues.apache.org/jira/browse/CALCITE-2844 Project: Calcite

Global LOOKAHEAD of the SQL parser

Hi all, Recently I have spent some time on playing with Calcite's built-in SQL parsers. And now I'm interested with the reason why the global LOOKAHEAD is set to 2[1] by default. I run a comparative benchmark using the ParserBenchmark util class, and the output log shows visible parsing

[GitHub] asereda-gs commented on issue #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

asereda-gs commented on issue #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#issuecomment-462821709 pls squash commits into one. This is an

Re: Calcite's CBO

Hi Lekshmi, There is really no need to apologise. Hope you and your kid are better now. I don't think there is right or wrong regarding the cost model since it depends mostly on the use-case. If you have a look at the RelOptCost interface you will notice that it is an implementation detail when

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

+1 Having one vcs to deal with, is good; automating the publication of the site is great! Στις Δευ, 11 Φεβ 2019 στις 8:00 μ.μ., ο/η Michael Mior έγραψε: > +1 for me as well and another +1 for automation if we can have this > happen from the "site" branch. > -- > Michael Mior > mm...@apache.org

Re: Calcite's CBO

Hi Stamatis, Thanks a lot for the quick response and support. I think, now I can give an overview of the cost model used in calcite to my other group members. , Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com On Tue, Feb 12, 2019 at 1:58 PM Stamatis Zampetakis wrote: > Hi

Another Calcite-related paper accepted for SIGMOD -- "One SQL to Rule Them All"

Dear Calcite community, I want to let you know that another significant paper featuring Calcite (alongside Apache Flink and Beam) has been accepted for SIGMOD 2019. The full title of the paper is: One SQL to Rule Them All – an Efficient and Syntactically Idiomatic Approach to Management of

[GitHub] vlsi commented on issue #1024: [CALCITE-2817] Make CannotPlanException great

vlsi commented on issue #1024: [CALCITE-2817] Make CannotPlanException great URL: https://github.com/apache/calcite/pull/1024#issuecomment-462833580 Current exception message is very long, and it turns out Avatica duplicates the message (see

[jira] [Created] (CALCITE-2843) Babel parser doesn't parse PostgreSQL casting operator

Muhammad Gelbana created CALCITE-2843: - Summary: Babel parser doesn't parse PostgreSQL casting operator Key: CALCITE-2843 URL: https://issues.apache.org/jira/browse/CALCITE-2843 Project: Calcite

[GitHub] asfgit closed pull request #1035: [CALCITE-1726] Subquery in FILTER is left untransformed

asfgit closed pull request #1035: [CALCITE-1726] Subquery in FILTER is left untransformed URL: https://github.com/apache/calcite/pull/1035 This is an automated message from the Apache Git Service. To respond to the message,

Re: Global LOOKAHEAD of the SQL parser

Does the parser produce correct results if you set LOOKAHEAD to 1? If so, we should use that. Do the extension parsers (e.g. Babel) also work with that setting? We thought we were using as little lookahead as we could get away with, but maybe we were wrong. > On Feb 12, 2019, at 8:24 AM,

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

I support this as long as (1) the site content remains in a separate repo from the source code, and (2) the documentation gets updated. (1) is important because the generated site is large and changes frequently, and I don’t want to bloat the size of our source code repo (which gets copied

[GitHub] vlsi opened a new pull request #84: [CALCITE-2845] Avoid duplication of exception messages

vlsi opened a new pull request #84: [CALCITE-2845] Avoid duplication of exception messages URL: https://github.com/apache/calcite-avatica/pull/84 This is an automated message from the Apache Git Service. To respond to the

Re: Question on ProjectMergeRule

Sorry the documentation isn’t clear, but read the code. It doesn’t remove identical projections so that ProjectRemoveRule can do it instead. ProjectMergeRule has a boolean “force" flag that will cause it to remove even if projections are identical. If you use RelBuilder to build the tree, a

[GitHub] vlsi edited a comment on issue #1024: [CALCITE-2817] Make CannotPlanException great

vlsi edited a comment on issue #1024: [CALCITE-2817] Make CannotPlanException great URL: https://github.com/apache/calcite/pull/1024#issuecomment-462912687 Sample messages: ``` There are not enough rules to produce a node with desired properties: convention=ENUMERABLE, sort=[].

Re: Use of noDag parameter in HepPlanner

I don’t recall. Could you review the tests and see whether tests tend to use noDag=true or false most of the time? Are there any tests that use the less popular value, and if so, is there a particular reason that those tests use that option? Julian > On Feb 12, 2019, at 6:47 AM, Stamatis

[jira] [Created] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

Julian Hyde created CALCITE-2846: Summary: Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference Key: CALCITE-2846 URL: https://issues.apache.org/jira/browse/CALCITE-2846

[jira] [Created] (CALCITE-2845) AvaticaConnection#executeQueryInternal duplicates exception messages

Vladimir Sitnikov created CALCITE-2845: -- Summary: AvaticaConnection#executeQueryInternal duplicates exception messages Key: CALCITE-2845 URL: https://issues.apache.org/jira/browse/CALCITE-2845

[GitHub] chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256116161 ## File path: geode/pom.xml ## @@ -89,11 +89,21 @@ limitations under the

[GitHub] vlsi commented on issue #1024: [CALCITE-2817] Make CannotPlanException great

vlsi commented on issue #1024: [CALCITE-2817] Make CannotPlanException great URL: https://github.com/apache/calcite/pull/1024#issuecomment-462912687 Sample messages: ``` There are not enough rules to produce a node with desired properties: convention=ENUMERABLE, sort=[]. Missing

[GitHub] vlsi edited a comment on issue #1024: [CALCITE-2817] Make CannotPlanException great

vlsi edited a comment on issue #1024: [CALCITE-2817] Make CannotPlanException great URL: https://github.com/apache/calcite/pull/1024#issuecomment-462919545 ``` There are not enough rules to produce a node with desired properties: convention=ENUMERABLE, sort=[]. Missing conversions

Calcite-Master - Build # 1020 - Failure

The Apache Jenkins build system has built Calcite-Master (build #1020) Status: Failure Check console output at https://builds.apache.org/job/Calcite-Master/1020/ to view the results.

Re: [DISCUSS] Towards Calcite 1.19.0

Stamatis, We’ve so far managed to avoid making patch releases. It keeps life simpler if all releases are from the main line. And simple is important, given that there are no salaried release or QA engineers working on Calcite. But as part of that contract, we commit to making releases from

[GitHub] asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256064354 ## File path:

[GitHub] asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256063341 ## File path:

[GitHub] asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256062393 ## File path: geode/pom.xml ## @@ -89,11 +89,21 @@ limitations under

[GitHub] asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256062989 ## File path:

[GitHub] asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256062779 ## File path:

[GitHub] vlsi commented on issue #1040: [CALCITE-2842] Computing digest of IN expressions leads to Exceptions

vlsi commented on issue #1040: [CALCITE-2842] Computing digest of IN expressions leads to Exceptions URL: https://github.com/apache/calcite/pull/1040#issuecomment-462869415 @kgyrtkirk , this looks good to me, however would you please add `&& operandsSize == 2` check to

[GitHub] vlsi commented on issue #1024: [CALCITE-2817] Make CannotPlanException great

vlsi commented on issue #1024: [CALCITE-2817] Make CannotPlanException great URL: https://github.com/apache/calcite/pull/1024#issuecomment-462919545 ``` There are not enough rules to produce a node with desired properties: convention=ENUMERABLE, sort=[]. Missing conversions are

[GitHub] asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

asereda-gs commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256064720 ## File path:

Re: Integrating MySQL's JSON functions

Yeah, the user has no way to know currently. We ought to indicate in https://calcite.apache.org/docs/reference.html which functions are in the standard operator table, and which are in extension tables. Sadly we don’t even document NVL on that page. Logged

Question on ProjectMergeRule

Hi The ProjectMergeRule specifies the following ProjectMergeRule merges a |Project| into another |Project|

[GitHub] asereda-gs commented on issue #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

asereda-gs commented on issue #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#issuecomment-462852974 Commit title should be `[CALCITE-1234] Message (First Last)`. Your message is missing `(First Last)`.

[GitHub] kgyrtkirk opened a new pull request #1040: [CALCITE-2842] Computing digest of IN expressions leads to Exceptions

kgyrtkirk opened a new pull request #1040: [CALCITE-2842] Computing digest of IN expressions leads to Exceptions URL: https://github.com/apache/calcite/pull/1040 This is an automated message from the Apache Git Service. To

Re: [GitHub] vineetgarg02 opened a new pull request #1035: [CALCITE-1726] Subquery in FILTER is left untransformed

Hello devs, I’ll really appreciate if someone can take a look at this pull request (https://github.com/apache/calcite/pull/1035) Thanks, Vineet Garg On Feb 7, 2019, at 9:00 PM, GitBox mailto:g...@apache.org>> wrote: vineetgarg02 opened a new pull request #1035: [CALCITE-1726] Subquery in

Re: Another Calcite-related paper accepted for SIGMOD -- "One SQL to Rule Them All"

Congratulations! Can not wait to read this paper! On Tue, Feb 12, 2019 at 5:34 AM Michael Mior wrote: > Excellent! Really glad to see all the work that has been happening on > streaming SQL in the Apache community get recognized. > -- > Michael Mior > mm...@apache.org > > Le mar. 12 févr. 2019

Re: Another Calcite-related paper accepted for SIGMOD -- "One SQL to Rule Them All"

Congratulations. When the paper will be published ? I presume it is not accessible now ? On Tue, Feb 12, 2019 at 7:08 PM AshwinKumar AshwinKumar < aash...@g.clemson.edu> wrote: > Congratulations > > On Tue, Feb 12, 2019 at 5:11 AM Edmon Begoli wrote: > > > Dear Calcite community, > > > > I want

[GitHub] chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256260787 ## File path:

[GitHub] chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256260866 ## File path:

[GitHub] chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256260737 ## File path:

[GitHub] chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256260806 ## File path:

[GitHub] chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi

chadasa commented on a change in pull request #1036: [CALCITE-2815] GeodeSchemaFactory change to pass in clientCache using jndi URL: https://github.com/apache/calcite/pull/1036#discussion_r256246514 ## File path:

Re: Question on ProjectMergeRule

Julian, Thank for your reply, I also found ProjectRemoveRule and it successfully did what I needed.  Much appreciated. One interesting thing I am using these 4 rules: FilterProjectTransposeRule.INSTANCE, ProjectRemoveRule.INSTANCE, ProjectMergeRule.INSTANCE, FilterMergeRule.INSTANCE I am

[GitHub] vlsi commented on a change in pull request #85: [CALCITE-2704] Avoid use of ISO-8859-1 to parse request in JsonHandler

vlsi commented on a change in pull request #85: [CALCITE-2704] Avoid use of ISO-8859-1 to parse request in JsonHandler URL: https://github.com/apache/calcite-avatica/pull/85#discussion_r256155266 ## File path:

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

The site will be in its own Git repo. See [1] for a list of other ASF projects' sites in their own repo. I will be updating the instructions once when the repo is moved. Once the move is completed, there should be no changes to the existing workflow for publishing the site, except for

[GitHub] vlsi commented on a change in pull request #1024: [CALCITE-2817] Make CannotPlanException great

vlsi commented on a change in pull request #1024: [CALCITE-2817] Make CannotPlanException great URL: https://github.com/apache/calcite/pull/1024#discussion_r256147817 ## File path: core/src/main/java/org/apache/calcite/plan/volcano/VolcanoPlanner.java ## @@ -1157,8

Re: Question on ProjectMergeRule

Julian, I am going to speculate it is due to the ProjectRemoveRule. Since the Project is on the Join and only projects its inputs. Thanks On 2019-02-12 1:36 p.m., Homer wrote: Julian, Thank for your reply, I also found ProjectRemoveRule and it successfully did what I needed.  Much

Re: Another Calcite-related paper accepted for SIGMOD -- "One SQL to Rule Them All"

Congratulations On Tue, Feb 12, 2019 at 5:11 AM Edmon Begoli wrote: > Dear Calcite community, > > I want to let you know that another significant paper featuring Calcite > (alongside Apache Flink and Beam) has been accepted for SIGMOD 2019. > > The full title of the paper is: > One SQL to Rule

[GitHub] vlsi opened a new pull request #85: [CALCITE-2704] Avoid use of ISO-8859-1 to parse request in JsonHandler

vlsi opened a new pull request #85: [CALCITE-2704] Avoid use of ISO-8859-1 to parse request in JsonHandler URL: https://github.com/apache/calcite-avatica/pull/85 I'm pretty confident that this one fixes https://issues.apache.org/jira/browse/CALCITE-2704, and this change should be way

Re: [DISCUSS] Towards Calcite 1.19.0

I was not suggesting changing the release process. I wanted just to highlight the fact that if the aforementioned tickets are not part of 1.19 I will have to create an unofficial bundle which includes them in order to keep the downstream project working. Sorry for the confusion. Στις Τρί, 12 Φεβ

Re: Calcite's CBO

Hi, Thanks a lot all for your support. I'm really sorry for the late response because my kid and myself were affected with flu since the last few days. I have one more doubt, > records are a partial order: (1, 3) is less than (2, 4), but (1, 3) is neither less than nor greater than (2, 2). If