Joining Tables in ClickHouse
Joins are fully supported in ClickHouse with support for all standard SQL JOIN types. The syntax should look familiar, and you can view the docs page on
JOIN for all the details:
ON imdb.roles.actor_id = imdb.actors_dictionary.id
ClickHouse also provides additional non-standard SQL JOIN types useful for analytical workloads and for time-series analysis, including the
ClickHouse has 6 different algorithms for the join execution, or allow the query planner to adaptively choose and dynamically change the algorithm at runtime, depending on resource availability and usage.
For details on joins in ClickHouse, be sure to check our our series of blogs on joins.