weizhengte commented on PR #13303:
URL: https://github.com/apache/doris/pull/13303#issuecomment-1275765669

   > I have a little question is that when will a user want to delete stats of 
some partitions rather than whole table, just curious
   
   This is mainly related to the statistics of partition granularity. partition 
statistics is mainly used for queries that contain partitions. This statistics 
is more useful if the partition statistics involved can be used instead of all 
other partition statistics. In addition, we can also collect statistics 
incrementally by partition, etc.
   
   Coming back to your question, I feel that partition statistics may need to 
be removed in this scenario. For example, a table has been collected 
statistics, but the partition time is a long time ago, then you can delete this 
"expired" partition statistics separately. Also, if the partition data is 
changed, then it's statistics is invalid and can be deleted. Of course, there 
are other ways to solve similar problems, if not necessary, it can be removed.


-- 
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