[jira] [Resolved] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

2022-09-07 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3505. Resolution: Cannot Reproduce > Infinite matching of FilterProjectTransposeRule causes

[jira] [Commented] (CALCITE-4705) Support hints like /*+ skewjoin(a(c0, c1)) */

2022-07-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17564604#comment-17564604 ] Haisheng Yuan commented on CALCITE-4705: I don't know any other databases that support skew

[jira] [Resolved] (CALCITE-5000) Expand rule of `AGGREGATE_REDUCE_FUNCTIONS`, when arg of agg-call is in the aggregate's group

2022-04-14 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-5000. Fix Version/s: 1.30.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-5032) The unexpected behavior on method RelOptUtil#splitJoinCondition

2022-04-14 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-5032. Fix Version/s: 1.30.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-4542) Suboptimal plan is chosen when TopDownRuleDriver is enabled

2022-03-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17502791#comment-17502791 ] Haisheng Yuan commented on CALCITE-4542: Hi [~korlov], thank you for providing the detailed

[jira] [Commented] (CALCITE-4774) When predicate conditions are equivalent, materialized view recognition fails.

2021-10-14 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17428655#comment-17428655 ] Haisheng Yuan commented on CALCITE-4774: Yes, sorry for the confusion, I will ask for code

[jira] [Commented] (CALCITE-4817) Expand SubstitutionVisitor of Aggregate with max/min, which column is the group by list of target

2021-10-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17426404#comment-17426404 ] Haisheng Yuan commented on CALCITE-4817: Reverted the previous commit. > Expand

[jira] [Reopened] (CALCITE-4817) Expand SubstitutionVisitor of Aggregate with max/min, which column is the group by list of target

2021-10-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reopened CALCITE-4817: > Expand SubstitutionVisitor of Aggregate with max/min, which column is the > group by list

[jira] [Updated] (CALCITE-4817) Expand SubstitutionVisitor of Aggregate with max/min, which column is the group by list of target

2021-10-08 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4817: --- Fix Version/s: (was: 1.28.0) > Expand SubstitutionVisitor of Aggregate with max/min,

[jira] [Updated] (CALCITE-4817) Expand SubstitutionVisitor of Aggregate with max/min, which column is the group by list of target

2021-10-05 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4817: --- Summary: Expand SubstitutionVisitor of Aggregate with max/min, which column is the group

[jira] [Resolved] (CALCITE-4817) Expand SubstitutionVisitor of Aggregate with max/min, which column is he group by list of target

2021-10-05 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4817. Fix Version/s: 1.28.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-4177) Throw exception when deserialize SqlOperator fails, do not return null

2021-09-20 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4177. Fix Version/s: 1.28.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-4774) When predicate conditions are equivalent, materialized view recognition fails.

2021-09-17 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17416969#comment-17416969 ] Haisheng Yuan commented on CALCITE-4774: Hi [~nobigo], I checked the code again, they are not

[jira] [Resolved] (CALCITE-4774) When predicate conditions are equivalent, materialized view recognition fails.

2021-09-17 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4774. Fix Version/s: 1.28.0 Resolution: Fixed Fixed in

[jira] [Deleted] (CALCITE-4769) Does Dental Care Important? Check This Out!

2021-09-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan deleted CALCITE-4769: --- > Does Dental Care Important? Check This Out! > --- >

[jira] [Commented] (CALCITE-4769) Does Dental Care Important? Check This Out!

2021-09-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17413596#comment-17413596 ] Haisheng Yuan commented on CALCITE-4769: Yes, I will completely delete it. Nor sure how to ban

[jira] [Closed] (CALCITE-4769) Does Dental Care Important? Check This Out!

2021-09-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-4769. -- Resolution: Invalid > Does Dental Care Important? Check This Out! >

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

2021-09-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17412755#comment-17412755 ] Haisheng Yuan commented on CALCITE-4704: OK, cancelling my -1. Change it to +1. :) > Log

[jira] [Commented] (CALCITE-4741) AbstractRelNode#getId can overflow into a negative value causing CompileException in certain Enumerable implement methods

2021-08-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17401885#comment-17401885 ] Haisheng Yuan commented on CALCITE-4741: Kind of related with CALCITE-3879. >

[jira] [Comment Edited] (CALCITE-4652) AggregateExpandDistinctAggregatesRule must cast top aggregates to original type

2021-08-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17398286#comment-17398286 ] Haisheng Yuan edited comment on CALCITE-4652 at 8/12/21, 8:49 PM: --

