v.21.3Improvement
Supports path IN expressions for system.zookeeper table
Supportspath IN (set)expressions forsystem.zookeepertable. #20105 (小路).
Why it matters
This feature allows users to filter rows from thesystem.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 thesystem.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')