ClickHouse Primary Keys

Nov 27, 2017
In this tutorial, our guest blogger Yegor Andreenko (@f1yegor) is talking about The ClickHouse Primary keys.

  • How many columns could primary key have? And what is a layout of data on storage drive? Are there any theoretical/practical limits?
  • Could columns with missing data at some rows be part of the primary key?

Read More
ClickHouse AggregateFunctions and Aggregate State

Jul 10, 2017   
The guest article from ClickHouse evangelist Yegor Andreenko (@f1yegor) about an interesting extension of aggregate functions aggregate states, that can be used to pre-aggregate data that usually has to be kept in raw, like uniques.

Read More