[jira] [Created] (CALCITE-5844) Allow RelMdColumnOrigins to get columnOrigins from viewTable

JingDas created CALCITE-5844: Summary: Allow RelMdColumnOrigins to get columnOrigins from viewTable Key: CALCITE-5844 URL: https://issues.apache.org/jira/browse/CALCITE-5844 Project: Calcite Iss

[jira] [Updated] (CALCITE-5844) Allow RelMdColumnOrigins to get columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5844: - Description: In our scene, Getting field from view is expected when call RelMdColumnOrigins#getColumnO

[jira] [Updated] (CALCITE-5844) Allow RelMdColumnOrigins to be get columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5844: - Summary: Allow RelMdColumnOrigins to be get columnOrigins from viewTable (was: Allow RelMdColumnOrigi

[jira] [Updated] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5844: - Summary: Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable (was: Allow

[jira] [Updated] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5844: - Description: In our scene, Getting field from view is expected when call RelMdColumnOrigins#getColumnO

[jira] [Commented] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742653#comment-17742653 ] JingDas commented on CALCITE-5844: -- Thanks [~julianhyde], I'll try it. > Make RelMdCo

[jira] [Commented] (CALCITE-5846) AggregateExpandWithinDistinctRule drops filters on non-distinct aggCalls

[ https://issues.apache.org/jira/browse/CALCITE-5846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17743040#comment-17743040 ] JingDas commented on CALCITE-5846: -- In Calcite, I run test as following: SQL {code:ja

[jira] [Commented] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17746012#comment-17746012 ] JingDas commented on CALCITE-5844: -- [~jiajunbernoulli] As you said，ViewTable will be e

[jira] [Commented] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17748376#comment-17748376 ] JingDas commented on CALCITE-5756: -- This [PR|https://github.com/apache/calcite/pull/32

[jira] [Comment Edited] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17748376#comment-17748376 ] JingDas edited comment on CALCITE-5756 at 7/28/23 3:00 AM: --- T

[jira] [Commented] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17748487#comment-17748487 ] JingDas commented on CALCITE-5756: -- [~asolimando] Thanks for your suggest. It's reason

[jira] [Created] (CALCITE-5881) Support to get foreign keys metadata in RelMetadataQuery

JingDas created CALCITE-5881: Summary: Support to get foreign keys metadata in RelMetadataQuery Key: CALCITE-5881 URL: https://issues.apache.org/jira/browse/CALCITE-5881 Project: Calcite Issue Ty

[jira] [Updated] (CALCITE-5881) Support to get foreign keys metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5881: - Priority: Major (was: Minor) > Support to get foreign keys metadata in RelMetadataQuery >

[jira] [Commented] (CALCITE-5881) Support to get foreign keys metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17750947#comment-17750947 ] JingDas commented on CALCITE-5881: -- The [PR|https://github.com/apache/calcite/pull/334

[jira] [Created] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

JingDas created CALCITE-5894: Summary: Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key Key: CALCITE-5894 URL: https://issues.apache.org/jira/browse/CALCITE-5894

[jira] [Updated] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Attachment: image-2023-08-04-15-31-44-824.png > Add SortRemoveRedundantRule to remove redundant sort fi

[jira] [Updated] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Attachment: (was: image-2023-08-04-15-31-44-824.png) > Add SortRemoveRedundantRule to remove redund

[jira] [Updated] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Description: In some scene, Sort fields can be reduct, if sort fields contain unique key For example {

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751007#comment-17751007 ] JingDas commented on CALCITE-5894: -- [~libenchao] Thanks for your comment. Acctually I

[jira] [Comment Edited] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751007#comment-17751007 ] JingDas edited comment on CALCITE-5894 at 8/4/23 7:59 AM: -- [~l

[jira] [Comment Edited] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751007#comment-17751007 ] JingDas edited comment on CALCITE-5894 at 8/4/23 8:04 AM: -- [~l

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752234#comment-17752234 ] JingDas commented on CALCITE-5894: -- [~julianhyde] I see your point and aggre with you,

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

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Summary: Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent

[jira] [Created] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

JingDas created CALCITE-5913: Summary: Support to get functional dependency metadata in RelMetadataQuery Key: CALCITE-5913 URL: https://issues.apache.org/jira/browse/CALCITE-5913 Project: Calcite

[jira] [Updated] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5913: - Description: Functional dependency analysis can be applied to various problems in query optimization:

[jira] [Updated] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5913: - Description: Functional dependency analysis can be applied to various problems in query optimization:

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

[ 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

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

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752235#comment-17752235 ] JingDas edited comment on CALCITE-5894 at 8/9/23 3:09 AM: -- As

[jira] [Updated] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5913: - Description: Functional dependency analysis can be applied to various problems in query optimization:

[jira] [Updated] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5913: - Description: Functional dependency analysis can be applied to various problems in query optimization:

[jira] [Commented] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752242#comment-17752242 ] JingDas commented on CALCITE-5844: -- Current capacity already support to get metadata f

[jira] [Closed] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas closed CALCITE-5844. Resolution: Not A Problem > Make RelMdColumnOrigins to be extendable for getting columnOrigins from > vi

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

[ 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] [Updated] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Attachment: image-2023-08-09-15-51-25-540.png > Add SortRemoveRedundantRule to remove redundant sort fi

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

[ 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-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752320#comment-17752320 ] JingDas commented on CALCITE-5913: -- [~thomas.rebele] I get your point,  In some scene,

[jira] [Commented] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752322#comment-17752322 ] JingDas commented on CALCITE-5913: -- [~shenlang] It's a good idea to split complex work

[jira] [Comment Edited] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752320#comment-17752320 ] JingDas edited comment on CALCITE-5913 at 8/9/23 8:34 AM: -- [~t

[jira] [Commented] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17753636#comment-17753636 ] JingDas commented on CALCITE-5913: -- Thanks for your comment [~thomas.rebele] . It make

[jira] [Comment Edited] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17753636#comment-17753636 ] JingDas edited comment on CALCITE-5913 at 8/13/23 12:05 AM:

[jira] [Comment Edited] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17753636#comment-17753636 ] JingDas edited comment on CALCITE-5913 at 8/13/23 12:06 AM:

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

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Summary: Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent

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

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Attachment: (was: image-2023-08-09-15-51-25-540.png) > Add SortRemoveRedundantRule to remove redund

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

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Description: In some scene, Sort fields can be reduct, if sort fields contain unique key For example {

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

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17753862#comment-17753862 ] JingDas commented on CALCITE-5894: -- [~jhyde] I re-read this part of the paper again. I

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

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17754054#comment-17754054 ] JingDas commented on CALCITE-5894: -- [~thomas.rebele] As discussed in  CALCITE-5913 the

[jira] [Commented] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17754065#comment-17754065 ] JingDas commented on CALCITE-5913: -- [~thomas.rebele] I got your point, it sounds reaso

[jira] [Commented] (CALCITE-5881) Support to get foreign keys metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17754069#comment-17754069 ] JingDas commented on CALCITE-5881: -- [~shenlang] Foreign key is a special constrait, it

[jira] [Comment Edited] (CALCITE-5881) Support to get foreign keys metadata in RelMetadataQuery

[ https://issues.apache.org/jira/browse/CALCITE-5881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17754069#comment-17754069 ] JingDas edited comment on CALCITE-5881 at 8/14/23 12:19 PM:

[jira] [Created] (CALCITE-5928) Add SortHomogenizeRule for homogenization sort fields for futher optimize

JingDas created CALCITE-5928: Summary: Add SortHomogenizeRule for homogenization sort fields for futher optimize Key: CALCITE-5928 URL: https://issues.apache.org/jira/browse/CALCITE-5928 Project: Calcite

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

[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17753862#comment-17753862 ] JingDas edited comment on CALCITE-5894 at 8/14/23 3:09 PM: --- [