v.24.2Improvement

Settings for Distributed Table Engine Configurable in Server File

Official CH changelog text
Settings for the Distributed table engine can now be specified in the server configuration file (similar to MergeTree settings), e.g. <distributed> <flush_on_detach>false</flush_on_detach> </distributed>. #59291 (Azat Khuzhin).
Settings for the Distributed table engine can now be configured in the server configuration file, similar to how MergeTree settings are specified.

Why it matters

This feature allows centralized and consistent configuration of Distributed table engine settings at the server level, simplifying management and ensuring uniform behavior without needing to set these parameters per query or session.

How to use it

Add the desired settings inside the <distributed> section in the server configuration XML file, for example:

<distributed>
    <flush_on_detach>false</flush_on_detach>
</distributed>

This will apply the configured settings globally to all Distributed tables on the server.

Related resources

PreviousNext