[jira] [Commented] (CALCITE-4800) Add SortToSortUnifyRule in SubstitutionVisitor

2022-01-25 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17482280#comment-17482280 ] xzh_dz commented on CALCITE-4800: - [~wojustme]  you can take it. > Add SortToSortUnifyRule in

[jira] [Commented] (CALCITE-4857) Materialization-Failed, query could be grouping mv's agg-call, when executing mv-match.

2022-01-24 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17481575#comment-17481575 ] xzh_dz commented on CALCITE-4857: - [~wojustme]  agree with [~yanlin-Lynn] ,+1 >

[jira] (CALCITE-4783) RelFieldTrimmer incorrectly drops filter condition

2021-11-10 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783 ] xzh_dz deleted comment on CALCITE-4783: - was (Author: xzh_dz): The [PR|https://github.com/apache/calcite/pull/2605] not link with JIRA.   > RelFieldTrimmer incorrectly drops filter condition

[jira] [Commented] (CALCITE-4783) RelFieldTrimmer incorrectly drops filter condition

2021-11-10 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17442070#comment-17442070 ] xzh_dz commented on CALCITE-4783: - The [PR|https://github.com/apache/calcite/pull/2605] not link with

[jira] [Commented] (CALCITE-4874) Add recursive digest helper method

2021-11-07 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17440156#comment-17440156 ] xzh_dz commented on CALCITE-4874: - It is convenient to call the 'explain' method directly.

[jira] [Commented] (CALCITE-4803) RelNode lost alias after remove Project operator

2021-11-01 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17437104#comment-17437104 ] xzh_dz commented on CALCITE-4803: - [~Chunwei Lei] agree with you, relational algebra should maintain

[jira] [Commented] (CALCITE-3338) Error with executeBatch and preparedStatement.

2021-10-12 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17428017#comment-17428017 ] xzh_dz commented on CALCITE-3338: - Fixed in 

[jira] [Commented] (CALCITE-4849) Query SQL cannot complete materialized view rewrite properly

2021-10-12 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17427675#comment-17427675 ] xzh_dz commented on CALCITE-4849: - [~jhkcool] I tried to reproduce the problem in

[jira] [Updated] (CALCITE-4778) Exchange operator deserialize fail when the RexInput has no RelCollcation

2021-09-27 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4778: Summary: Exchange operator deserialize fail when the RexInput has no RelCollcation (was: Exchange

[jira] [Commented] (CALCITE-4800) Add SortToSortUnifyRule in SubstitutionVisitor

2021-09-27 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421119#comment-17421119 ] xzh_dz commented on CALCITE-4800: - [~wojustme] no, `SortToSortUnifyRule` hasn't been proposed yet.And 

[jira] [Commented] (CALCITE-3588) JDBC adapter should handle join conditions containing IS TRUE, SIMILAR TO etc. when generating SQL

2021-09-27 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421114#comment-17421114 ] xzh_dz commented on CALCITE-3588: - [~julianhyde] [~jinxing6...@126.com] I rerun the unit

[jira] [Commented] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

2021-09-27 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420500#comment-17420500 ] xzh_dz commented on CALCITE-4807: - Materialized view recognition of `Sort operator` has not been

[jira] [Commented] (CALCITE-4803) RelNode lost alias after remove Project operator

2021-09-26 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420419#comment-17420419 ] xzh_dz commented on CALCITE-4803: - [~julianhyde] RelNode lost its alias and their relational algebra

[jira] [Updated] (CALCITE-4779) GroupByList contains constant literal, materialized view recognition failed

2021-09-26 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4779: Summary: GroupByList contains constant literal, materialized view recognition failed (was: GroupSet

[jira] [Commented] (CALCITE-3338) Error with executeBatch and preparedStatement.

2021-09-26 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420220#comment-17420220 ] xzh_dz commented on CALCITE-3338: - [~julianhyde] Thanks for review, I have submitted a

[jira] [Created] (CALCITE-4804) Support Snapshot operator serialization and deserizalization

2021-09-25 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4804: --- Summary: Support Snapshot operator serialization and deserizalization Key: CALCITE-4804 URL: https://issues.apache.org/jira/browse/CALCITE-4804 Project: Calcite

[jira] [Created] (CALCITE-4803) RelNode lost alias after remove Project operator

2021-09-25 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4803: --- Summary: RelNode lost alias after remove Project operator Key: CALCITE-4803 URL: https://issues.apache.org/jira/browse/CALCITE-4803 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-4800) Add SortToSortUnifyRule in SubstitutionVisitor

2021-09-24 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4800: Description: In my project, there are more usage scenarios for materialized view recognition, and the

[jira] [Created] (CALCITE-4800) Add SortToSortUnifyRule in SubstitutionVisitor

2021-09-24 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4800: --- Summary: Add SortToSortUnifyRule in SubstitutionVisitor Key: CALCITE-4800 URL: https://issues.apache.org/jira/browse/CALCITE-4800 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-4794) Arithmetic remainder operator should be simplified

2021-09-23 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4794: --- Summary: Arithmetic remainder operator should be simplified Key: CALCITE-4794 URL: https://issues.apache.org/jira/browse/CALCITE-4794 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2021-09-22 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17418906#comment-17418906 ] xzh_dz commented on CALCITE-3409: - [~jcamachorodriguez] I have updated the code,It does not modify the

[jira] [Commented] (CALCITE-4783) RelFieldTrimmer incorrectly drops filter condition

2021-09-22 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17418549#comment-17418549 ] xzh_dz commented on CALCITE-4783: - [~wojustme] Thanks for comment. It's not `Aggregate group-set`

[jira] [Commented] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2021-09-22 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17418425#comment-17418425 ] xzh_dz commented on CALCITE-3409: - [~zabetak] [~jcamachorodriguez] thanks for review.. I update the

[jira] [Comment Edited] (CALCITE-3583) Support serialized to json and deserialized from json for Exchange relation operator

2021-09-21 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17418385#comment-17418385 ] xzh_dz edited comment on CALCITE-3583 at 9/22/21, 2:41 AM: --- [~julianhyde]

[jira] [Commented] (CALCITE-3583) Support serialized to json and deserialized from json for Exchange relation operator

2021-09-21 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17418385#comment-17418385 ] xzh_dz commented on CALCITE-3583: - [~julianhyde] thanks for review. There is already a PR that

[jira] [Commented] (CALCITE-4786) Facilitate use of graalvm native-image compilation

2021-09-21 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17418381#comment-17418381 ] xzh_dz commented on CALCITE-4786: - It looks like very helpful to Calcite. > Facilitate use of graalvm

[jira] [Updated] (CALCITE-4783) RelFieldTrimmer incorrectly drops filter condition

2021-09-21 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4783: Description: {code:java} // code placeholder org.apache.calcite.test.SqlToRelConverterTest @Test void

[jira] [Commented] (CALCITE-4783) RelFieldTrimmer incorrectly drops filter condition

2021-09-21 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17418377#comment-17418377 ] xzh_dz commented on CALCITE-4783: - Thanks,i have updated the description. > RelFieldTrimmer

[jira] [Commented] (CALCITE-4779) GroupSet contains constant, materialized view recognition failed

2021-09-19 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17417420#comment-17417420 ] xzh_dz commented on CALCITE-4779: - [~julianhyde] Thanks for review.This use case tests that the

[jira] [Updated] (CALCITE-4783) Dropped the predicate condition after RelFieldTrimmer trim the RelNode

2021-09-17 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4783: Description: {code:java} // code placeholder org.apache.calcite.test.SqlToRelConverterTest @Test void

[jira] [Commented] (CALCITE-4783) Dropped the predicate condition after RelFieldTrimmer trim the RelNode

2021-09-17 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17416527#comment-17416527 ] xzh_dz commented on CALCITE-4783: - [~julianhyde] Thanks, In my project, i always use `RelFieldTrimmer`

[jira] [Updated] (CALCITE-4783) Dropped the predicate condition after RelFieldTrimmer trim the RelNode

2021-09-17 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4783: Description: {code:java} // code placeholder org.apache.calcite.test.SqlToRelConverterTest @Test void

[jira] [Updated] (CALCITE-4783) Dropped the predicate condition after RelFieldTrimmer trim the RelNode

2021-09-17 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4783: Description: {code:java} // code placeholder org.apache.calcite.test.SqlToRelConverterTest @Test void

[jira] [Created] (CALCITE-4783) Dropped the predicate condition after RelFieldTrimmer trim the RelNode

2021-09-17 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4783: --- Summary: Dropped the predicate condition after RelFieldTrimmer trim the RelNode Key: CALCITE-4783 URL: https://issues.apache.org/jira/browse/CALCITE-4783 Project: Calcite

[jira] [Comment Edited] (CALCITE-4781) group by index is not support

2021-09-16 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17416010#comment-17416010 ] xzh_dz edited comment on CALCITE-4781 at 9/16/21, 9:39 AM: --- It is not be

[jira] [Commented] (CALCITE-4781) group by index is not support

2021-09-16 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17416010#comment-17416010 ] xzh_dz commented on CALCITE-4781: - It is not be supported,the constant needs to be the corresponding

[jira] [Commented] (CALCITE-4395) Add an interface in RelOptMaterializations to allow registering normalization rules

2021-09-16 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17415980#comment-17415980 ] xzh_dz commented on CALCITE-4395: - In the project, these two PR are very important functions and have

[jira] [Commented] (CALCITE-4395) Add an interface in RelOptMaterializations to allow registering normalization rules

2021-09-16 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17415979#comment-17415979 ] xzh_dz commented on CALCITE-4395: - [~zabetak] It's been a long time. Thank you for your comments.  

[jira] [Commented] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2021-09-16 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17415978#comment-17415978 ] xzh_dz commented on CALCITE-3409: - [~zabetak] thanks for review. * These internally defined rules are

[jira] [Created] (CALCITE-4780) Unable to derive implicit predicate conditions, materialized view recognition failed

2021-09-16 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4780: --- Summary: Unable to derive implicit predicate conditions, materialized view recognition failed Key: CALCITE-4780 URL: https://issues.apache.org/jira/browse/CALCITE-4780

[jira] [Created] (CALCITE-4779) GroupSet contains constant, materialized view recognition failed

2021-09-16 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4779: --- Summary: GroupSet contains constant, materialized view recognition failed Key: CALCITE-4779 URL: https://issues.apache.org/jira/browse/CALCITE-4779 Project: Calcite

[jira] [Commented] (CALCITE-4772) PushProjector assigns incorrect field alias when handling RexCall

2021-09-15 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17415889#comment-17415889 ] xzh_dz commented on CALCITE-4772: - After the SQL optimized, the alias of SQL should be the same, we

[jira] [Commented] (CALCITE-4778) Exchange operator deserialize fail

2021-09-15 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17415857#comment-17415857 ] xzh_dz commented on CALCITE-4778: - https://github.com/apache/calcite/pull/2519 > Exchange operator

[jira] [Created] (CALCITE-4778) Exchange operator deserialize fail

2021-09-15 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4778: --- Summary: Exchange operator deserialize fail Key: CALCITE-4778 URL: https://issues.apache.org/jira/browse/CALCITE-4778 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-4771) change the value of the CAST function to be nullable

2021-09-15 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17415852#comment-17415852 ] xzh_dz commented on CALCITE-4771: - !image-2021-09-16-11-43-55-743.png|width=745,height=363! When I

[jira] [Updated] (CALCITE-4771) change the value of the CAST function to be nullable

2021-09-15 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4771: Attachment: image-2021-09-16-11-43-55-743.png > change the value of the CAST function to be nullable >

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

2021-09-14 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4774: Issue Type: Improvement (was: New Feature) > When predicate conditions are equivalent, materialized

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

2021-09-14 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4774: --- Summary: When predicate conditions are equivalent, materialized view recognition fails. Key: CALCITE-4774 URL: https://issues.apache.org/jira/browse/CALCITE-4774 Project:

[jira] [Commented] (CALCITE-4770) Design of SearchMvService

2021-09-13 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17414679#comment-17414679 ] xzh_dz commented on CALCITE-4770: - [~asolimando] Thanks for your review.I had added some cases in

[jira] [Created] (CALCITE-4770) Design of SearchMvService

2021-09-12 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4770: --- Summary: Design of SearchMvService Key: CALCITE-4770 URL: https://issues.apache.org/jira/browse/CALCITE-4770 Project: Calcite Issue Type: New Feature

[jira] [Created] (CALCITE-4624) When query contains complex function, materialized view recognition fails

2021-05-27 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4624: --- Summary: When query contains complex function, materialized view recognition fails Key: CALCITE-4624 URL: https://issues.apache.org/jira/browse/CALCITE-4624 Project: Calcite

[jira] [Created] (CALCITE-4566) When query contains multiple `AggregateCall`s, materialized view recognition fails

2021-04-06 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4566: --- Summary: When query contains multiple `AggregateCall`s, materialized view recognition fails Key: CALCITE-4566 URL: https://issues.apache.org/jira/browse/CALCITE-4566 Project:

[jira] [Created] (CALCITE-4534) When TableScan has different order, materialized view recognition fails.

2021-03-12 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4534: --- Summary: When TableScan has different order, materialized view recognition fails. Key: CALCITE-4534 URL: https://issues.apache.org/jira/browse/CALCITE-4534 Project: Calcite

[jira] [Commented] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2021-03-08 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17297855#comment-17297855 ] xzh_dz commented on CALCITE-3409: - [~zabetak] I agree with you, but I don't think it's succinct to

[jira] [Commented] (CALCITE-4407) Support unparse special syntax when operator is DELETE

2020-11-18 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17235115#comment-17235115 ] xzh_dz commented on CALCITE-4407: - Open PR after fixing code.     > Support unparse special syntax

[jira] [Updated] (CALCITE-4005) Support Calc and SetOp operator in RelMdAllPredicates

2020-11-18 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4005: Description: Support calc operator in RelMdAllPredicates and also support setOp operator. was:

[jira] [Updated] (CALCITE-4407) Support unparse special syntax when operator is DELETE

2020-11-18 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4407: Summary: Support unparse special syntax when operator is DELETE (was: Support unparse special syntax

[jira] [Created] (CALCITE-4407) Support unparse special syntax when operator is DELETA

2020-11-18 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4407: --- Summary: Support unparse special syntax when operator is DELETA Key: CALCITE-4407 URL: https://issues.apache.org/jira/browse/CALCITE-4407 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-4406) SqlTableRef OPERATOR should create a SqlTableRef as the call

2020-11-18 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17234348#comment-17234348 ] xzh_dz commented on CALCITE-4406: - The following case can reproduce this problem. {code:java} // code

[jira] [Commented] (CALCITE-4406) SqlTableRef OPERATOR should create a SqlTableRef as the call

2020-11-18 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17234346#comment-17234346 ] xzh_dz commented on CALCITE-4406: - [~danny0405] I tried to test the unit case, but after accessing

[jira] [Updated] (CALCITE-4406) SqlTableRef OPERATOR should create a SqlTableRef as the call

2020-11-18 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4406: Attachment: image-2020-11-18-16-01-55-504.png > SqlTableRef OPERATOR should create a SqlTableRef as the

[jira] [Updated] (CALCITE-4005) Support Calc and SetOp operator in RelMdAllPredicates

2020-11-16 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4005: Summary: Support Calc and SetOp operator in RelMdAllPredicates (was: Support calc operator in

[jira] [Updated] (CALCITE-4251) Get the origin column, even if it is derived

2020-11-13 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4251: Summary: Get the origin column, even if it is derived (was: Overload RelMetadataQuery#getColumnOrigin

[jira] [Created] (CALCITE-4400) A tool method explain Calc operator

2020-11-12 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4400: --- Summary: A tool method explain Calc operator Key: CALCITE-4400 URL: https://issues.apache.org/jira/browse/CALCITE-4400 Project: Calcite Issue Type: Wish

[jira] [Created] (CALCITE-4395) Add an interface in RelOptMaterializations to allow registering normalization rules

2020-11-11 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4395: --- Summary: Add an interface in RelOptMaterializations to allow registering normalization rules Key: CALCITE-4395 URL: https://issues.apache.org/jira/browse/CALCITE-4395 Project:

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

2020-11-11 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17229858#comment-17229858 ] xzh_dz commented on CALCITE-4386: -   A test case is shown below: {code:java} // code placeholder

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

2020-11-10 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17229710#comment-17229710 ] xzh_dz commented on CALCITE-4386: - Thanks.  If we want `RelShuttle` to access an operator(there is no

[jira] [Created] (CALCITE-4391) When the join condition order is different, materialized view recognition fails

2020-11-10 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4391: --- Summary: When the join condition order is different, materialized view recognition fails Key: CALCITE-4391 URL: https://issues.apache.org/jira/browse/CALCITE-4391 Project:

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

2020-11-08 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4386: --- Summary: Support RelShuttle visit specific logical operators Key: CALCITE-4386 URL: https://issues.apache.org/jira/browse/CALCITE-4386 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-4384) Predicate can not satisfy the condition of materialized recognition

2020-11-08 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4384: --- Summary: Predicate can not satisfy the condition of materialized recognition Key: CALCITE-4384 URL: https://issues.apache.org/jira/browse/CALCITE-4384 Project: Calcite

[jira] [Created] (CALCITE-4373) Count(distinct Col) materialized view recognition failed

2020-11-02 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4373: --- Summary: Count(distinct Col) materialized view recognition failed Key: CALCITE-4373 URL: https://issues.apache.org/jira/browse/CALCITE-4373 Project: Calcite Issue

[jira] [Comment Edited] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2020-11-02 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17224607#comment-17224607 ] xzh_dz edited comment on CALCITE-3409 at 11/2/20, 11:40 AM: [~Chunwei Lei]  

[jira] [Commented] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2020-11-02 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17224607#comment-17224607 ] xzh_dz commented on CALCITE-3409: - [~Chunwei Lei]  

[jira] [Comment Edited] (CALCITE-4348) Materialization recognition fails when query has calculation expression

2020-10-20 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17218091#comment-17218091 ] xzh_dz edited comment on CALCITE-4348 at 10/21/20, 3:50 AM: [~julianhyde]

[jira] [Commented] (CALCITE-4348) Materialization recognition fails when query has calculation expression

2020-10-20 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17218091#comment-17218091 ] xzh_dz commented on CALCITE-4348: - [~julianhyde] Thanks, It seems like that can not preserves line

[jira] [Updated] (CALCITE-4348) Materialization recognition fails when query has calculation expression

2020-10-20 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4348: Attachment: image-2020-10-21-11-40-08-353.png > Materialization recognition fails when query has

[jira] [Updated] (CALCITE-4348) Materialization recognition fails when query has calculation expression

2020-10-20 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4348: Description: The following example should be recognized by materialized views, but failed. {code:java}

[jira] [Created] (CALCITE-4348) Materialization recognition fails when query has calculation expression

2020-10-20 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4348: --- Summary: Materialization recognition fails when query has calculation expression Key: CALCITE-4348 URL: https://issues.apache.org/jira/browse/CALCITE-4348 Project: Calcite

[jira] [Commented] (CALCITE-4251) Overload RelMetadataQuery#getColumnOrigin method

2020-10-09 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17211501#comment-17211501 ] xzh_dz commented on CALCITE-4251: - [~julianhyde] Thanks for review. Please review this pr when you

[jira] [Updated] (CALCITE-4251) Overload RelMetadataQuery#getColumnOrigin method

2020-10-09 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4251: Description: A case: {code:java} final String sql1 = "" + "select empno, sum(sal) as all_sal\n"

[jira] [Updated] (CALCITE-4251) Overload RelMetadataQuery#getColumnOrigin method

2020-10-05 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4251: Description: A case: {code:java} final String sql1 = "" + "select empno, sum(sal) as all_sal\n"

[jira] [Updated] (CALCITE-4251) Overload RelMetadataQuery#getColumnOrigin method

2020-10-03 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4251: Description: A case:   {code:java} final String sql1 = "" + "select empno, sum(sal) as all_sal\n"

[jira] [Created] (CALCITE-4296) Materialization recognition fail, cannot match Calc on top of materialized view

2020-09-29 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4296: --- Summary: Materialization recognition fail, cannot match Calc on top of materialized view Key: CALCITE-4296 URL: https://issues.apache.org/jira/browse/CALCITE-4296 Project:

[jira] [Commented] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2020-09-22 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17200062#comment-17200062 ] xzh_dz commented on CALCITE-3409: - In some specific scenarios, specific normalization rules are needed,

[jira] [Commented] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2020-09-22 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17200055#comment-17200055 ] xzh_dz commented on CALCITE-3409: - The materialization rules are different from `RelOptRule`. we can

[jira] [Comment Edited] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2020-09-22 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17200032#comment-17200032 ] xzh_dz edited comment on CALCITE-3409 at 9/22/20, 12:09 PM: [~julianhyde] 

[jira] [Commented] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2020-09-22 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17200032#comment-17200032 ] xzh_dz commented on CALCITE-3409: - [~julianhyde]  Thanks, Do you mean we should have a special class

[jira] [Commented] (CALCITE-4251) Overload RelMetadataQuery#getColumnOrigin method

2020-09-14 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17195434#comment-17195434 ] xzh_dz commented on CALCITE-4251: - Should we indicate that a parameter `derived` for table columns may

[jira] [Commented] (CALCITE-4250) Failed to get original column of aggregate operator

2020-09-12 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17194730#comment-17194730 ] xzh_dz commented on CALCITE-4250: - !image-2020-09-12-20-58-06-444.png! `7` means that the deptno

[jira] [Updated] (CALCITE-4250) Failed to get original column of aggregate operator

2020-09-12 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4250: Attachment: image-2020-09-12-20-58-06-444.png > Failed to get original column of aggregate operator >

[jira] [Updated] (CALCITE-4250) Failed to get original column of aggregate operator

2020-09-12 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4250: Description: We often use `RelMetadataQuery` to track column lineage, but failed to get original column

[jira] [Updated] (CALCITE-4250) Failed to get original column of aggregate operator

2020-09-12 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4250: Description: We often use `RelMetadataQuery` to track column lineage, but failed to get original column

[jira] [Updated] (CALCITE-4250) Failed to get original column of aggregate operator

2020-09-12 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4250: Description: We often use `RelMetadataQuery` to track column lineage, but failed to get original column

[jira] [Created] (CALCITE-4251) Overload RelMetadataQuery#getColumnOrigin method

2020-09-12 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4251: --- Summary: Overload RelMetadataQuery#getColumnOrigin method Key: CALCITE-4251 URL: https://issues.apache.org/jira/browse/CALCITE-4251 Project: Calcite Issue Type: Wish

[jira] [Created] (CALCITE-4250) Failed to get original column of aggregate operator

2020-09-12 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4250: --- Summary: Failed to get original column of aggregate operator Key: CALCITE-4250 URL: https://issues.apache.org/jira/browse/CALCITE-4250 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-03 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17190155#comment-17190155 ] xzh_dz commented on CALCITE-4198: - [~zhishui]  Sorry for the late reply, you can take it. It is better

[jira] [Created] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-08-27 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4198: --- Summary: Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails Key: CALCITE-4198 URL:

[jira] [Commented] (CALCITE-4194) Materialized recognition failed when query contains cast type conversion

2020-08-27 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17185786#comment-17185786 ] xzh_dz commented on CALCITE-4194: - [~julianhyde]  You are right.In the real scene of materialized

[jira] [Created] (CALCITE-4194) Materialized recognition failed when query contains cast type conversion

2020-08-26 Thread xzh_dz (Jira)
xzh_dz created CALCITE-4194: --- Summary: Materialized recognition failed when query contains cast type conversion Key: CALCITE-4194 URL: https://issues.apache.org/jira/browse/CALCITE-4194 Project: Calcite

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

2020-08-23 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17182962#comment-17182962 ] xzh_dz commented on CALCITE-4027: - [~hyuan] A little busy recently, You can take it. > Add

  1   2   3   >