使用DELETE语句删除表记录，实际的分区和磁盘数据没有删除 #35772
Unanswered
TheThirdReich77
asked this question in
Q&A
Replies: 1 comment 1 reply
-
|
中文问题，建议去ask.selectdb.com去问问题 |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
为什么每个下边都会看到这个回复？ selectdb 和 Apache doris 是什么关系呢？ |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
doris版本：2.0.9
表模型和分区：duplicate key、按st_date_part时间列进行按日分区
删除语句：delete from events_raw where st_date_part < '2024-05-14'
删除后该时间点之前的行记录已经不可见，通过show delete语句查询到事务已是finished状态，但过了3天后记录并没有删除，分区数据仍然存在，磁盘空间未清除
Beta Was this translation helpful? Give feedback.
All reactions