v.23.7New Feature

Grace Hash Join Algorithm Enhancements for FULL and RIGHT JOINs

Grace Hash Join algorithm is now applicable to FULL and RIGHT JOINs. #49483. #51013 (lgbo).
The Grace Hash Join algorithm in ClickHouse has been extended to support FULL and RIGHT JOIN operations.

Why it matters

This enhancement enables more efficient execution of FULL and RIGHT JOIN queries by applying the Grace Hash Join algorithm, improving performance and scalability for these types of joins.

How to use it

Users can benefit from this feature automatically when performing FULL JOIN and RIGHT JOIN queries, as ClickHouse will now apply the Grace Hash Join algorithm where applicable without requiring any additional configuration.