v.24.2Improvement

Improved Memory Management and Progress Tracking for system.zookeeper Table Querying

system.zookeeper table: previously the whole result was accumulated in memory and returned as one big chunk. This change should help to reduce memory consumption when reading many rows from system.zookeeper, allow showing intermediate progress (how many rows have been read so far) and avoid hitting connection timeout when result set is big. #59545 (Alexander Gololobov).
Improved memory efficiency and progress reporting for queries on the system.zookeeper table by streaming results incrementally instead of accumulating the entire result in memory.

Why it matters

This feature addresses high memory consumption and potential connection timeouts when reading large result sets from the system.zookeeper table. It enables showing intermediate progress of rows read so far and prevents client-side issues caused by large, delayed result delivery.

How to use it

No explicit user action is required. Queries on system.zookeeper will automatically benefit from incremental result processing, reducing memory usage and improving responsiveness for large datasets.