v.22.5Improvement

Limit Max Partitions Queryable per Hive Table to Prevent Resource Overruns

Official CH changelog text
Limit the max partitions could be queried for each hive table. Avoid resource overruns. #37281 (lgbo).
Introduces a limit on the maximum number of partitions that can be queried for each Hive table to prevent resource exhaustion.

Why it matters

This feature helps avoid resource overruns by restricting the number of partitions scanned in queries against Hive tables, ensuring more stable and predictable query performance.

How to use it

Users can configure the maximum allowed number of partitions queried per Hive table through the relevant ClickHouse settings. When the limit is reached, queries that exceed this partition count will be rejected to protect system resources.

Related resources

PreviousNext