v.24.6Experimental Feature

Add Settings for Custom Key Range in Parallel Replicas

Official CH changelog text
Add settings parallel_replicas_custom_key_range_lower and parallel_replicas_custom_key_range_upper to control how parallel replicas with dynamic shards parallelizes queries when using a range filter. #64604 (josh-hildred).
Introduces the settings parallel_replicas_custom_key_range_lower and parallel_replicas_custom_key_range_upper to control query parallelization for parallel replicas with dynamic shards when using range filters.

Why it matters

These settings allow users to fine-tune how queries are parallelized across replicas that handle dynamic shard ranges. This improves query performance and resource utilization by customizing the key ranges that determine parallel query execution in distributed setups with range filters.

How to use it

Configure the settings parallel_replicas_custom_key_range_lower and parallel_replicas_custom_key_range_upper in the ClickHouse server or client settings to specify custom key ranges for parallel execution of queries with range filters on parallel replicas.

Related resources

PreviousNext