v.22.9Improvement
Add has_lightweight_delete to system.parts
Add has_lightweight_delete to system.parts. #41564 (Kseniia Sumarokova).Why it matters
This feature allows users to identify which parts of MergeTree tables support lightweight DELETE operations, improving management and understanding of data deletions within table parts.How to use it
Query thesystem.parts table to check the has_lightweight_delete column. If the value is 1, the part supports lightweight DELETE; if 0, it does not. For example:SELECT database, table, name, has_lightweight_delete
FROM system.parts
WHERE has_lightweight_delete = 1