v.24.9Improvement

New Option for Lightweight Delete in Tables with Projections

Official CH changelog text
When lightweight delete happens on a table with projection(s), despite users have choices either throw an exception (by default) or drop the projection when the lightweight delete would happen, now there is the third option to still have lightweight delete and then rebuild projection(s). #66169 (jsc0218).
Lightweight Delete on tables with projections now supports a third option: performing the delete and then rebuilding the projections.

Why it matters

Previously, when a lightweight delete was attempted on tables containing projections, users had to either throw an exception (default) or drop the projections to proceed. This new feature enables performing the lightweight delete while automatically rebuilding the affected projections, improving usability and data consistency without manual intervention.

How to use it

Users can configure the behavior for lightweight delete on tables with projections by selecting the new option that triggers projection rebuild after the delete. This can be enabled via table settings or query parameters to allow lightweight delete followed by rebuilding the projections.

Related resources

PreviousNext