[jira] [Resolved] (CALCITE-3160) Failed to materialize when the aggregate function uses group key

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

[jira] [Commented] (CALCITE-3181) Support limit per group in Window

2019-07-09 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881121#comment-16881121 ] Haisheng Yuan commented on CALCITE-3181: e.g. compute the total page views for

[jira] [Assigned] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

2019-07-09 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned CALCITE-3159: -- Assignee: Forward Xu > Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate

[jira] [Commented] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

2019-07-09 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881684#comment-16881684 ] Haisheng Yuan commented on CALCITE-3159: Sure, thanks! > Distinct can be remov

[jira] [Commented] (CALCITE-3181) Support limit per group in Window

2019-07-09 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881722#comment-16881722 ] Haisheng Yuan commented on CALCITE-3181: {quote} It would make sense to have an

[jira] [Commented] (CALCITE-2978) sorting not applied in subqueries

2019-07-15 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16884987#comment-16884987 ] Haisheng Yuan commented on CALCITE-2978: This is still not a valid case, unless

[jira] [Resolved] (CALCITE-3031) Support for correlated ANY/SOME/ALL sub-query

2019-07-29 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3031. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in https://github.com/apache/calcit

[jira] [Resolved] (CALCITE-3153) Improve testing in TpcdsTest using assertEqual instead of printing results

2019-07-29 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3153. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in https://github.com/apache/calcit

[jira] [Commented] (CALCITE-2624) Add a rule to copy a sort below a join operator

2019-08-02 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16898630#comment-16898630 ] Haisheng Yuan commented on CALCITE-2624: I am neutral on this approach. +0. >

[jira] [Resolved] (CALCITE-3227) IndexOutOfBound when checking candidate parent match's input ordinal in VolcanoRuleCall

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

[jira] [Resolved] (CALCITE-3101) PushDownJoinConditions is not always a valid transformation

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

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

2019-08-07 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16902331#comment-16902331 ] Haisheng Yuan commented on CALCITE-482: --- For hints like {{selectivity}}, a good pl

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

2019-08-07 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16902530#comment-16902530 ] Haisheng Yuan commented on CALCITE-482: --- Is it necessary to support 2 different st

[jira] [Commented] (CALCITE-3089) Deprecate EquiJoin

2019-08-15 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908526#comment-16908526 ] Haisheng Yuan commented on CALCITE-3089: +1 on the tweaks, which make more sens

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-15 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908576#comment-16908576 ] Haisheng Yuan commented on CALCITE-2302: Let me repeat my comment here. My only

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

2019-08-15 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908687#comment-16908687 ] Haisheng Yuan commented on CALCITE-482: --- I think query hints can also do the same

[jira] [Resolved] (CALCITE-3249) Substitution#getRexShuttle does not consider RexLiteral

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

[jira] [Resolved] (CALCITE-3214) Add UnionToUnionRule for materialization matching

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

[jira] [Resolved] (CALCITE-3259) Align 'Property' in the serialized xml string of RelXmlWriter.

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

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-20 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16911921#comment-16911921 ] Haisheng Yuan commented on CALCITE-2302: +1 on the patch, overall. Given the de

[jira] [Resolved] (CALCITE-3262) Refine doc of SubstitutionVisitor.java

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

[jira] [Commented] (CALCITE-3257) RelMetadataQuery cache is not invalidated when log trace is enabled

2019-08-21 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912539#comment-16912539 ] Haisheng Yuan commented on CALCITE-3257: Yes, I do think this is a separate iss

[jira] [Resolved] (CALCITE-3257) RelMetadataQuery cache is not invalidated when log trace is enabled

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

[jira] [Resolved] (CALCITE-3223) Non-RexInputRef may fails the matching of FilterToProjectUnifyRule during 'invert' by mistake.

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

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

2019-08-21 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912893#comment-16912893 ] Haisheng Yuan commented on CALCITE-2973: Sure, will do. > Allow theta joins th

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

2019-08-22 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-3284: -- Summary: Enumerable hash semijoin support non-equi join conditions Key: CALCITE-3284 URL: https://issues.apache.org/jira/browse/CALCITE-3284 Project: Calcite

