KeeProMise opened a new pull request, #49852:
URL: https://github.com/apache/doris/pull/49852

   ### What problem does this PR solve?
   Suppose there is a table named **order** partitioned by **dt**, which 
contains data from 20240101 to 20250101. If the materialized view is also 
partitioned by dt, and the materialized query is SELECT * FROM order WHERE dt 
IN (20241229, 20241230), then the materialized view would include all 
partitions from 20240101 to 20250101, which is unreasonable. It should only 
include the two partitions for 20241229 and 20241230.
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   Create a materialized view that only includes the partitions in the query 
conditions.
   ### Release note
   Create a materialized view that only includes the partitions in the query 
conditions.
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: 
https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should 
merge into -->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to