[jira] [Resolved] (CALCITE-3050) Integrate SqlDialect and SqlParser.Config

[ https://issues.apache.org/jira/browse/CALCITE-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3050. -- Resolution: Fixed Assignee: Julian Hyde (was: Danny Chan) Fix Version/s:

[jira] [Commented] (CALCITE-3084) Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845477#comment-16845477 ] Julian Hyde commented on CALCITE-3084: -- Thanks! > Implement JDBC string functions: ASCII, REPEAT,

[jira] [Commented] (CALCITE-3021) ArrayEqualityComparer should use Arrays#deepEquals/deepHashCode instead of Arrays#equals/hashCode

[ https://issues.apache.org/jira/browse/CALCITE-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845475#comment-16845475 ] Julian Hyde commented on CALCITE-3021: -- If we now do the same as PostgreSQL, that's good enough

[jira] [Commented] (CALCITE-3084) Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845474#comment-16845474 ] pingle wang commented on CALCITE-3084: -- done, thanks. > Implement JDBC string functions: ASCII,

[jira] [Commented] (CALCITE-3081) Literal NULL should be generated in SqlDialect

[ https://issues.apache.org/jira/browse/CALCITE-3081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845469#comment-16845469 ] Danny Chan commented on CALCITE-3081: - I kind of have plan to push the CALCITE-2302 forward, i'm

[jira] [Commented] (CALCITE-3084) Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845467#comment-16845467 ] Julian Hyde commented on CALCITE-3084: -- Please create JIRA links. > Implement JDBC string

[jira] [Commented] (CALCITE-734) Push GROUPING SETS to underlying SQL via JDBC adapter

[ https://issues.apache.org/jira/browse/CALCITE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845462#comment-16845462 ] Feng Zhu commented on CALCITE-734: -- Hi, [~julianhyde]. We use Calcite to pre-process (i.e., parse,

[jira] [Commented] (CALCITE-3084) Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845460#comment-16845460 ] pingle wang commented on CALCITE-3084: -- [~julianhyde]  At the beginning I was [CALCITE-2965]

[jira] [Comment Edited] (CALCITE-3084) Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845453#comment-16845453 ] Julian Hyde edited comment on CALCITE-3084 at 5/22/19 3:17 AM: --- Does this

[jira] [Commented] (CALCITE-3084) Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845453#comment-16845453 ] Julian Hyde commented on CALCITE-3084: -- Does this relate to CALCITE-2965? If so please link the

[jira] [Commented] (CALCITE-3081) Literal NULL should be generated in SqlDialect

[ https://issues.apache.org/jira/browse/CALCITE-3081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845447#comment-16845447 ] Feng Zhu commented on CALCITE-3081: --- Thank for your feedback, Danny. Yes，the strong type validation

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845446#comment-16845446 ] Hongze Zhang commented on CALCITE-2593: --- {quote}Since the problem arises from some empty subsets

[jira] [Created] (CALCITE-3084) Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE

pingle wang created CALCITE-3084: Summary: Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE Key: CALCITE-3084 URL: https://issues.apache.org/jira/browse/CALCITE-3084

[jira] [Commented] (CALCITE-3081) Literal NULL should be generated in SqlDialect

[ https://issues.apache.org/jira/browse/CALCITE-3081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845420#comment-16845420 ] Danny Chan commented on CALCITE-3081: - This question kind of belongs to the scope of implicit type

[jira] [Commented] (CALCITE-3036) Remove correlate variables from Join

[ https://issues.apache.org/jira/browse/CALCITE-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845419#comment-16845419 ] Danny Chan commented on CALCITE-3036: - [~zabetak] thanks so much for your kindly summarize ! >

[jira] [Created] (CALCITE-3083) Add demos(how to) doc for all supported DDLs and DMLs

Danny Chan created CALCITE-3083: --- Summary: Add demos(how to) doc for all supported DDLs and DMLs Key: CALCITE-3083 URL: https://issues.apache.org/jira/browse/CALCITE-3083 Project: Calcite

[jira] [Comment Edited] (CALCITE-1126) Add "&" operation

[ https://issues.apache.org/jira/browse/CALCITE-1126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845347#comment-16845347 ] Julian Hyde edited comment on CALCITE-1126 at 5/21/19 11:17 PM: It

[jira] [Commented] (CALCITE-1126) Add "&" operation

[ https://issues.apache.org/jira/browse/CALCITE-1126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845347#comment-16845347 ] Julian Hyde commented on CALCITE-1126: -- It could go into the Babel parser. I would not add it to

[jira] [Resolved] (CALCITE-3023) Upgrade to Elasticsearch 7.0.0

[ https://issues.apache.org/jira/browse/CALCITE-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrei Sereda resolved CALCITE-3023. Resolution: Fixed Merged in

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845342#comment-16845342 ] Vladimir Sitnikov commented on CALCITE-2593: [~zabetak], I think now we face a case with

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845335#comment-16845335 ] Stamatis Zampetakis commented on CALCITE-2593: -- Hi [~zhztheplayer], the change in the rule

[jira] [Comment Edited] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845335#comment-16845335 ] Stamatis Zampetakis edited comment on CALCITE-2593 at 5/21/19 10:57 PM:

[jira] [Commented] (CALCITE-2807) Identify expanded IS NOT DISTINCT FROM expression when pushing down filter past join

[ https://issues.apache.org/jira/browse/CALCITE-2807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845318#comment-16845318 ] Julian Hyde commented on CALCITE-2807: -- For the record, while we'd prefer shorter messages in

[jira] [Commented] (CALCITE-2807) Identify expanded IS NOT DISTINCT FROM expression when pushing down filter past join

[ https://issues.apache.org/jira/browse/CALCITE-2807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845293#comment-16845293 ] Laurent Goujon commented on CALCITE-2807: - I was not necessary thinking of Github guidelines

[jira] [Commented] (CALCITE-2807) Identify expanded IS NOT DISTINCT FROM expression when pushing down filter past join

[ https://issues.apache.org/jira/browse/CALCITE-2807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845289#comment-16845289 ] Julian Hyde commented on CALCITE-2807: -- (If you want a laugh, Google for what Linus thinks of

[jira] [Commented] (CALCITE-2807) Identify expanded IS NOT DISTINCT FROM expression when pushing down filter past join

[ https://issues.apache.org/jira/browse/CALCITE-2807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845287#comment-16845287 ] Julian Hyde commented on CALCITE-2807: -- Don't worry about github's guidelines. Our goal is to have

[jira] [Commented] (CALCITE-2807) Identify expanded IS NOT DISTINCT FROM expression when pushing down filter past join

[ https://issues.apache.org/jira/browse/CALCITE-2807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845286#comment-16845286 ] Laurent Goujon commented on CALCITE-2807: - I agree that IDNF is jargon but I actually mentioned

[jira] [Commented] (CALCITE-2807) Identify expanded IS NOT DISTINCT FROM expression when pushing down filter past join

[ https://issues.apache.org/jira/browse/CALCITE-2807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845282#comment-16845282 ] Julian Hyde commented on CALCITE-2807: -- Commit message is unclear. INDF is jargon. > Identify

[jira] [Commented] (CALCITE-3036) Remove correlate variables from Join

[ https://issues.apache.org/jira/browse/CALCITE-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845276#comment-16845276 ] Stamatis Zampetakis commented on CALCITE-3036: -- Moreover, as part of the ongoing work on

[jira] [Commented] (CALCITE-3036) Remove correlate variables from Join

[ https://issues.apache.org/jira/browse/CALCITE-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845275#comment-16845275 ] Stamatis Zampetakis commented on CALCITE-3036: -- The discussion was done as part of the

[jira] [Updated] (CALCITE-3082) NPE in SqlUtil#getSelectListItem

[ https://issues.apache.org/jira/browse/CALCITE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laurent Goujon updated CALCITE-3082: Description: Queries similar to {{SELECT 1 UNION SELECT 2, 3}} causes validator to

[jira] [Updated] (CALCITE-2807) Identify expanded IS NOT DISTINCT FROM expression when pushing down filter past join

[ https://issues.apache.org/jira/browse/CALCITE-2807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2807: Labels: pull-request-available (was: ) > Identify expanded IS NOT DISTINCT FROM

[jira] [Commented] (CALCITE-2979) Add a block-based nested loop join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845257#comment-16845257 ] Julian Hyde commented on CALCITE-2979: -- No objections from me to adding a new operator

[jira] [Commented] (CALCITE-2889) IndexOutOfBoundsException in EnumUtils#fromInternal when handling methods with varargs

[ https://issues.apache.org/jira/browse/CALCITE-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845246#comment-16845246 ] Julian Hyde commented on CALCITE-2889: -- * Can you change commit message to describe the problem.

[jira] [Commented] (CALCITE-3082) NPE in SqlUtil#getSelectListItem

[ https://issues.apache.org/jira/browse/CALCITE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845240#comment-16845240 ] Julian Hyde commented on CALCITE-3082: -- +1 Please change the commit message & bug description to

[jira] [Updated] (CALCITE-3082) NPE in SqlUtil#getSelectListItem

[ https://issues.apache.org/jira/browse/CALCITE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3082: Labels: pull-request-available (was: ) > NPE in SqlUtil#getSelectListItem >

[jira] [Created] (CALCITE-3082) NPE in SqlUtil#getSelectListItem

Laurent Goujon created CALCITE-3082: --- Summary: NPE in SqlUtil#getSelectListItem Key: CALCITE-3082 URL: https://issues.apache.org/jira/browse/CALCITE-3082 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845093#comment-16845093 ] Julian Hyde commented on CALCITE-3005: -- FWIW, the functions are not in Oracle. {{select

[jira] [Commented] (CALCITE-2979) Add a block-based nested loop join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844977#comment-16844977 ] Andrei Sereda commented on CALCITE-2979: Thanks for starting this conversation. I have some

[jira] [Commented] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844975#comment-16844975 ] Rong Rong commented on CALCITE-3008: [~julianhyde] I followed most of your suggestions and tried to

[jira] [Updated] (CALCITE-3081) Literal NULL should be generated in SqlDialect

[ https://issues.apache.org/jira/browse/CALCITE-3081?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu updated CALCITE-3081: -- Description: In Calcite, this simple query will throw exception during validation, even it is ok in

[jira] [Created] (CALCITE-3081) Literal NULL should be generated in SqlDialect

Feng Zhu created CALCITE-3081: - Summary: Literal NULL should be generated in SqlDialect Key: CALCITE-3081 URL: https://issues.apache.org/jira/browse/CALCITE-3081 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-3079) Successive dependent windows cannot be implemented in same expression level

[ https://issues.apache.org/jira/browse/CALCITE-3079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844897#comment-16844897 ] Feng Zhu commented on CALCITE-3079: --- Thanks for review, [~danny0405]. Agree with your idea, I will

[jira] [Commented] (CALCITE-3079) Successive dependent windows cannot be implemented in same expression level

[ https://issues.apache.org/jira/browse/CALCITE-3079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844833#comment-16844833 ] Danny Chan commented on CALCITE-3079: - I digged into the code a little and think the original Q1

[jira] [Comment Edited] (CALCITE-3021) ArrayEqualityComparer should use Arrays#deepEquals/deepHashCode instead of Arrays#equals/hashCode

[ https://issues.apache.org/jira/browse/CALCITE-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844785#comment-16844785 ] Ruben Quesada Lopez edited comment on CALCITE-3021 at 5/21/19 12:39 PM:

[jira] [Commented] (CALCITE-3021) ArrayEqualityComparer should use Arrays#deepEquals/deepHashCode instead of Arrays#equals/hashCode

[ https://issues.apache.org/jira/browse/CALCITE-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844785#comment-16844785 ] Ruben Quesada Lopez commented on CALCITE-3021: -- I found this (which I think confirms that

[jira] [Commented] (CALCITE-3079) Successive dependent windows cannot be implemented in same expression level

[ https://issues.apache.org/jira/browse/CALCITE-3079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844737#comment-16844737 ] Danny Chan commented on CALCITE-3079: - Reviewing now ... > Successive dependent windows cannot be

[jira] [Comment Edited] (CALCITE-3021) ArrayEqualityComparer should use Arrays#deepEquals/deepHashCode instead of Arrays#equals/hashCode

[ https://issues.apache.org/jira/browse/CALCITE-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844664#comment-16844664 ] Ruben Quesada Lopez edited comment on CALCITE-3021 at 5/21/19 9:34 AM:

[jira] [Commented] (CALCITE-3021) ArrayEqualityComparer should use Arrays#deepEquals/deepHashCode instead of Arrays#equals/hashCode

[ https://issues.apache.org/jira/browse/CALCITE-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844664#comment-16844664 ] Ruben Quesada Lopez commented on CALCITE-3021: -- [~zabetak], I agree: title / description

[jira] [Commented] (CALCITE-3021) ArrayEqualityComparer should use Arrays#deepEquals/deepHashCode instead of Arrays#equals/hashCode

[ https://issues.apache.org/jira/browse/CALCITE-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844661#comment-16844661 ] Stamatis Zampetakis commented on CALCITE-3021: -- I think we should rephrase the JIRA

[jira] [Comment Edited] (CALCITE-2921) nullif(null,y) throws exception in verification

[ https://issues.apache.org/jira/browse/CALCITE-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844657#comment-16844657 ] Hongze Zhang edited comment on CALCITE-2921 at 5/21/19 9:09 AM: Is

[jira] [Commented] (CALCITE-2921) nullif(null,y) throws exception in verification

[ https://issues.apache.org/jira/browse/CALCITE-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844657#comment-16844657 ] Hongze Zhang commented on CALCITE-2921: --- Is functionality of the new added method

[jira] [Commented] (CALCITE-2979) Add a block-based nested loop join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844641#comment-16844641 ] Khawla Mouhoubi commented on CALCITE-2979: -- After discussing the matter with [~zabetak] and

[jira] [Commented] (CALCITE-1126) Add "&" operation

[ https://issues.apache.org/jira/browse/CALCITE-1126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16844626#comment-16844626 ] pingle wang commented on CALCITE-1126: -- [~julianhyde] need support this? > Add "&" operation >

[jira] [Resolved] (CALCITE-3067) Splunk adapter cannot parse right session keys from Splunk 7.2

[ https://issues.apache.org/jira/browse/CALCITE-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang resolved CALCITE-3067. --- Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3067) Splunk adapter cannot parse right session keys from Splunk 7.2

[ https://issues.apache.org/jira/browse/CALCITE-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-3067: -- Fix Version/s: (was: next) 1.20.0 > Splunk adapter cannot parse right

[jira] [Updated] (CALCITE-3067) Splunk adapter cannot parse right session keys from Splunk 7.2

[ https://issues.apache.org/jira/browse/CALCITE-3067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-3067: -- Summary: Splunk adapter cannot parse right session keys from Splunk 7.2 (was: Splunk