[jira] [Created] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

2019-08-22 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-3285: -- Summary: EnumerableMergeJoin should support non-equi join conditions Key: CALCITE-3285 URL: https://issues.apache.org/jira/browse/CALCITE-3285 Project: Calcite

[jira] [Resolved] (CALCITE-3204) Implement jps command for OS adapter

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

[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 https://github.com/apache/calcit

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

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

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

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

[jira] [Resolved] (CALCITE-3292) SqlToRelConverter#substituteSubQuery fails with NullPointerException when converting SqlUpdate.

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

[jira] [Resolved] (CALCITE-4105) Replace Pair with Flat2List in RelDigestWriter to improve hash code distribution

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

[jira] [Commented] (CALCITE-3916) Support cascades style top-down driven rule apply

2020-07-13 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17157108#comment-17157108 ] Haisheng Yuan commented on CALCITE-3916: Yes, doing the final round review >

[jira] [Commented] (CALCITE-3841) Change downloads page to use downloads.apache.org

2020-07-13 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17157114#comment-17157114 ] Haisheng Yuan commented on CALCITE-3841: Not yet. I will do it after 1.24 is re

[jira] [Updated] (CALCITE-3841) Change downloads page to use downloads.apache.org

2020-07-13 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3841: --- Fix Version/s: (was: 1.24.0) > Change downloads page to use downloads.apache.org >

[jira] [Resolved] (CALCITE-3916) Support cascades style top-down driven rule apply

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

[jira] [Created] (CALCITE-4122) Support on-demand rule matching

2020-07-14 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-4122: -- Summary: Support on-demand rule matching Key: CALCITE-4122 URL: https://issues.apache.org/jira/browse/CALCITE-4122 Project: Calcite Issue Type: Improvem

[jira] [Updated] (CALCITE-4015) Pass through parent collation request on subset or superset of join keys for EnumerableMergeJoin

2020-07-14 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4015: --- Fix Version/s: (was: 1.24.0) > Pass through parent collation request on subset or super

[jira] [Commented] (CALCITE-4015) Pass through parent collation request on subset or superset of join keys for EnumerableMergeJoin

2020-07-14 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17157720#comment-17157720 ] Haisheng Yuan commented on CALCITE-4015: Sorry for my late review. Let's do thi

[jira] [Created] (CALCITE-4124) Stop invalidating metadata cache in VolcanoRuleCall

2020-07-15 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-4124: -- Summary: Stop invalidating metadata cache in VolcanoRuleCall Key: CALCITE-4124 URL: https://issues.apache.org/jira/browse/CALCITE-4124 Project: Calcite I

[jira] [Resolved] (CALCITE-4124) Stop invalidating metadata cache in VolcanoRuleCall

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

[jira] [Created] (CALCITE-4126) Stackoverflow error when applying JoinCommuteRule

2020-07-15 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-4126: -- Summary: Stackoverflow error when applying JoinCommuteRule Key: CALCITE-4126 URL: https://issues.apache.org/jira/browse/CALCITE-4126 Project: Calcite Iss

[jira] [Resolved] (CALCITE-4127) Remove final from AbstractRelNode#getRelTypeName

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

[jira] [Created] (CALCITE-4129) Support equality check for whole rel plan tree

2020-07-18 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-4129: -- Summary: Support equality check for whole rel plan tree Key: CALCITE-4129 URL: https://issues.apache.org/jira/browse/CALCITE-4129 Project: Calcite Issue

[jira] [Commented] (CALCITE-4129) Support equality check for whole rel plan tree

2020-07-18 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17160443#comment-17160443 ] Haisheng Yuan commented on CALCITE-4129: Thanks for your quick response, [~juli

[jira] [Created] (CALCITE-4131) ERROR message in SqlToRelConverterExtendedTest

2020-07-18 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-4131: -- Summary: ERROR message in SqlToRelConverterExtendedTest Key: CALCITE-4131 URL: https://issues.apache.org/jira/browse/CALCITE-4131 Project: Calcite Issue

[jira] [Commented] (CALCITE-4126) Stackoverflow error when applying JoinCommuteRule

2020-07-22 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17162940#comment-17162940 ] Haisheng Yuan commented on CALCITE-4126: [~fan_li_ya] Feel feel to pick it up.

[jira] [Commented] (CALCITE-4115) Improve the prompt of using SQL keywords for sql parser

2020-07-22 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17162963#comment-17162963 ] Haisheng Yuan commented on CALCITE-4115: [~danny0405] You might want to refrain

[jira] [Commented] (CALCITE-4032) Mark CalcMergeRule as TransformationRule

2020-07-23 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17164144#comment-17164144 ] Haisheng Yuan commented on CALCITE-4032: With this change, the CalcMergeRule wo

[jira] [Updated] (CALCITE-4032) Mark CalcMergeRule as TransformationRule

2020-07-23 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4032: --- Description: Previously it was removed in CALCITE-3997. By marking was:Previously it w

[jira] [Updated] (CALCITE-4032) Mark CalcMergeRule as TransformationRule

2020-07-23 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4032: --- Description: Previously it was removed in CALCITE-3997. By marking CalcMergeRule as Transf

[jira] [Resolved] (CALCITE-4129) Support equality check for whole rel plan tree

2020-07-26 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4129. Fix Version/s: 1.25.0 Resolution: Fixed Fixed in https://github.com/apache/calcit

[jira] [Resolved] (CALCITE-4111) Remove VolcanoPlannerPhase in VolcanoPlanner

2020-07-26 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4111. Fix Version/s: 1.25.0 Resolution: Fixed Fixed in https://github.com/apache/calcit

[jira] [Resolved] (CALCITE-4102) Some improvements to aggregate related operations

2020-07-28 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4102. Fix Version/s: 1.25.0 Resolution: Fixed Fixed in https://github.com/apache/calcit

[jira] [Commented] (CALCITE-3916) Support cascades style top-down driven rule apply

2020-08-10 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17175077#comment-17175077 ] Haisheng Yuan commented on CALCITE-3916: thanks for reporting, [~rubenql]. how

[jira] [Commented] (CALCITE-3916) Support cascades style top-down driven rule apply

2020-08-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17176726#comment-17176726 ] Haisheng Yuan commented on CALCITE-3916: Thanks for your detailed explanation.,

[jira] [Resolved] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

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

[jira] [Commented] (CALCITE-4027) Add -Doverwrite option to SqlToRelTestBase

2020-08-23 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17182820#comment-17182820 ] Haisheng Yuan commented on CALCITE-4027: [~xzh_dz] Are you still working on thi

[jira] [Commented] (CALCITE-3841) Change downloads page to use downloads.apache.org

2020-09-27 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17203014#comment-17203014 ] Haisheng Yuan commented on CALCITE-3841: Hi [~rubenql], thanks for asking. I ha

[jira] [Assigned] (CALCITE-3841) Change downloads page to use downloads.apache.org

2020-09-27 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned CALCITE-3841: -- Assignee: (was: Haisheng Yuan) > Change downloads page to use downloads.apache.o

[jira] [Commented] (CALCITE-4290) Not optimal subqueries due to a "*" in them

2020-10-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17211430#comment-17211430 ] Haisheng Yuan commented on CALCITE-4290: The cost model doesn't take column wid

[jira] [Commented] (CALCITE-4034) Implement a MySQL InnoDB adapter

2020-10-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17211433#comment-17211433 ] Haisheng Yuan commented on CALCITE-4034: Hi [~neoremind], 1.26.0 is already rel

[jira] [Commented] (CALCITE-4027) Add -Doverwrite option to SqlToRelTestBase

2020-10-10 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17211770#comment-17211770 ] Haisheng Yuan commented on CALCITE-4027: [~amaliujia] Can you continue on this

[jira] [Updated] (CALCITE-4027) Add -Doverwrite option to SqlToRelTestBase

2020-10-10 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4027: --- Labels: (was: pull-request-available) > Add -Doverwrite option to SqlToRelTestBase >

[jira] [Commented] (CALCITE-3679) Allow lambda expressions in SQL queries

2020-10-10 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17211827#comment-17211827 ] Haisheng Yuan commented on CALCITE-3679: [~ritesh.kapoor] We appreciate your co

[jira] [Commented] (CALCITE-4386) Support RelShuttle visit specific logical operators

2020-11-10 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229641#comment-17229641 ] Haisheng Yuan commented on CALCITE-4386: AbstractRelNode has default implementa

[jira] [Commented] (CALCITE-4386) Support RelShuttle visit specific logical operators

2020-11-10 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229718#comment-17229718 ] Haisheng Yuan commented on CALCITE-4386: Sorry, I still don't get it. Can you a

[jira] [Commented] (CALCITE-4427) Make SUBSTRING operator comply with ISO standard SQL

2020-12-07 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17245499#comment-17245499 ] Haisheng Yuan commented on CALCITE-4427: +1 to comply with ISO standard SQL. >

[jira] [Commented] (CALCITE-4432) When the RelNode's input is the same subset as the subset node belonged to, not choose this node as best.

2020-12-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17246350#comment-17246350 ] Haisheng Yuan commented on CALCITE-4432: Hmm, since which version? > When the

[jira] [Commented] (CALCITE-4559) Create 'interface RexRule', a modular rewrite for row-expressions

2021-04-16 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17324123#comment-17324123 ] Haisheng Yuan commented on CALCITE-4559: Thanks Julian for the proposal, I will

[jira] [Commented] (CALCITE-4559) Create 'interface RexRule', a modular rewrite for row-expressions

2021-04-18 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17324726#comment-17324726 ] Haisheng Yuan commented on CALCITE-4559: I agree with [~vozerov] that this is a

[jira] [Commented] (CALCITE-4578) redundant HepPlanner#buildFinalPlan when there's no rule fired in the program

2021-04-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325465#comment-17325465 ] Haisheng Yuan commented on CALCITE-4578: Hi [~Aron.tao], which version are you

[jira] [Comment Edited] (CALCITE-4578) redundant HepPlanner#buildFinalPlan when there's no rule fired in the program

2021-04-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325465#comment-17325465 ] Haisheng Yuan edited comment on CALCITE-4578 at 4/20/21, 4:31 AM: ---

[jira] [Commented] (CALCITE-4578) redundant HepPlanner#buildFinalPlan when there's no rule fired in the program

2021-04-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325468#comment-17325468 ] Haisheng Yuan commented on CALCITE-4578: {quote} The best plan for your query s

[jira] [Comment Edited] (CALCITE-4577) RelDigestWriter#done has performance issue when node's inputs is large

2021-04-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325474#comment-17325474 ] Haisheng Yuan edited comment on CALCITE-4577 at 4/20/21, 4:54 AM: ---

[jira] [Commented] (CALCITE-4577) RelDigestWriter#done has performance issue when node's inputs is large

2021-04-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325474#comment-17325474 ] Haisheng Yuan commented on CALCITE-4577: See comments in CALCITE-4578, since 1.

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

2021-04-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325482#comment-17325482 ] Haisheng Yuan commented on CALCITE-4557: {quote} I doubt that a 5-key sort is s

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

2021-04-20 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17326069#comment-17326069 ] Haisheng Yuan commented on CALCITE-4557: I don't think it is necessary to simpl

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

2021-04-20 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17326073#comment-17326073 ] Haisheng Yuan commented on CALCITE-4557: But if "hiredate" is not in the output

[jira] [Commented] (CALCITE-4560) Wrong plan when decorrelating EXISTS subquery with COALESCE in the predicate

2021-04-20 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17326121#comment-17326121 ] Haisheng Yuan commented on CALCITE-4560: [~Chunwei Lei] Can you take a look? yo

[jira] [Commented] (CALCITE-4561) Wrong results for plan with EnumerableHashJoin (semi) on nullable colunms

2021-04-20 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17326183#comment-17326183 ] Haisheng Yuan commented on CALCITE-4561: Nice finding. it is better to generate

[jira] [Commented] (CALCITE-4549) IndexOutOfBoundsException when group view by a sub query

2021-04-20 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17326185#comment-17326185 ] Haisheng Yuan commented on CALCITE-4549: I don't remember we had seen issue wit

[jira] [Resolved] (CALCITE-853) EnumerableAggregate should take advantage of input collation

2021-05-28 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-853. --- Fix Version/s: 1.23.0 Resolution: Fixed We already have it by adding EnumerableSorted

[jira] [Commented] (CALCITE-4634) Improve AggregateProjectPullUpConstantsRule to remove all constant keys

2021-06-03 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17356914#comment-17356914 ] Haisheng Yuan commented on CALCITE-4634: I doubt whether it is worth the extra

[jira] [Created] (CALCITE-4638) Volcano top-down optimizer failed to recognize transformation rule correctly

2021-06-04 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-4638: -- Summary: Volcano top-down optimizer failed to recognize transformation rule correctly Key: CALCITE-4638 URL: https://issues.apache.org/jira/browse/CALCITE-4638 P

[jira] [Commented] (CALCITE-4638) Volcano top-down optimizer failed to recognize transformation rule correctly

2021-06-04 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17357728#comment-17357728 ] Haisheng Yuan commented on CALCITE-4638: Yes, I agree, we need to improve that

[jira] [Resolved] (CALCITE-4638) Volcano top-down optimizer failed to recognize transformation rule correctly

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

[jira] [Commented] (CALCITE-4677) Different physical conventions conversion on new physical node producing

2021-07-06 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17376239#comment-17376239 ] Haisheng Yuan commented on CALCITE-4677: We prohibited rule matching on physica

[jira] [Updated] (CALCITE-4677) Different physical conventions conversion on new physical node producing

2021-07-06 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4677: --- Description: Whenever new physical nodes are on produce, we need to fire rules in case of

[jira] [Updated] (CALCITE-4650) TopDownRuleDriver.DeriveTrait.derive produces wrong AssertionError when registering new nodes

2021-07-06 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4650: --- Description: {{TopDownRuleDriver.DeriveTrait.derive}} asserts that a derived node belongs t

[jira] [Commented] (CALCITE-4681) Rule operand match specific shape with or without RelSubset.class/RelNode.class

2021-07-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17377558#comment-17377558 ] Haisheng Yuan commented on CALCITE-4681: [~chenz...@mail2.sysu.edu.com] Use Rel

[jira] [Commented] (CALCITE-4681) Rule operand match specific shape with or without RelSubset.class/RelNode.class

2021-07-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17377666#comment-17377666 ] Haisheng Yuan commented on CALCITE-4681: The problem of matching based on trait

[jira] [Commented] (CALCITE-3181) Support limit per group in Window

2021-07-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17377683#comment-17377683 ] Haisheng Yuan commented on CALCITE-3181: Yes, they are quite similar with each

[jira] [Commented] (CALCITE-4677) Different physical conventions conversion on new physical node producing

2021-07-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17377705#comment-17377705 ] Haisheng Yuan commented on CALCITE-4677: Rule matches on physical operators are

[jira] [Commented] (CALCITE-3181) Support limit per group in Window

2021-07-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17377857#comment-17377857 ] Haisheng Yuan commented on CALCITE-3181: Yeah, that makes more sense. How does

[jira] [Commented] (CALCITE-4681) Rule operand match specific shape with or without RelSubset.class/RelNode.class

2021-07-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17377858#comment-17377858 ] Haisheng Yuan commented on CALCITE-4681: RelSubset can just work as a replaceme

[jira] [Commented] (CALCITE-3181) Support limit per group in Window

2021-07-26 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17387518#comment-17387518 ] Haisheng Yuan commented on CALCITE-3181: Yeah, with "row()" the transformation

[jira] [Commented] (CALCITE-4677) Different physical conventions conversion on new physical node producing

2021-07-26 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17387545#comment-17387545 ] Haisheng Yuan commented on CALCITE-4677: [~chenz...@mail2.sysu.edu.com] sorry t

[jira] [Commented] (CALCITE-4704) Log produced plan after rule application using explain formatting

2021-07-27 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17388241#comment-17388241 ] Haisheng Yuan commented on CALCITE-4704: I would suggest logging the matched pa

<    1   2   3   4   5   6   7   8   9   10   >