ON CLUSTER in ALTER UPDATE Queries

Why it matters

This feature allows users to apply ALTER UPDATE statements across all replicas in a cluster simultaneously. It simplifies cluster-wide data updates by enabling atomic execution on multiple nodes, ensuring data consistency and reducing manual coordination.

How to use it

Add the ON CLUSTER <cluster_name> clause to your ALTER UPDATE queries to execute the update across the specified cluster. For example:

ALTER TABLE table_name ON CLUSTER cluster_name UPDATE column = value WHERE condition;