v.22.9Improvement

Add has_lightweight_delete to system.parts

Add has_lightweight_delete to system.parts. #41564 (Kseniia Sumarokova).
Added the has_lightweight_delete column to the system.parts table in ClickHouse.

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 the system.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