Support Full/Right Join with Grace Hash Join Algorithm

Why it matters

This feature enables efficient execution of FULL JOIN and RIGHT JOIN queries by leveraging the grace hash join algorithm. It addresses the lack of support for these join types in previous versions and improves query performance and functionality for complex join operations.

How to use it

Users can perform FULL JOIN and RIGHT JOIN in their SQL queries as usual. ClickHouse will automatically apply the grace hash join algorithm when these join types are used, requiring no additional configuration.