Hash tables

ClickHouse's Hash Join Stores the Right Table as 64-bit Row Words

Oct 22, 2026 19 min read Jay Hubbert

The ClickHouse hash join keeps the right table as blocks and stores one tagged 64-bit row word per hash-table cell.

ClickhousePerformanceInternalsJoinsHash tables

Read more →