v.20.10Improvement

Fixed settings constraint violation in SELECT with distributed tables

Official CH changelog text
Fixed excessive settings constraint violation when running SELECT with SETTINGS from a distributed table. #14876 (Amos Bird).
Fixed an issue where running a SELECT query with SETTINGS on a distributed table caused excessive settings constraint violations.

Why it matters

This fix addresses the problem of unnecessary and excessive constraint violations triggered by user settings when executing queries on distributed tables. It improves stability and usability by allowing queries with SETTINGS clauses to run correctly on distributed tables without being blocked by overly strict constraint checks.

How to use it

Users can run SELECT queries with the SETTINGS clause on distributed tables as usual without encountering unwarranted settings constraint errors. No additional configuration is required.

Related resources

PreviousNext