v.23.12Improvement

Add skip_unavailable_shards setting for Distributed tables

Official CH changelog text
Add skip_unavailable_shards as a setting for Distributed tables that is similar to the corresponding query-level setting. Closes #43666. #57218 (Gagan Goel).
Added the skip_unavailable_shards setting for Distributed tables to control shard availability behavior similarly to the query-level setting.

Why it matters

This feature allows users to configure Distributed tables to skip unavailable shards automatically, preventing query failures caused by unreachable shards and improving query reliability and fault tolerance.

How to use it

Enable the setting by adding skip_unavailable_shards=1 in the table definition of a Distributed table or set it as a session/query setting to skip unavailable shards during query execution.

Related resources

PreviousNext