v.24.10Improvement

Respect Compatibility for MergeTree Settings on Server Startup

Official CH changelog text
Respect compatibility for MergeTree settings. The compatibility value is taken from the default profile on server startup, and default MergeTree settings are changed accordingly. Further changes of the compatibility setting do not affect MergeTree settings. #70322 (Nikolai Kochetov).
ClickHouse now respects the compatibility setting from the default profile during server startup to configure MergeTree table settings automatically.

Why it matters

This feature ensures that the MergeTree table engine settings are aligned with the compatibility mode defined in the server's default profile at startup. It solves inconsistencies caused by ignoring the compatibility setting, providing predictable behavior for MergeTree defaults and easier management of backward compatibility.

How to use it

Set the compatibility value in the server's default profile before starting the ClickHouse server. The MergeTree default settings will then be adjusted according to this compatibility mode automatically. Note that changing the compatibility setting after server startup will not affect existing MergeTree settings.

Related resources

PreviousNext