[jira] [Created] (CALCITE-6894) ClickHouse dialect can support another form of writing aggFilterWhere

2025-03-16 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6894: -- Summary: ClickHouse dialect can support another form of writing aggFilterWhere Key: CALCITE-6894 URL: https://issues.apache.org/jira/browse/CALCITE-6894 Project: Calcite

[jira] [Commented] (CALCITE-6900) Support Char type cast in ClickHouse Dialect

2025-03-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936835#comment-17936835 ] Zhen Chen commented on CALCITE-6900: It would be better to change ClickHouse to sup

[jira] [Closed] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen closed CALCITE-6902. -- Resolution: Won't Fix > IS NOT DISTINCT FROM does not implement Implementor > ---

[jira] [Commented] (CALCITE-6891) Implement IntersectReorderRule

2025-03-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936640#comment-17936640 ] Zhen Chen commented on CALCITE-6891: [~mbudiu] Sorry, I didn't notice that pr was n

[jira] [Commented] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936957#comment-17936957 ] Zhen Chen commented on CALCITE-6902: [~julianhyde] Do we need implementor for IS [N

[jira] [Commented] (CALCITE-6907) Optimize HepPlanner latency for large plan

2025-03-23 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937704#comment-17937704 ] Zhen Chen commented on CALCITE-6907: This idea is very interesting. If graphs can b

[jira] [Commented] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-21 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937529#comment-17937529 ] Zhen Chen commented on CALCITE-6904: Oops, I made a mistake. I will fix it. > IS_N

[jira] [Updated] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in EnumerableJoinRule

