Skip to content
ClickHouse Docs

max_partitions_* session settings

Autogenerated from ClickHouse system tables

These settings are available in system.merge_tree_settings and are autogenerated from the ClickHouse snapshot.

max_partitions_to_read

Limits the maximum number of partitions that can be accessed in one query.

The setting value specified when the table is created can be overridden via query-level setting.

Possible values:

  • Any positive integer.

You can also specify a query complexity setting max_partitions_to_read at a query / session / profile level.