v.18.16Improvement

Max Block Size Setting in FULL and RIGHT JOINs

Official CH changelog text
For FULL and RIGHT JOIN, the max_block_size setting is used for a stream of non-joined data from the right table. Amos Bird
The max_block_size setting is now applied to the stream of non-joined data from the right table when using FULL JOIN and RIGHT JOIN operations in ClickHouse.

Why it matters

This feature ensures that the processing of non-joined data from the right table during FULL and RIGHT JOIN is controlled and optimized by limiting the block size. It helps improve query efficiency and resource management.

How to use it

Users can control the streaming block size of non-joined data in FULL JOIN and RIGHT JOIN by setting the max_block_size parameter in their query or session settings.

Related resources

PreviousNext