Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

max_distributed_* session settings

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

max_distributed_connections

Type
UInt64
Default
1024

The maximum number of simultaneous connections with remote servers for distributed processing of a single query to a single Distributed table. We recommend setting a value no less than the number of servers in the cluster.

The following parameters are only used when creating Distributed tables (and when launching a server), so there is no reason to change them at runtime.

max_distributed_depth

Type
UInt64
Default
5

Limits the maximum depth of recursive queries for Distributed tables.

If the value is exceeded, the server throws an exception.

Possible values:

  • Positive integer.
  • 0 — Unlimited depth.
Navigation