ClickHouse® AggregateFunctions and Aggregate State

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.

ClickHouse® Data Distribution

ClickHouse® Data Distribution

Jun 5, 2017   ClickHouse data distribution and replication are fundamental techniques for building reliable and scalable ClickHouse systems. In this article we will explain how it works from the user perspective

ClickHouse® Dictionaries Explained

ClickHouse® Dictionaries Explained

Apr 12, 2017   One of the most useful ClickHouse features is external dictionaries. They are extremely powerful, and if used efficiently may lead to quite elegant designs. I will lead you through the dictionaries using few examples that highlight basic…