v.19.10Improvement

Support More ALTER Queries ON CLUSTER

Support more ALTER queries ON CLUSTER. #5593 #5613 (sundyli)
Enhanced support for executing a broader range of ALTER queries using the ON CLUSTER clause in ClickHouse.

Why it matters

This feature enables users to perform additional ALTER operations across all nodes in a cluster seamlessly, improving cluster-wide schema and table management. It solves the limitation of previously restricted ALTER commands when used with ON CLUSTER, streamlining administrative tasks and ensuring consistency across distributed environments.

How to use it

Users can now apply more ALTER queries with the ON CLUSTER clause by simply specifying ALTER TABLE ... ON CLUSTER cluster_name to run the command on all cluster nodes. No additional configuration is required beyond the standard cluster setup.