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

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808387#comment-16808387 ] Chunwei Lei edited comment on CALCITE-2965 at 4/3/19 5:51 AM: --

[jira] [Updated] (CALCITE-2976) Improve materialized view rewriting coverage with disjunctive predicates

[ https://issues.apache.org/jira/browse/CALCITE-2976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2976: Labels: pull-request-available (was: ) > Improve materialized view rewriting coverage

[jira] [Commented] (CALCITE-2976) Improve materialized view rewriting coverage with disjunctive predicates

[ https://issues.apache.org/jira/browse/CALCITE-2976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808331#comment-16808331 ] Jesus Camacho Rodriguez commented on CALCITE-2976: -- PR also enables materialization

[jira] [Created] (CALCITE-2976) Improve materialized view rewriting coverage with disjunctive predicates

Jesus Camacho Rodriguez created CALCITE-2976: Summary: Improve materialized view rewriting coverage with disjunctive predicates Key: CALCITE-2976 URL:

[jira] [Updated] (CALCITE-2973) Allow theta joins that has equi keys to be executed using a merge join or hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Summary: Allow theta joins that has equi keys to be executed using a merge join or hash join

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:51 AM: ---

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:51 AM: ---

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:46 AM: ---

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:45 AM: ---

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou edited comment on CALCITE-2973 at 4/3/19 3:45 AM: ---

[jira] [Commented] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808324#comment-16808324 ] Lai Zhou commented on CALCITE-2973: --- [~julianhyde],[~zabetak] , good idea. I just create a new rule

[jira] [Resolved] (CALCITE-2892) Add the JSON_KEYS function

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

[jira] [Updated] (CALCITE-2975) Add the JSON_REMOVE function

[ https://issues.apache.org/jira/browse/CALCITE-2975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-2975: Issue Type: Sub-task (was: New Feature) Parent: CALCITE-2867 > Add the JSON_REMOVE

[jira] [Assigned] (CALCITE-2975) Add the JSON_REMOVE function

[ https://issues.apache.org/jira/browse/CALCITE-2975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu reassigned CALCITE-2975: --- Assignee: Forward Xu > Add the JSON_REMOVE function > > >

[jira] [Created] (CALCITE-2975) Add the JSON_REMOVE function

Forward Xu created CALCITE-2975: --- Summary: Add the JSON_REMOVE function Key: CALCITE-2975 URL: https://issues.apache.org/jira/browse/CALCITE-2975 Project: Calcite Issue Type: New Feature

[jira] [Commented] (CALCITE-2892) Add the JSON_KEYS function

[ https://issues.apache.org/jira/browse/CALCITE-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808291#comment-16808291 ] Hongze Zhang commented on CALCITE-2892: --- Thank you for taking this, [~x1q1j1]! So far the PR

[jira] [Commented] (CALCITE-2966) Problem with Code Generation

[ https://issues.apache.org/jira/browse/CALCITE-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808289#comment-16808289 ] Danny Chan commented on CALCITE-2966: - The commit is not that complete, i only see 2 files changed

[jira] [Updated] (CALCITE-2973) Allow theta joins to be executed using a merge join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2973: -- Summary: Allow theta joins to be executed using a merge join algorithm (was: Make

[jira] [Commented] (CALCITE-2972) Upgrade jetty to 9.4.15.v20190215

[ https://issues.apache.org/jira/browse/CALCITE-2972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808145#comment-16808145 ] Kevin Risden commented on CALCITE-2972: --- Well removing the deprecations is kicking my butt. Put a

[jira] [Resolved] (CALCITE-2930) IllegalStateException when FilterCorrelateRule matches a SEMI or ANTI Correlate

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

[jira] [Updated] (CALCITE-2930) IllegalStateException when FilterCorrelateRule matches a SEMI or ANTI Correlate

[ https://issues.apache.org/jira/browse/CALCITE-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-2930: - Summary: IllegalStateException when FilterCorrelateRule matches a SEMI or ANTI

[jira] [Comment Edited] (CALCITE-2844) Babel parser should parse PostgreSQL table functions

[ https://issues.apache.org/jira/browse/CALCITE-2844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807878#comment-16807878 ] Hongze Zhang edited comment on CALCITE-2844 at 4/2/19 3:50 PM: --- I've run

[jira] [Closed] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

[ https://issues.apache.org/jira/browse/CALCITE-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-2960. -- Resolution: Duplicate > CalciteCatalogReader use a hard-coding config to get functions >

[jira] [Commented] (CALCITE-2844) Babel parser should parse PostgreSQL table functions

[ https://issues.apache.org/jira/browse/CALCITE-2844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807878#comment-16807878 ] Hongze Zhang commented on CALCITE-2844: --- I've run the two tests and reproduced the failures. The

[jira] [Comment Edited] (CALCITE-2844) Babel parser should parse PostgreSQL table functions

[ https://issues.apache.org/jira/browse/CALCITE-2844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807878#comment-16807878 ] Hongze Zhang edited comment on CALCITE-2844 at 4/2/19 3:48 PM: --- I've run

[jira] [Resolved] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2947. Resolution: Fixed Fix Version/s: 1.20.0 Resolved by patch in

[jira] [Resolved] (CALCITE-2893) Type mismatch assertion error when creating join condition

[ https://issues.apache.org/jira/browse/CALCITE-2893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2893. Resolution: Fixed Fix Version/s: 1.20.0 Resolved by patch in

[jira] [Resolved] (CALCITE-2004) The TableFunction left outer join was improperly translated

[ https://issues.apache.org/jira/browse/CALCITE-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2004. Resolution: Fixed Fix Version/s: 1.20.0 > The TableFunction left outer join was

[jira] [Commented] (CALCITE-2004) The TableFunction left outer join was improperly translated

[ https://issues.apache.org/jira/browse/CALCITE-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807871#comment-16807871 ] Haisheng Yuan commented on CALCITE-2004: Pushed to master, thanks for the review,

[jira] [Updated] (CALCITE-2884) Add the JSON_INSERT,JSON_REPLACE,JSON_SET function

[ https://issues.apache.org/jira/browse/CALCITE-2884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-2884: Description: {{JSON_INSERT(jsondoc}}, _{{path}}_, _{{val}}_[, path, val] )

[jira] [Updated] (CALCITE-2884) Add the JSON_INSERT,JSON_REPLACE,JSON_SET function

[ https://issues.apache.org/jira/browse/CALCITE-2884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-2884: Summary: Add the JSON_INSERT,JSON_REPLACE,JSON_SET function (was: Add the JSON_INSERT function)

[jira] [Commented] (CALCITE-2966) Problem with Code Generation

[ https://issues.apache.org/jira/browse/CALCITE-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807828#comment-16807828 ] Julian Feinauer commented on CALCITE-2966: -- Hey [~danny0405]... the full code is in my fork

[jira] [Commented] (CALCITE-2973) Make EnumerableMergeJoinRule to support a theta join

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807826#comment-16807826 ] Stamatis Zampetakis commented on CALCITE-2973: -- Thanks for working on this [~hhlai1990] ! 

[jira] [Commented] (CALCITE-2967) New rule to remove SemiJoin

[ https://issues.apache.org/jira/browse/CALCITE-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807728#comment-16807728 ] Ruben Quesada Lopez commented on CALCITE-2967: -- In my case, the SemiJoin node can be

[jira] [Assigned] (CALCITE-2967) New rule to remove SemiJoin

[ https://issues.apache.org/jira/browse/CALCITE-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-2967: --- Assignee: Ruben Quesada Lopez (was: Danny Chan) > New rule to remove SemiJoin >

[jira] [Assigned] (CALCITE-2967) New rule to remove SemiJoin

[ https://issues.apache.org/jira/browse/CALCITE-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-2967: --- Assignee: Danny Chan (was: Ruben Quesada Lopez) > New rule to remove SemiJoin >

[jira] [Commented] (CALCITE-2967) New rule to remove SemiJoin

[ https://issues.apache.org/jira/browse/CALCITE-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807684#comment-16807684 ] Danny Chan commented on CALCITE-2967: - What i'm curious about is after decorrelation, an in clause

[jira] [Comment Edited] (CALCITE-2973) Make EnumerableMergeJoinRule to support a theta join

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807393#comment-16807393 ] Lai Zhou edited comment on CALCITE-2973 at 4/2/19 9:28 AM: --- [~julianhyde] ,

[jira] [Comment Edited] (CALCITE-2973) Make EnumerableMergeJoinRule to support a theta join

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807393#comment-16807393 ] Lai Zhou edited comment on CALCITE-2973 at 4/2/19 9:28 AM: --- [~julianhyde] ,

[jira] [Comment Edited] (CALCITE-2973) Make EnumerableMergeJoinRule to support a theta join

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807393#comment-16807393 ] Lai Zhou edited comment on CALCITE-2973 at 4/2/19 9:24 AM: --- [~julianhyde] ,

[jira] [Comment Edited] (CALCITE-2973) Make EnumerableMergeJoinRule to support a theta join

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807393#comment-16807393 ] Lai Zhou edited comment on CALCITE-2973 at 4/2/19 9:24 AM: --- [~julianhyde] ,

[jira] [Comment Edited] (CALCITE-2973) Make EnumerableMergeJoinRule to support a theta join

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807393#comment-16807393 ] Lai Zhou edited comment on CALCITE-2973 at 4/2/19 9:22 AM: --- [~julianhyde] ,

[jira] [Commented] (CALCITE-2966) Problem with Code Generation

[ https://issues.apache.org/jira/browse/CALCITE-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807566#comment-16807566 ] Julian Feinauer commented on CALCITE-2966: -- First, thanks [~danny0405]... are we sure that

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807488#comment-16807488 ] Chunwei Lei commented on CALCITE-1338: -- I will take a look into this since it will cause data

[jira] [Commented] (CALCITE-2004) The TableFunction left outer join was improperly translated

[ https://issues.apache.org/jira/browse/CALCITE-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807463#comment-16807463 ] Julian Hyde commented on CALCITE-2004: -- [~hyuan] +1 nice work, well tested. Go ahead and merge to

[jira] [Comment Edited] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807421#comment-16807421 ] Chunwei Lei edited comment on CALCITE-2754 at 4/2/19 6:08 AM: -- I opened

[jira] [Comment Edited] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807421#comment-16807421 ] Chunwei Lei edited comment on CALCITE-2754 at 4/2/19 6:07 AM: -- I opened

[jira] [Commented] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807421#comment-16807421 ] Chunwei Lei commented on CALCITE-2754: -- I opened