2025-03-21 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6904: --- Summary: IS_NOT_DISTINCT_FROM is converted error in EnumerableJoinRule (was: IS_NOT_DISTINCT_FROM

[jira] [Updated] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-20 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6904: --- Summary: IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule (was: Is not distinct fr

[jira] [Commented] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in EnumerableJoinRule

2025-03-23 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937676#comment-17937676 ] Zhen Chen commented on CALCITE-6904: [~mbudiu] I found a way to fix it as you sugge

[jira] [Updated] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-20 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6904: --- Description: The convert() method of ElementerableJoinRule incorrectly converts the condition of I

[jira] [Commented] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-20 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937241#comment-17937241 ] Zhen Chen commented on CALCITE-6904: Okay, I will add a case later. > IS_NOT_DISTI

[jira] [Commented] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-20 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937274#comment-17937274 ] Zhen Chen commented on CALCITE-6904: [~mbudiu] I added some case. > IS_NOT_DISTINC

[jira] [Updated] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-20 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6904: --- Description: The convert() method of ElementerableJoinRule incorrectly converts the condition of I

[jira] [Updated] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-20 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6904: --- Description: The convert() method of ElementerableJoinRule incorrectly converts the condition of IS

[jira] [Updated] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-21 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6904: --- Description: The convert() method of ElementerableJoinRule incorrectly converts the condition of I

[jira] [Assigned] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-03-21 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen reassigned CALCITE-6904: -- Assignee: Zhen Chen > IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule > ---

[jira] [Updated] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in EnumerableJoinRule

2025-03-21 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6904: --- Description: The convert() method of EnumerableJoinRule incorrectly converts the condition of IS_N

[jira] [Created] (CALCITE-6897) AbstractConverter of root node is not needed in topdown mode

2025-03-17 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6897: -- Summary: AbstractConverter of root node is not needed in topdown mode Key: CALCITE-6897 URL: https://issues.apache.org/jira/browse/CALCITE-6897 Project: Calcite

[jira] [Commented] (CALCITE-6899) Mismatch of Trait information results in a missing conversion exception

2025-03-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936448#comment-17936448 ] Zhen Chen commented on CALCITE-6899: Maybe we can remove `p.addRelTraitDef(RelDistr

[jira] [Commented] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936534#comment-17936534 ] Zhen Chen commented on CALCITE-6893: I modified the code according to your suggesti

[jira] [Commented] (CALCITE-6891) Implement IntersectReorderRule

2025-03-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936539#comment-17936539 ] Zhen Chen commented on CALCITE-6891: [~mbudiu] [~julianhyde] Could you please revie

[jira] [Commented] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-16 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936081#comment-17936081 ] Zhen Chen commented on CALCITE-6893: [~julianhyde] Sorry, maybe I didn't describe i

[jira] [Commented] (CALCITE-6891) Implement IntersectReorderRule

2025-03-14 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17935653#comment-17935653 ] Zhen Chen commented on CALCITE-6891: [~julianhyde] Yes, this rule tends to be used

[jira] [Commented] (CALCITE-6891) Implement IntersectReorderRule

2025-03-17 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936330#comment-17936330 ] Zhen Chen commented on CALCITE-6891: [~julianhyde] Hi, is this description enough?

[jira] [Commented] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-17 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936329#comment-17936329 ] Zhen Chen commented on CALCITE-6893: [~julianhyde] This is a great idea. Next, I wi

[jira] [Commented] (CALCITE-6891) Implement IntersectReorderRule

2025-03-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936643#comment-17936643 ] Zhen Chen commented on CALCITE-6891: [~mbudiu] Sorry, 6891 is right. I have changed

[jira] [Commented] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-17 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936109#comment-17936109 ] Zhen Chen commented on CALCITE-6893: [~julianhyde] You are right. We can change the

[jira] [Created] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6902: -- Summary: IS NOT DISTINCT FROM does not implement Implementor Key: CALCITE-6902 URL: https://issues.apache.org/jira/browse/CALCITE-6902 Project: Calcite Issue Typ

[jira] [Created] (CALCITE-6904) Is not distinct from conversion error in ElementerableJoinRule

2025-03-20 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6904: -- Summary: Is not distinct from conversion error in ElementerableJoinRule Key: CALCITE-6904 URL: https://issues.apache.org/jira/browse/CALCITE-6904 Project: Calcite

[jira] [Commented] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in ElementerableJoinRule

2025-04-05 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937231#comment-17937231 ] Zhen Chen commented on CALCITE-6904: [~julianhyde] Thanks, I have changed it. > IS

[jira] [Commented] (CALCITE-6924) FilterIntoJoinRule make JdbcJoin contains expressions that it does not support

2025-04-05 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939855#comment-17939855 ] Zhen Chen commented on CALCITE-6924: I looked at this issue and feel that it may no

[jira] [Updated] (CALCITE-6927) Join condition remove IS NOT DISTINCT FROM

2025-04-05 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6927: --- Description: By referring to the conversion method of spark, IS NOT DISTINCT FROM can be converted

[jira] [Comment Edited] (CALCITE-6894) ClickHouse dialect can support another form of writing aggFilterWhere

2025-04-05 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17938610#comment-17938610 ] Zhen Chen edited comment on CALCITE-6894 at 3/26/25 1:24 PM:

[jira] [Updated] (CALCITE-6938) Support zero value creation of nested data types

2025-04-04 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6938: --- Description: This implementation ensures zero values of various nested data types can be used in {

[jira] [Commented] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in EnumerableJoinRule

2025-03-25 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17938375#comment-17938375 ] Zhen Chen commented on CALCITE-6904: [~julianhyde] [~mbudiu] Thanks, I agree with y

[jira] [Comment Edited] (CALCITE-6904) IS_NOT_DISTINCT_FROM is converted error in EnumerableJoinRule

2025-03-25 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17938375#comment-17938375 ] Zhen Chen edited comment on CALCITE-6904 at 3/25/25 10:53 PM: ---

[jira] [Comment Edited] (CALCITE-6894) ClickHouse dialect can support another form of writing aggFilterWhere

2025-03-26 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17938610#comment-17938610 ] Zhen Chen edited comment on CALCITE-6894 at 3/26/25 1:18 PM:

[jira] [Commented] (CALCITE-6894) ClickHouse dialect can support another form of writing aggFilterWhere

2025-03-26 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17938610#comment-17938610 ] Zhen Chen commented on CALCITE-6894: Comparison Between Calcite's {{FILTER (WHERE)}

[jira] [Commented] (CALCITE-6894) ClickHouse dialect can support another form of writing aggFilterWhere

2025-03-25 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937438#comment-17937438 ] Zhen Chen commented on CALCITE-6894: [~nobigo] Clickhouse can support aggFilterWher

[jira] [Updated] (CALCITE-6904) IS_NOT_DISTINCT_FROM is incorrectly handled by EnumerableJoinRule

2025-04-07 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6904: --- Summary: IS_NOT_DISTINCT_FROM is incorrectly handled by EnumerableJoinRule (was: IS_NOT_DISTINCT_F

[jira] [Created] (CALCITE-6948) Implement MinusToAntiJoinRule

2025-04-10 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6948: -- Summary: Implement MinusToAntiJoinRule Key: CALCITE-6948 URL: https://issues.apache.org/jira/browse/CALCITE-6948 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6925) Logical operator should remove RelDistributionTraitDef

2025-04-08 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17941893#comment-17941893 ] Zhen Chen commented on CALCITE-6925: Hi, [~julianhyde] Thank you very much for init

[jira] [Commented] (CALCITE-6927) Add rule for join condition remove IS NOT DISTINCT FROM

2025-04-01 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939826#comment-17939826 ] Zhen Chen commented on CALCITE-6927: I agree with you. If the hash-join can be well

[jira] [Created] (CALCITE-6925) Logical operator should remove RelDistributionTraitDef

2025-03-28 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6925: -- Summary: Logical operator should remove RelDistributionTraitDef Key: CALCITE-6925 URL: https://issues.apache.org/jira/browse/CALCITE-6925 Project: Calcite Issue

[jira] [Commented] (CALCITE-6928) Sonar analysis fails

2025-03-30 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939484#comment-17939484 ] Zhen Chen commented on CALCITE-6928: [~asolimando] Hi, could you please help me che

[jira] [Commented] (CALCITE-6924) FilterIntoJoinRule make JdbcJoin contains expressions that it does not support

2025-03-30 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939485#comment-17939485 ] Zhen Chen commented on CALCITE-6924: [~nobigo] Hi, I don't know if you are solving

[jira] [Commented] (CALCITE-6899) Mismatch of Trait information results in a missing conversion exception

2025-03-31 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939851#comment-17939851 ] Zhen Chen commented on CALCITE-6899: In my opinion, the adaptation of traits should

[jira] [Commented] (CALCITE-6928) Sonar analysis fails in CI

2025-04-01 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939977#comment-17939977 ] Zhen Chen commented on CALCITE-6928: Yes, the local error should be a problem with

[jira] [Commented] (CALCITE-6928) Sonar analysis fails in CI

2025-04-01 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17940010#comment-17940010 ] Zhen Chen commented on CALCITE-6928: Great! Thanks. > Sonar analysis fails in CI >

[jira] [Commented] (CALCITE-6924) FilterIntoJoinRule make JdbcJoin contains expressions that it does not support

2025-04-01 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939888#comment-17939888 ] Zhen Chen commented on CALCITE-6924: Maybe I misunderstood your meaning. Is the pur

[jira] [Created] (CALCITE-6891) Implement IntersectReorderRule

2025-03-14 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6891: -- Summary: Implement IntersectReorderRule Key: CALCITE-6891 URL: https://issues.apache.org/jira/browse/CALCITE-6891 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6888) Doris dialect implementation

2025-03-14 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17935485#comment-17935485 ] Zhen Chen commented on CALCITE-6888:  I have finish check in 2.1.8 and master. > D

[jira] [Commented] (CALCITE-6888) Doris dialect implementation

2025-03-14 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17935433#comment-17935433 ] Zhen Chen commented on CALCITE-6888: [~caicancai] Good idea, I already check the ma

[jira] [Created] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-15 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6893: -- Summary: Remove agg from Union children in IntersectToDistinctRule Key: CALCITE-6893 URL: https://issues.apache.org/jira/browse/CALCITE-6893 Project: Calcite Iss

[jira] [Updated] (CALCITE-6891) Implement IntersectReorderRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6891: --- Attachment: image-2025-03-16-09-40-10-496.png > Implement IntersectReorderRule > --

[jira] [Updated] (CALCITE-6891) Implement IntersectReorderRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6891: --- Description: Do we need this rule? phy plan no use this rule: {code:java} EnumerableIntersect(all=

[jira] [Commented] (CALCITE-6891) Implement IntersectReorderRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17935788#comment-17935788 ] Zhen Chen commented on CALCITE-6891: [~julianhyde] I have updated the description a

[jira] [Updated] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6893: --- Attachment: image-2025-03-16-11-02-04-725.png > Remove agg from Union children in IntersectToDistin

[jira] [Updated] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6893: --- Attachment: (was: image-2025-03-16-10-54-18-704.png) > Remove agg from Union children in Inters

[jira] [Updated] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6893: --- Attachment: image-2025-03-16-10-54-18-704.png > Remove agg from Union children in IntersectToDistin

[jira] [Updated] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6893: --- Description: Whether agg should be pushed down should be determined by the cost. SQL:   Final Ph

[jira] [Updated] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6893: --- Description: Whether agg should be pushed down should be determined by the cost. SQL:   {code:jav

[jira] [Commented] (CALCITE-6893) Remove agg from Union children in IntersectToDistinctRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17935792#comment-17935792 ] Zhen Chen commented on CALCITE-6893: [~julianhyde] Thank you for your suggestion. I

[jira] [Updated] (CALCITE-6891) Implement IntersectReorderRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6891: --- Attachment: image-2025-03-16-09-37-47-916.png > Implement IntersectReorderRule > --

[jira] [Updated] (CALCITE-6891) Implement IntersectReorderRule

2025-03-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6891: --- Attachment: image-2025-03-16-09-38-41-654.png > Implement IntersectReorderRule > --

[jira] [Commented] (CALCITE-6925) Logical operator should remove RelDistributionTraitDef

2025-04-11 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17943542#comment-17943542 ] Zhen Chen commented on CALCITE-6925: The CALCITE-6899 is failed case. Should this J

[jira] [Commented] (CALCITE-6335) Quidem tests should allow specifying optimization passes to apply to programs

2025-04-11 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17943437#comment-17943437 ] Zhen Chen commented on CALCITE-6335: I think we may also need to consider capabilit

[jira] [Commented] (CALCITE-6966) Extend JoinConditionOrExpansionRule to support column and constants as valid conditions

2025-04-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17945696#comment-17945696 ] Zhen Chen commented on CALCITE-6966: [~julianhyde] I have already linked the previo

[jira] (CALCITE-6957) The RelOptRulesTest tests should fail if the xml file contains tests that do not exist in Java

2025-04-16 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6957 ] Zhen Chen deleted comment on CALCITE-6957: was (Author: jensen): [~nobigo] Hi, I think recording PRs in the description doesn't clearly capture issues because PRs can be updated. It would b

[jira] [Commented] (CALCITE-6975) Upgrade Quidem version to 0.12

2025-04-21 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17946288#comment-17946288 ] Zhen Chen commented on CALCITE-6975: Maybe we should wait until CALCITE-6335 is mer

[jira] [Commented] (CALCITE-6966) Extend JoinConditionOrExpansionRule to support column and constants as valid conditions

2025-04-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17945754#comment-17945754 ] Zhen Chen commented on CALCITE-6966: [~mbudiu] Thank you very much for your re-expl

[jira] [Commented] (CALCITE-6966) Extend JoinConditionOrExpansionRule to support column and constants as valid conditions

2025-04-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17945757#comment-17945757 ] Zhen Chen commented on CALCITE-6966: [~julianhyde] Thank you very much for telling

[jira] [Updated] (CALCITE-6966) Change JoinConditionOrExpansionRule name and accept more predicates that will allow the expansion to be performed

2025-04-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6966: --- Summary: Change JoinConditionOrExpansionRule name and accept more predicates that will allow the ex

[jira] [Updated] (CALCITE-6930) Implementing JoinConditionOrExpansionRule

2025-04-18 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6930: --- Description: JoinConditionOrExpansionRule transforms a join with OR conditions into a UNION ALL of

[jira] [Updated] (CALCITE-6971) Calculation accuracy loss after agg over to case when

2025-04-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6971: --- Summary: Calculation accuracy loss after agg over to case when (was: Calculation accuracy loss aft

[jira] [Commented] (CALCITE-6971) Calculation accuracy loss after agg over to case when

2025-04-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17945919#comment-17945919 ] Zhen Chen commented on CALCITE-6971: [~mbudiu] Thanks for your reply. I realize I d

[jira] [Commented] (CALCITE-6335) Quidem tests should allow specifying optimization passes to apply to programs

2025-04-20 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17945968#comment-17945968 ] Zhen Chen commented on CALCITE-6335: [~mbudiu] [~julianhyde] Could you help me to h

[jira] [Commented] (CALCITE-6973) Add rule for convert Minus to Filter

2025-04-20 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17945966#comment-17945966 ] Zhen Chen commented on CALCITE-6973: [~julianhyde] Thank you for your response and

[jira] [Created] (CALCITE-6987) Support DuckDB dialect

2025-04-26 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6987: -- Summary: Support DuckDB dialect Key: CALCITE-6987 URL: https://issues.apache.org/jira/browse/CALCITE-6987 Project: Calcite Issue Type: New Feature Re

[jira] [Commented] (CALCITE-6985) Add rule to transform MIN/MAX with ORDER BY and LIMIT 1

2025-04-25 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17947457#comment-17947457 ] Zhen Chen commented on CALCITE-6985: [~mbudiu] Thanks! I will consider it together.

[jira] [Commented] (CALCITE-6335) Quidem tests should allow specifying optimization passes to apply to programs

2025-04-25 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17947456#comment-17947456 ] Zhen Chen commented on CALCITE-6335: [~julianhyde] I have released my own version f

[jira] [Assigned] (CALCITE-6963) SqlToRelConverter fails when subquery is in join on clause

2025-04-30 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen reassigned CALCITE-6963: -- Assignee: Zhen Chen > SqlToRelConverter fails when subquery is in join on clause > -

[jira] [Updated] (CALCITE-6996) The command !set planner-rules support SubQueryRemoveRule

2025-04-30 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6996: --- Summary: The command !set planner-rules support SubQueryRemoveRule (was: !set planner-rules suppor

[jira] [Closed] (CALCITE-6996) The command !set planner-rules support SubQueryRemoveRule

2025-04-30 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen closed CALCITE-6996. -- Resolution: Won't Fix > The command !set planner-rules support SubQueryRemoveRule > -

[jira] [Updated] (CALCITE-6948) Implement MinusToAntiJoinRule

2025-04-10 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6948: --- Description: Similar to IntersectToSemiJoinRule, we can implement MinusToAntiJoinRule. Like this:

[jira] [Updated] (CALCITE-6948) Implement MinusToAntiJoinRule

2025-04-10 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6948: --- Description: Similar to IntersectToSemiJoinRule, we can implement MinusToAntiJoinRule. Like this:

[jira] [Updated] (CALCITE-6948) Implement MinusToAntiJoinRule

2025-04-10 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6948: --- Description: Similar to IntersectToSemiJoinRule, we can implement MinusToAntiJoinRule. Like this:

[jira] [Commented] (CALCITE-6948) Implement MinusToAntiJoinRule

2025-04-10 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17943403#comment-17943403 ] Zhen Chen commented on CALCITE-6948: Thank you very much to [~mbudiu]  and [~julian

[jira] [Commented] (CALCITE-6335) Quidem tests should allow specifying optimization passes to apply to programs

2025-04-10 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17943404#comment-17943404 ] Zhen Chen commented on CALCITE-6335: Hi, [~julianhyde] [~mbudiu] , I am very willin

[jira] [Commented] (CALCITE-6953) Extend UnionEliminatorRule to support Intersect and Minus

2025-04-14 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944399#comment-17944399 ] Zhen Chen commented on CALCITE-6953: Yes, PruneEmptyRules should do this. But the s

[jira] [Created] (CALCITE-6955) PruneEmptyRules does not handle the all attribute of SetOp correctly

2025-04-14 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6955: -- Summary: PruneEmptyRules does not handle the all attribute of SetOp correctly Key: CALCITE-6955 URL: https://issues.apache.org/jira/browse/CALCITE-6955 Project: Calcite

[jira] [Assigned] (CALCITE-6335) Quidem tests should allow specifying optimization passes to apply to programs

2025-04-11 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen reassigned CALCITE-6335: -- Assignee: Zhen Chen > Quidem tests should allow specifying optimization passes to apply to p

[jira] [Comment Edited] (CALCITE-6957) The RelOptRulesTest tests should fail if the xml file contains tests that do not exist in Java

2025-04-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944943#comment-17944943 ] Zhen Chen edited comment on CALCITE-6957 at 4/16/25 6:35 AM:

[jira] [Commented] (CALCITE-6952) JDBC adapter for StarRocks generates incorrect SQL for REAL datatype

2025-04-14 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944309#comment-17944309 ] Zhen Chen commented on CALCITE-6952: Doris does not support REAL datatype too. [ht

[jira] [Created] (CALCITE-6953) Extend UnionEliminatorRule to support Intersect and Minus

2025-04-14 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6953: -- Summary: Extend UnionEliminatorRule to support Intersect and Minus Key: CALCITE-6953 URL: https://issues.apache.org/jira/browse/CALCITE-6953 Project: Calcite Iss

[jira] [Updated] (CALCITE-6953) Extend UnionEliminatorRule to support Intersect and Minus

2025-04-14 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen updated CALCITE-6953: --- Fix Version/s: 1.40.0 > Extend UnionEliminatorRule to support Intersect and Minus > ---

[jira] [Commented] (CALCITE-6948) Implement MinusToAntiJoinRule

2025-04-14 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944279#comment-17944279 ] Zhen Chen commented on CALCITE-6948: Hi [~julianhyde]  My apologies if my previous

[jira] [Comment Edited] (CALCITE-6948) Implement MinusToAntiJoinRule

2025-04-14 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944279#comment-17944279 ] Zhen Chen edited comment on CALCITE-6948 at 4/14/25 8:37 AM:

[jira] [Commented] (CALCITE-6957) The RelOptRulesTest tests should fail if the xml file contains tests that do not exist in Java

2025-04-15 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944943#comment-17944943 ] Zhen Chen commented on CALCITE-6957: [~nobigo] Hi, I think recording PRs in the des

  1   2   3   4   >