v.20.5Improvement

Add Distributed DDL Support for Cross-Replication Clusters

Add support for distributed DDL (UPDATE/DELETE/DROP PARTITION) on cross replication clusters. #11508 (frank lee).
Add support for distributed DDL operations like UPDATE, DELETE, and DROP PARTITION on cross replication clusters in ClickHouse.

Why it matters

This feature enables users to perform distributed Data Definition Language (DDL) operations across multiple replicas in a cross replication cluster, ensuring consistent schema and data mutations. It solves the problem of synchronization and consistency when making data changes or partition drops on replicated distributed tables, improving reliability and manageability.

How to use it

Users can execute UPDATE, DELETE, and DROP PARTITION statements on distributed tables that are part of a cross replication cluster. The system internally propagates these DDL operations to all replicas, maintaining consistency without additional manual steps.