v.23.11Improvement
Add Settings for Execution Time and Timeout Behavior in Distributed Queries
Add a settingmax_execution_time_leafto limit the execution time on shard for distributed query, andtimeout_overflow_mode_leafto control the behaviour if timeout happens. #51823 (Duc Canh Le).
Why it matters
This feature addresses the need to manage and control execution time limits more granularly on shards in distributed queries. It helps prevent long-running operations on shards from delaying the entire distributed query, improving query reliability and resource management.How to use it
Set themax_execution_time_leaf setting to specify the maximum allowed execution time on each shard during a distributed query. Use the timeout_overflow_mode_leaf setting to define how the system should behave if a shard's execution time exceeds the limit (e.g., to abort or continue the query). These settings can be adjusted per session or query to fine-tune distributed execution time management.