distributed_plan_* session settings

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

​

distributed_plan_default_reader_bucket_count

Default number of tasks for parallel reading in distributed query. Tasks are spread across between replicas.

​

distributed_plan_default_shuffle_join_bucket_count

Default number of buckets for distributed shuffle-hash-join.

​

distributed_plan_execute_locally

Run all tasks of a distributed query plan locally. Useful for testing and debugging.

​

distributed_plan_force_exchange_kind

Force specified kind of Exchange operators between distributed query stages. Possible values:

• ” - do not force any kind of Exchange operators, let the optimizer choose,
• ‘Persisted’ - use temporary files in object storage,
• ‘Streaming’ - stream exchange data over network.

​

distributed_plan_force_shuffle_aggregation

Use Shuffle aggregation strategy instead of PartialAggregation + Merge in distributed query plan.

​

distributed_plan_max_rows_to_broadcast

Maximum rows to use broadcast join instead of shuffle join in distributed query plan.

​

distributed_plan_optimize_exchanges

Removes unnecessary exchanges in distributed query plan. Disable it for debugging.

​

distributed_plan_prefer_replicas_over_workers

Serialize the distributed query plan for execution at replicas.

​

distributed_plan_workers_num

How many stateless workers will be used to execute this query. Zero disables stateless-worker leasing for distributed plans.