v.24.5New Feature

Support Inequal Conditions in Join Operations

Official CH changelog text
Support join with inequal conditions which involve columns from both left and right table. e.g. t1.y < t2.y. To enable, SET allow_experimental_join_condition = 1. #60920 (lgbo).
Support for join operations with inequality conditions involving columns from both the left and right tables, such as t1.y < t2.y.

Why it matters

This feature allows users to perform more flexible join queries that include inequality conditions between columns of joined tables, expanding beyond traditional equi-joins. It enables more complex data relationships to be expressed and queried efficiently in ClickHouse.

How to use it

To enable join with inequality conditions, set the session parameter using:

SET allow_experimental_join_condition = 1;

After enabling, you can write join clauses with inequality conditions, for example:

SELECT * FROM t1
JOIN t2 ON t1.y < t2.y

Related resources

PreviousNext