v.22.3New Feature

New Ability for Unrestricted Reads from Zookeeper Table in ClickHouse

Official CH changelog text
Now you can read system.zookeeper table without restrictions on path or using like expression. This reads can generate quite heavy load for zookeeper so to enable this ability you have to enable setting allow_unrestricted_reads_from_keeper. #34609 (Sergei Trifonov).
Allows unrestricted reads from the system.zookeeper table without path limitations or needing to use the like expression.

Why it matters

This feature enables users to perform full and flexible queries on the system.zookeeper table, which was previously restricted to certain paths or required pattern matching. It helps in scenarios where comprehensive access to ZooKeeper data is necessary, although it may generate a heavy load on ZooKeeper.

How to use it

To enable unrestricted reads from system.zookeeper, set the configuration option allow_unrestricted_reads_from_keeper to true. This setting must be explicitly enabled to avoid unintended heavy load on ZooKeeper.

Related resources

PreviousNext