v.25.3Improvement

System tables like server_settings or settings have

Official CH changelog text
System tables like server_settings or settings have a default value column which is convenient. Add them to merge_tree_settings and replicated_merge_tree_settings. #76942 (Diego Nieto).
Added a default value column to merge_tree_settings and replicated_merge_tree_settings system tables, similar to existing tables like server_settings and settings.

Why it matters

This feature improves usability by providing the default values of settings directly in the system tables related to MergeTree engines. It helps users understand configuration defaults at a glance when inspecting these settings.

How to use it

Query the merge_tree_settings and replicated_merge_tree_settings system tables as usual, and observe the new default column to see default values of each setting.

Related resources

PreviousNext