v.18.16New Feature

Added joinGet Function for Dictionary-like Access to Join Tables

Official CH changelog text
Added the joinGet function that allows you to use a Join type table like a dictionary. Amos Bird
Added the joinGet function which enables using a Join type table like a dictionary to retrieve values by key.

Why it matters

This feature solves the problem of efficiently extracting values from Join tables by key without performing a full join operation, improving query performance and simplifying syntax for users.

How to use it

Use the joinGet function by specifying the Join table, the column you want to retrieve, and the key to look up. For example:

SELECT joinGet(join_table, 'column_name', key_column) FROM table

Related resources

PreviousNext