Support for Removing of Detached Parts

Why it matters

This feature allows users to clean up detached parts manually, preventing accumulation of unused parts that can consume disk space and impact performance. It provides better control over managing table parts and maintaining storage hygiene.

How to use it

Use the ALTER TABLE statement with the DROP DETACHED PART clause to remove a specific detached part by its <part_id>. For example:

ALTER TABLE <table_name> DROP DETACHED PART '<part_id>'