v.22.2Improvement

Supports SYSTEM Queries with ON CLUSTER Clause

Official CH changelog text
Supports all types of SYSTEM queries with ON CLUSTER clause. #34005 (小路).
Adds support for executing all types of SYSTEM queries with the ON CLUSTER clause in ClickHouse.

Why it matters

This feature enables users to run SYSTEM queries across an entire cluster, simplifying cluster-wide management tasks and ensuring consistent execution of administrative commands on all nodes.

How to use it

Users can append ON CLUSTER <cluster_name> to any SYSTEM query to execute it across all nodes in the specified cluster. For example:
SYSTEM RELOAD CONFIG ON CLUSTER my_cluster

Related resources

PreviousNext