[jira] [Created] (CALCITE-3296) Decorrelator gives empty result after decorrelating sort rel with null offset and fetch

2019-08-26 Thread Juhwan Kim (Jira)
Juhwan Kim created CALCITE-3296: --- Summary: Decorrelator gives empty result after decorrelating sort rel with null offset and fetch Key: CALCITE-3296 URL: https://issues.apache.org/jira/browse/CALCITE-3296

[jira] [Commented] (CALCITE-3296) Decorrelator gives empty result after decorrelating sort rel with null offset and fetch

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916059#comment-16916059 ] Julian Hyde commented on CALCITE-3296: -- Can you please link to the fix that caused this? >

[jira] [Updated] (CALCITE-3193) Move Uncollect from LogicalPigRelBuilder to RelBuilder

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3193: - Description: {{Uncollect}} is a rarely used sub-class of {{RelNode}}, but it should have a

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

2019-08-26 Thread Khai Tran (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916092#comment-16916092 ] Khai Tran commented on CALCITE-3122: [~julianhyde] Aslo, I created MULTISET_PROJECTION operator and

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

2019-08-26 Thread Khai Tran (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916197#comment-16916197 ] Khai Tran commented on CALCITE-3122: Ok, created CALCITE-3297 for that and updated the comment. I

[jira] [Updated] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3280: - Fix Version/s: 1.21.0 > Cannot parse query REGEXP_REPLACE in Redshift >

[jira] [Assigned] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3280: Assignee: Julian Hyde > Cannot parse query REGEXP_REPLACE in Redshift >

[jira] [Commented] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916079#comment-16916079 ] Julian Hyde commented on CALCITE-3280: -- Reviewing now. > Cannot parse query REGEXP_REPLACE in

[jira] [Updated] (CALCITE-3193) Add RelBuilder.uncollect method, and interface UncollectFactory, to instantiate Uncollect

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3193: - Summary: Add RelBuilder.uncollect method, and interface UncollectFactory, to instantiate

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916028#comment-16916028 ] Julian Hyde commented on CALCITE-3122: -- Houston, we have a problem. I have partially squashed and

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

2019-08-26 Thread Khai Tran (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916057#comment-16916057 ] Khai Tran commented on CALCITE-3122: [~julianhyde] and [~IhorHuzenko]: let me try to see if I can

[jira] [Commented] (CALCITE-3288) linq4j: support Set literals

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916066#comment-16916066 ] Julian Hyde commented on CALCITE-3288: -- Please add a description. Why are there two PRs? I am

[jira] [Comment Edited] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916028#comment-16916028 ] Julian Hyde edited comment on CALCITE-3122 at 8/26/19 6:27 PM: --- Houston,

[jira] [Updated] (CALCITE-3296) Decorrelator gives empty result after decorrelating sort rel with null offset and fetch

2019-08-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3296: Labels: pull-request-available (was: ) > Decorrelator gives empty result after

[jira] [Commented] (CALCITE-3296) Decorrelator gives empty result after decorrelating sort rel with null offset and fetch

2019-08-26 Thread Juhwan Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916095#comment-16916095 ] Juhwan Kim commented on CALCITE-3296: - [~julianhyde] Yes. Here is the link for the

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916176#comment-16916176 ] Julian Hyde commented on CALCITE-3122: -- I don't like TODOs. They rarely get done, and the users

[jira] [Updated] (CALCITE-3260) Add a public API for evaluating linq4j Expression nodes

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3260: - Summary: Add a public API for evaluating linq4j Expression nodes (was: Add support of

[jira] [Commented] (CALCITE-3293) Add strcmp function

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916075#comment-16916075 ] Julian Hyde commented on CALCITE-3293: -- Please add description. Please start JIRA case one-line

[jira] [Created] (CALCITE-3297) PigToSqlAggregateRule should be applied on multi-set projection to produce an optimal plan

2019-08-26 Thread Khai Tran (Jira)
Khai Tran created CALCITE-3297: -- Summary: PigToSqlAggregateRule should be applied on multi-set projection to produce an optimal plan Key: CALCITE-3297 URL: https://issues.apache.org/jira/browse/CALCITE-3297

[jira] [Commented] (CALCITE-3260) Add a public API for evaluating linq4j Expression nodes

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3260?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916056#comment-16916056 ] Julian Hyde commented on CALCITE-3260: -- Reviewing now. > Add a public API for evaluating linq4j

[jira] [Assigned] (CALCITE-3260) Add a public API for evaluating linq4j Expression nodes

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3260: Assignee: Julian Hyde > Add a public API for evaluating linq4j Expression nodes >

[jira] [Updated] (CALCITE-3260) Add a public API for evaluating linq4j Expression nodes

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3260: - Fix Version/s: 1.21.0 > Add a public API for evaluating linq4j Expression nodes >

[jira] [Commented] (CALCITE-3288) linq4j: support Set literals

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916069#comment-16916069 ] Julian Hyde commented on CALCITE-3288: -- Ah, I know. The hashCode of Integer is the integer itself.

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

2019-08-26 Thread Khai Tran (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916089#comment-16916089 ] Khai Tran commented on CALCITE-3122: The failed test is not critical. The reason is somehow CALCITE

[jira] [Updated] (CALCITE-2772) Support varargs for user-defined functions (UDFs)

2019-08-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2772: Labels: pull-request-available (was: ) > Support varargs for user-defined functions

[jira] [Resolved] (CALCITE-3283) RelSubSet's best is not existed in the set

2019-08-26 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3283. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Comment Edited] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

2019-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916089#comment-16916089 ] Julian Hyde edited comment on CALCITE-3122 at 8/27/19 3:18 AM: --- The

[jira] [Updated] (CALCITE-3293) Add strcmp function

2019-08-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3293: Labels: pull-request-available (was: ) > Add strcmp function > --- > >

[jira] [Updated] (CALCITE-3290) evaluate in AbstractNode

2019-08-26 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-3290: Description: we could implement the expressions evaluate in AbstractNode directly. > evaluate in

[jira] [Created] (CALCITE-3293) Add strcmp function

2019-08-26 Thread xzh_dz (Jira)
xzh_dz created CALCITE-3293: --- Summary: Add strcmp function Key: CALCITE-3293 URL: https://issues.apache.org/jira/browse/CALCITE-3293 Project: Calcite Issue Type: Improvement Reporter:

[jira] [Updated] (CALCITE-3293) Add strcmp function

2019-08-26 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-3293: Description: Add strcmp function. (was: Add strcmp function) Priority: Minor (was: Major) > Add

[jira] [Resolved] (CALCITE-3210) JDBC adapter should generate "CAST(NULL AS type)" rather than "NULL"

2019-08-26 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3210. - Fix Version/s: (was: next) 1.21.0 Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-3294) Implement FINAL Clause for MATCH_RECOGNIZE

2019-08-26 Thread Julian Feinauer (Jira)
Julian Feinauer created CALCITE-3294: Summary: Implement FINAL Clause for MATCH_RECOGNIZE Key: CALCITE-3294 URL: https://issues.apache.org/jira/browse/CALCITE-3294 Project: Calcite Issue

[jira] [Updated] (CALCITE-3290) evaluate in AbstractNode

2019-08-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3290: Labels: pull-request-available (was: ) > evaluate in AbstractNode >

[jira] [Updated] (CALCITE-3243) Incomplete validation of operands in JSON functions

2019-08-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3243: Labels: pull-request-available (was: ) > Incomplete validation of operands in JSON

[jira] [Commented] (CALCITE-3294) Implement FINAL Clause for MATCH_RECOGNIZE

2019-08-26 Thread Julian Feinauer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3294?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915742#comment-16915742 ] Julian Feinauer commented on CALCITE-3294: -- [~julianhyde] I could imagine working on that

[jira] [Commented] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

2019-08-26 Thread Lai Zhou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915526#comment-16915526 ] Lai Zhou commented on CALCITE-3284: --- [~rubenql]， Did Calcite already support semi join/anti join

[jira] [Commented] (CALCITE-482) Implement sql and planner hints

2019-08-26 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915532#comment-16915532 ] Danny Chan commented on CALCITE-482: Thanks, [~hyuan] and [~Chunwei Lei] i have attached the design

[jira] [Commented] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

2019-08-26 Thread Lai Zhou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915531#comment-16915531 ] Lai Zhou commented on CALCITE-3284: --- [~rubenql], Since Calcite can't support `semi join` or `anti

[jira] [Updated] (CALCITE-3289) Disable test pending fix for Wikipedia format change

2019-08-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3289: Labels: pull-request-available (was: ) > Disable test pending fix for Wikipedia format

[jira] [Commented] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

2019-08-26 Thread Lai Zhou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915562#comment-16915562 ] Lai Zhou commented on CALCITE-3284: --- yes, you're right. I have pushed a new commit, which resolved

[jira] [Issue Comment Deleted] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

2019-08-26 Thread Lai Zhou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-3284: -- Comment: was deleted (was: [~rubenql]， Did Calcite already support semi join/anti join keywords? I

[jira] [Commented] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

2019-08-26 Thread Ruben Quesada Lopez (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915539#comment-16915539 ] Ruben Quesada Lopez commented on CALCITE-3284: -- [~hhlai1990], you can create the test

[jira] [Comment Edited] (CALCITE-3284) Enumerable hash semijoin / antijoin support non-equi join conditions

2019-08-26 Thread Ruben Quesada Lopez (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16915539#comment-16915539 ] Ruben Quesada Lopez edited comment on CALCITE-3284 at 8/26/19 7:39 AM:

[jira] [Updated] (CALCITE-3289) Disable test pending fix for Wikipedia format change

2019-08-26 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-3289: Description: !image-2019-08-24-20-35-39-763.png|width=522,height=112!

[jira] [Created] (CALCITE-3295) Aggregate call name lost in serialized json string.

2019-08-26 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3295: Summary: Aggregate call name lost in serialized json string. Key: CALCITE-3295 URL: https://issues.apache.org/jira/browse/CALCITE-3295 Project: Calcite

[jira] [Updated] (CALCITE-3295) Aggregate call name lost in serialized json string.

2019-08-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3295: Labels: pull-request-available (was: ) > Aggregate call name lost in serialized json