Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

shared_merge_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

These settings are available in system.settings and are autogenerated from source.

shared_merge_tree_sequential_consistency_initial_parts_update_backoff_ms

Type
UInt64
Default
50
Version history
VersionDefault valueComment
26.550New setting to reduce sporadic UNFINISHED errors in queries with sequential consistency for SharedMergeTree.

Initial backoff in milliseconds for parts update when using select_sequential_consistency with SharedMergeTree. Only available in ClickHouse Cloud.

shared_merge_tree_sequential_consistency_max_parts_update_backoff_ms

Type
UInt64
Default
1000
Version history
VersionDefault valueComment
26.51000New setting to reduce sporadic UNFINISHED errors in queries with sequential consistency for SharedMergeTree.

Max backoff in milliseconds for parts update when using select_sequential_consistency with SharedMergeTree. Only available in ClickHouse Cloud.

shared_merge_tree_sequential_consistency_parts_update_max_retries

Type
UInt64
Default
10
Version history
VersionDefault valueComment
26.510New setting to reduce sporadic UNFINISHED errors in queries with sequential consistency for SharedMergeTree.

Max retries for parts update when using select_sequential_consistency with SharedMergeTree. Only available in ClickHouse Cloud.

shared_merge_tree_sync_parts_on_partition_operations

Type
Bool
Default
1
Version history
VersionDefault valueComment
24.121New setting. By default parts are always synchronized

Automatically synchronize set of data parts after MOVE|REPLACE|ATTACH partition operations in SMT tables. Cloud only

Navigation