Math Games in ClickHouse — Solving Project Euler Problems

Math Games in ClickHouse — Solving Project Euler Problems

ClickHouse is an extremely versatile DBMS. When presenting it to newbies, I sometimes describe it as a combination of four “F”-s: Fast, Flexible, Fun and Free. We often benchmark ClickHouse in different scenarios to demonstrate how fast it is. Case…

Altinity Stable Release 23.3.19

Altinity Stable Release 23.3.19

As part of our release support plan, we are glad to announce two new releases of ClickHouse 23.3 built by Altinity: 23.3.19.33.altinitystable and 23.3.19.34.altinityfips.

Reading External Parquet Data from ClickHouse

Reading External Parquet Data from ClickHouse

ClickHouse support for Apache Parquet is outstanding. We blogged about it last year in “What’s Up With Parquet Performance in ClickHouse”. In this article, we will look at Parquet from a different perspective. Let’s say there is public Parquet data…

Deep Dive on ClickHouse Sharding and Replication

Deep Dive on ClickHouse Sharding and Replication

ClickHouse works out of the box on a single machine but gets complicated in a cluster. ClickHouse provides two scaling-out dimensions — sharding and replication — and understanding when and how those should be applied is vital for production and…