v.18.12Improvement

ALTER DELETE Queries for Materialized Views

Official CH changelog text
ALTER DELETE queries work for materialized views.
ALTER DELETE queries now support materialized views in ClickHouse.

Why it matters

This feature enables users to perform ALTER DELETE operations directly on materialized views, allowing for more flexible and granular data manipulation. Prior to this, such operations were limited or unsupported, making it harder to manage data within materialized views. This enhancement improves data maintenance and cleanup capabilities.

How to use it

Use the ALTER DELETE FROM <materialized_view> WHERE <condition> syntax to delete rows from a materialized view that meet the specified condition.
PreviousNext