[jira] [Commented] (CALCITE-4040) When an aggregate function does not support roll up, materialization recognition should fail and return the original relnode instead of throwing an exception.

2020-06-08 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128917#comment-17128917 ] xzh_dz commented on CALCITE-4040: - [~julianhyde]Thanks. I've updated the title and desc

[jira] [Commented] (CALCITE-4053) RexSimplify should not pass exprs containing non-const subExprs to RexExecutor

2020-06-08 Thread Shuo Cheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128916#comment-17128916 ] Shuo Cheng commented on CALCITE-4053: - PR: [https://github.com/apache/calcite/pull/

[jira] [Updated] (CALCITE-4040) When an aggregate function does not support roll up, materialization recognition should fail and return the original relnode instead of throwing an exception.

2020-06-08 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4040: Description: When i try to rollup some SqlAggFunctions in my project,I find something wrong. A case can b

[jira] [Updated] (CALCITE-4040) When an aggregate function does not support roll up, materialization recognition should fail and return the original relnode instead of throwing an exception.

2020-06-08 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4040: Summary: When an aggregate function does not support roll up, materialization recognition should fail and

[jira] [Updated] (CALCITE-4053) RexSimplify should not pass exprs containing non-const subExprs to RexExecutor

2020-06-08 Thread Shuo Cheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shuo Cheng updated CALCITE-4053: Summary: RexSimplify should not pass exprs containing non-const subExprs to RexExecutor (was: Re

[jira] [Assigned] (CALCITE-4053) RexSimplify should not pass exprs containing non-const subExprs to RexExecutor

2020-06-08 Thread Shuo Cheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shuo Cheng reassigned CALCITE-4053: --- Assignee: Shuo Cheng > RexSimplify should not pass exprs containing non-const subExprs to

[jira] [Created] (CALCITE-4053) RexSimplify should not pass exprs containing non-const subExprs to RexExecutor#reduce

2020-06-08 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-4053: --- Summary: RexSimplify should not pass exprs containing non-const subExprs to RexExecutor#reduce Key: CALCITE-4053 URL: https://issues.apache.org/jira/browse/CALCITE-4053

[jira] [Commented] (CALCITE-4052) Enable Top-down Optimization

2020-06-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128824#comment-17128824 ] Haisheng Yuan commented on CALCITE-4052: +1, thanks! > Enable Top-down Optimiz

[jira] [Commented] (CALCITE-4031) Remove code to be removed before 1.24

2020-06-08 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128765#comment-17128765 ] Danny Chen commented on CALCITE-4031: - A following up fix in [8dec7ba|https://gith

[jira] [Updated] (CALCITE-4040) When an aggregate function does not support roll up, materialization recognition should fail, returning the original relnode instead of throwing an exception.

2020-06-08 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4040: Summary: When an aggregate function does not support roll up, materialization recognition should fail, re

[jira] [Updated] (CALCITE-4040) An aggregate function that does not support roll up throws an exception when it is rolled up

2020-06-08 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4040: Description: When i try to rollup some SqlAggFunctions in my project,I find something wrong. A case can b

[jira] [Assigned] (CALCITE-4030) Assert error during top-down optimization with Project/Filter Traits passdown and derivation

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned CALCITE-4030: - Assignee: Haisheng Yuan > Assert error during top-down optimization with Project/Filter Traits

[jira] [Commented] (CALCITE-4052) Enable Top-down Optimization

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128761#comment-17128761 ] Rui Wang commented on CALCITE-4052: --- Also tries to make this JIRA as an umbrella to c

[jira] [Created] (CALCITE-4052) Enable Top-down Optimization

2020-06-08 Thread Rui Wang (Jira)
Rui Wang created CALCITE-4052: - Summary: Enable Top-down Optimization Key: CALCITE-4052 URL: https://issues.apache.org/jira/browse/CALCITE-4052 Project: Calcite Issue Type: Task Repor

[jira] [Resolved] (CALCITE-4041) Implement trait propagation for EnumerableCorrelate

2020-06-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4041. Resolution: Fixed Fixed in  [https://github.com/apache/calcite/commit/61cf2bf30d0496cf795

[jira] [Commented] (CALCITE-4051) SESSION TVF Optimizations

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128728#comment-17128728 ] Rui Wang commented on CALCITE-4051: --- [~apilloud] Yes! > SESSION TVF Optimizations >

[jira] [Closed] (CALCITE-4051) SESSION TVF Optimizations

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed CALCITE-4051. - Resolution: Invalid > SESSION TVF Optimizations > - > > Key: CA

[jira] [Commented] (CALCITE-4051) SESSION TVF Optimizations

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128726#comment-17128726 ] Rui Wang commented on CALCITE-4051: --- Sorry I created this Jira for a wrong project.

[jira] [Commented] (CALCITE-4051) SESSION TVF Optimizations

2020-06-08 Thread Andrew Pilloud (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128725#comment-17128725 ] Andrew Pilloud commented on CALCITE-4051: - Did you mean to file this on Beam?

[jira] [Updated] (CALCITE-4051) SESSION TVF Optimizations

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated CALCITE-4051: -- Summary: SESSION TVF Optimizations (was: TVF Session Optimizations) > SESSION TVF Optimizations > --

[jira] [Created] (CALCITE-4051) TVF Session Optimizations

2020-06-08 Thread Rui Wang (Jira)
Rui Wang created CALCITE-4051: - Summary: TVF Session Optimizations Key: CALCITE-4051 URL: https://issues.apache.org/jira/browse/CALCITE-4051 Project: Calcite Issue Type: Improvement R

[jira] [Commented] (CALCITE-4050) Traits Propagation for EnumerableMergeJoin Produces Incorrect Result

2020-06-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128722#comment-17128722 ] Haisheng Yuan commented on CALCITE-4050: The 1-1 mapping is OK, the problem is

[jira] [Commented] (CALCITE-4048) Allow NULL in IN clause to be converted to OR

2020-06-08 Thread Maytas Monsereenusorn (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128719#comment-17128719 ] Maytas Monsereenusorn commented on CALCITE-4048: [~julianhyde] I don't

[jira] [Resolved] (CALCITE-4007) MergeJoin collation check should not be limited to join key's order

2020-06-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4007. Fix Version/s: 1.24.0 Resolution: Fixed Fixed in  [https://github.com/apache/calci

[jira] [Resolved] (CALCITE-4050) Traits Propagation for EnumerableMergeJoin Produces Incorrect Result

2020-06-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4050. Fix Version/s: 1.24.0 Resolution: Fixed Fixed in  [https://github.com/apache/calci

[jira] [Resolved] (CALCITE-4012) Implement trait propagation for EnumerableHashJoin and EnumerableNestedLoopJoin

2020-06-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4012. Resolution: Fixed Fixed in  [https://github.com/apache/calcite/commit/eedd40bea825e0a00f5

[jira] [Commented] (CALCITE-4048) Allow NULL in IN clause to be converted to OR

2020-06-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128708#comment-17128708 ] Julian Hyde commented on CALCITE-4048: -- Might be a duplicate of CALCITE-2696. > A

[jira] [Commented] (CALCITE-4040) An aggregate function that does not support roll up throws an exception when it is rolled up

2020-06-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128693#comment-17128693 ] Julian Hyde commented on CALCITE-4040: -- So, can you describe in one sentence what

[jira] [Comment Edited] (CALCITE-4050) Traits Propagation for EnumerableMergeJoin Produces Incorrect Result

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128493#comment-17128493 ] Rui Wang edited comment on CALCITE-4050 at 6/8/20, 6:06 PM:

[jira] [Comment Edited] (CALCITE-4050) Traits Propagation for EnumerableMergeJoin Produces Incorrect Result

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128493#comment-17128493 ] Rui Wang edited comment on CALCITE-4050 at 6/8/20, 6:06 PM:

[jira] [Commented] (CALCITE-4050) Traits Propagation for EnumerableMergeJoin Produces Incorrect Result

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17128493#comment-17128493 ] Rui Wang commented on CALCITE-4050: --- Yes it is valid. To solve it, the tricky part is

[jira] [Updated] (CALCITE-4050) Traits Propagation for EnumerableMergeJoin Produces Incorrect Result

2020-06-08 Thread Jinpeng Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinpeng Wu updated CALCITE-4050: Description: In EnumerableMergeJoin's deriveTraits method, it uses a Map to record mapping from

[jira] [Created] (CALCITE-4050) Traits Propagation for EnumerableMergeJoin Produces Incorrect Result

2020-06-08 Thread Jinpeng Wu (Jira)
Jinpeng Wu created CALCITE-4050: --- Summary: Traits Propagation for EnumerableMergeJoin Produces Incorrect Result Key: CALCITE-4050 URL: https://issues.apache.org/jira/browse/CALCITE-4050 Project: Calcite