v.20.7Improvement

joinGet now supports multi-key lookup

Official CH changelog text
Now joinGet supports multi-key lookup. #12418 (Amos Bird).
joinGet function now supports multi-key lookups, allowing users to query join tables using multiple keys simultaneously.

Why it matters

This feature enhances the joinGet function by enabling more complex join conditions with multiple keys, improving query expressiveness and performance in scenarios where multi-column keys are used for joins.

How to use it

To use this feature, call joinGet with multiple key parameters as input. This allows retrieval of values from the joined table by specifying several keys within the function call.

Related resources

PreviousNext