Partition have been drop, but the data is not deleted #39555
Unanswered
Chenfx-git
asked this question in
A - General / Q&A
Replies: 1 comment 1 reply
-
|
if you use |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Partition have been drop, but actually, the disk data is not deleted.
1、ALTER TABLE table SET ("dynamic_partition.start" = "-2");
disk data is not deleted.
2、ALTER TABLE table DROP PARTITION p20240817
disk data is not deleted.
3、ALTER TABLE table DROP PARTITION p20240818 force
After a while, data deleted.
It seem to drop by force, data can be deleted.
path_gc_check_interval_second = 900. I don't see any trash.
How to clear data to free up disk space?
Thanks!
Beta Was this translation helpful? Give feedback.
All reactions