v.21.3Improvement

Supports path IN expressions for system.zookeeper table

Supports path IN (set) expressions for system.zookeeper table. #20105 (小路).
Adds support for path IN (set) expressions in queries on the system.zookeeper table.

Why it matters

This feature allows users to filter rows from the system.zookeeper table using IN expressions on the path column, enabling more flexible and efficient queries when working with multiple ZooKeeper paths.

How to use it

Use a query on the system.zookeeper table with a WHERE path IN ('path1', 'path2', ...) clause to filter results by multiple paths, for example:

SELECT * FROM system.zookeeper WHERE path IN ('/node1', '/node2')