v.24.7Improvement

Add settings to ignore ON CLUSTER clause for named collection management in replicated storage

Add settings to ignore the ON CLUSTER clause in queries for named collection management with the replicated storage. #66288 (MikhailBurdukov).
Added settings to ignore the ON CLUSTER clause in queries related to named collection management when using replicated storage.

Why it matters

This feature addresses issues arising from the ON CLUSTER clause in distributed environments involving replicated storage for named collections. By allowing users to ignore this clause in relevant queries, it simplifies management and avoids unintended cluster-wide operations, improving stability and control.

How to use it

Users can enable this feature by configuring the new settings that instruct ClickHouse to ignore the ON CLUSTER clause during named collection management queries. This can be done by setting the appropriate parameters in the server configuration or per session, depending on the deployment.