[jira] [Resolved] (CALCITE-4652) AggregateExpandDistinctAggregatesRule must cast top aggregates to original type

2021-08-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-4652. Resolution: Fixed Fixed inĀ 

[jira] [Reopened] (CALCITE-4726) Add support for filters in AggregateExpandWithinDistinctRule

2021-08-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reopened CALCITE-4726: > Add support for filters in AggregateExpandWithinDistinctRule >

[jira] [Issue Comment Deleted] (CALCITE-4726) Add support for filters in AggregateExpandWithinDistinctRule

2021-08-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4726: --- Comment: was deleted (was: Fixed in

[jira] [Updated] (CALCITE-4726) Add support for filters in AggregateExpandWithinDistinctRule

2021-08-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4726: --- Fix Version/s: (was: 1.28.0) > Add support for filters in

[jira] [Resolved] (CALCITE-4726) Add support for filters in AggregateExpandWithinDistinctRule

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

[jira] [Commented] (CALCITE-4729) Column in CTE should be ambiguous

2021-08-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17398146#comment-17398146 ] Haisheng Yuan commented on CALCITE-4729: Yeah, makes sense. > Column in CTE should be

[jira] [Commented] (CALCITE-4712) Add RelHashDistribution

2021-08-02 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17391968#comment-17391968 ] Haisheng Yuan commented on CALCITE-4712: Yes, you are right. It is kind of randomize or round

[jira] [Commented] (CALCITE-4712) Add RelHashDistribution

2021-08-02 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17391838#comment-17391838 ] Haisheng Yuan commented on CALCITE-4712: (1, null) and (2, null) will have different hash

[jira] [Commented] (CALCITE-4712) Add RelHashDistribution

2021-08-02 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17391825#comment-17391825 ] Haisheng Yuan commented on CALCITE-4712: Thanks for commenting, Julian. * The class will

[jira] [Updated] (CALCITE-4712) Add RelHashDistribution

2021-07-31 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-4712: --- Description: Add RelHashDistribution. The hash distribution should have the following

[jira] [Created] (CALCITE-4712) Add RelHashDistribution

2021-07-31 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-4712: -- Summary: Add RelHashDistribution Key: CALCITE-4712 URL: https://issues.apache.org/jira/browse/CALCITE-4712 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-4705) calcite should support hint like /*+ skewjoin(a(c0, c1)) */

2021-07-27 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17388412#comment-17388412 ] Haisheng Yuan commented on CALCITE-4705: Yes, +1 for this hint. > calcite should support hint

[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=17388245#comment-17388245 ] Haisheng Yuan commented on CALCITE-4704: For complicated queries, i.e. tpcds queries, the

[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=17388241#comment-17388241 ] Haisheng Yuan commented on CALCITE-4704: I would suggest logging the matched partial tree only,

[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=17387545#comment-17387545 ] Haisheng Yuan commented on CALCITE-4677: [~chenz...@mail2.sysu.edu.com] sorry to reply you

[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=17387518#comment-17387518 ] Haisheng Yuan commented on CALCITE-3181: Yeah, with "row()" the transformation should work.

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

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

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

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

[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=17377705#comment-17377705 ] Haisheng Yuan commented on CALCITE-4677: Rule matches on physical operators are prohibited. You

[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=17377683#comment-17377683 ] Haisheng Yuan commented on CALCITE-3181: Yes, they are quite similar with each other. There are

[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=17377666#comment-17377666 ] Haisheng Yuan commented on CALCITE-4681: The problem of matching based on traits is that it

[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=17377558#comment-17377558 ] Haisheng Yuan commented on CALCITE-4681: [~chenz...@mail2.sysu.edu.com] Use RelSubset with the

[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

[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] [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=17376239#comment-17376239 ] Haisheng Yuan commented on CALCITE-4677: We prohibited rule matching on physical operators on

[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

[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=17357728#comment-17357728 ] Haisheng Yuan commented on CALCITE-4638: Yes, I agree, we need to improve that too. > Volcano

[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

[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=17356914#comment-17356914 ] Haisheng Yuan commented on CALCITE-4634: I doubt whether it is worth the extra optimization for

[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

[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=17326185#comment-17326185 ] Haisheng Yuan commented on CALCITE-4549: I don't remember we had seen issue with IN query like

[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=17326183#comment-17326183 ] Haisheng Yuan commented on CALCITE-4561: Nice finding. it is better to generate not_null filter

[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=17326121#comment-17326121 ] Haisheng Yuan commented on CALCITE-4560: [~Chunwei Lei] Can you take a look? you might be

[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=17326073#comment-17326073 ] Haisheng Yuan commented on CALCITE-4557: But if "hiredate" is not in the output columns, or not

[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=17326069#comment-17326069 ] Haisheng Yuan commented on CALCITE-4557: I don't think it is necessary to simplify "ORDER BY

[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=17325482#comment-17325482 ] Haisheng Yuan commented on CALCITE-4557: {quote} I doubt that a 5-key sort is significantly

[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=17325474#comment-17325474 ] Haisheng Yuan commented on CALCITE-4577: See comments in CALCITE-4578, since 1.24.0, the issue

[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=17325474#comment-17325474 ] Haisheng Yuan edited comment on CALCITE-4577 at 4/20/21, 4:54 AM: -- See

[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=17325468#comment-17325468 ] Haisheng Yuan commented on CALCITE-4578: {quote} The best plan for your query should perhaps be

[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=17325465#comment-17325465 ] Haisheng Yuan edited comment on CALCITE-4578 at 4/20/21, 4:31 AM: -- Hi

[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=17325465#comment-17325465 ] Haisheng Yuan commented on CALCITE-4578: Hi [~Aron.tao], which version are you using? According

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

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

[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=17324123#comment-17324123 ] Haisheng Yuan commented on CALCITE-4559: Thanks Julian for the proposal, I will take a look. >

[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=17246350#comment-17246350 ] Haisheng Yuan commented on CALCITE-4432: Hmm, since which version? > When the RelNode's input

[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=17245499#comment-17245499 ] Haisheng Yuan commented on CALCITE-4427: +1 to comply with ISO standard SQL. > Make SUBSTRING

[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=17229718#comment-17229718 ] Haisheng Yuan commented on CALCITE-4386: Sorry, I still don't get it. Can you add a test case

[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=17229641#comment-17229641 ] Haisheng Yuan commented on CALCITE-4386: AbstractRelNode has default implementation. Do we

[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=17211827#comment-17211827 ] Haisheng Yuan commented on CALCITE-3679: [~ritesh.kapoor] We appreciate your contribution and

[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-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=17211770#comment-17211770 ] Haisheng Yuan commented on CALCITE-4027: [~amaliujia] Can you continue on this JIRA? It will be

[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=17211433#comment-17211433 ] Haisheng Yuan commented on CALCITE-4034: Hi [~neoremind], 1.26.0 is already released. We will

[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=17211430#comment-17211430 ] Haisheng Yuan commented on CALCITE-4290: The cost model doesn't take column width into account,

[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

[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=17203014#comment-17203014 ] Haisheng Yuan commented on CALCITE-3841: Hi [~rubenql], thanks for asking. I have been busy

[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=17182820#comment-17182820 ] Haisheng Yuan commented on CALCITE-4027: [~xzh_dz] Are you still working on this issue and

[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

[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=17176726#comment-17176726 ] Haisheng Yuan commented on CALCITE-3916: Thanks for your detailed explanation., [~rubenql]! We

[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=17175077#comment-17175077 ] Haisheng Yuan commented on CALCITE-3916: thanks for reporting, [~rubenql]. how is the scan

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

2020-07-29 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

[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

[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

[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

[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

[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=17164144#comment-17164144 ] Haisheng Yuan commented on CALCITE-4032: With this change, the CalcMergeRule won't match

[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=17162963#comment-17162963 ] Haisheng Yuan commented on CALCITE-4115: [~danny0405] You might want to refrain from committing

[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=17162940#comment-17162940 ] Haisheng Yuan commented on CALCITE-4126: [~fan_li_ya] Feel feel to pick it up. Thanks! >

[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

[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=17160443#comment-17160443 ] Haisheng Yuan commented on CALCITE-4129: Thanks for your quick response, [~julianhyde]. I don't

[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] [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

[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

[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

[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

[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=17157720#comment-17157720 ] Haisheng Yuan commented on CALCITE-4015: Sorry for my late review. Let's do this in 1.25. >

[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

[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:

[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

[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] [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=17157114#comment-17157114 ] Haisheng Yuan commented on CALCITE-3841: Not yet. I will do it after 1.24 is released. >

[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=17157108#comment-17157108 ] Haisheng Yuan commented on CALCITE-3916: Yes, doing the final round review > Support

  1   2   3   4   5   6   7   8   9   10   >