[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752309#comment-17752309 ] Julian Hyde commented on CALCITE-5894: -- [~jingda], That sounds like a good plan. T

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-09 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752308#comment-17752308 ] JingDas commented on CALCITE-5894: -- As the above discussion,  I think we have some con

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752305#comment-17752305 ] Julian Hyde commented on CALCITE-5894: -- [~libenchao], Yes, it seems likely to me a

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-09 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752301#comment-17752301 ] Benchao Li commented on CALCITE-5894: - I agree that removing the redundant fields c

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752299#comment-17752299 ] Julian Hyde commented on CALCITE-5894: -- I like the idea of using functional depend

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752288#comment-17752288 ] JingDas commented on CALCITE-5894: -- It's good to do this work together. Maybe I can re

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752258#comment-17752258 ] LakeShen commented on CALCITE-5894: --- FunctionalDependency is a very important optimiz

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752235#comment-17752235 ] JingDas commented on CALCITE-5894: -- As said in the book [《Exploiting Functional Depend