v.22.8Improvement

Added LEFT SEMI and LEFT ANTI Join Support for EmbeddedRocksDB Tables

Official CH changelog text
Added support of LEFT SEMI and LEFT ANTI direct join with EmbeddedRocksDB tables. #38956 (Vladimir C).
Added support for LEFT SEMI and LEFT ANTI direct joins with EmbeddedRocksDB tables in ClickHouse.

Why it matters

This feature enables users to perform LEFT SEMI and LEFT ANTI joins directly on EmbeddedRocksDB tables, expanding join capabilities and improving query flexibility when working with these table engines.

How to use it

Users can now use the LEFT SEMI and LEFT ANTI join types in their SQL queries when joining with EmbeddedRocksDB tables without additional configuration.

Related resources

PreviousNext