Skip to main content
Skip to main content
Edit this page

MergeTree tables settings

System table system.merge_tree_settings shows the globally set MergeTree settings.

MergeTree settings can be set in the merge_tree section of the server config file, or specified for each MergeTree table individually in the SETTINGS clause of the CREATE TABLE statement.

Example for customizing setting max_suspicious_broken_parts:

Configure the default for all MergeTree tables in the server configuration file:

Set for a particular table:

Change the settings for a particular table using ALTER TABLE ... MODIFY SETTING:

MergeTree settings​