ClickHouse® MergeTree on S3 – Intro and Architecture
ClickHouse datasets are getting big. Store MergeTree table data on S3 object storage to handle them economically and flexibly. Part 1 covers architecture and storage organization.
Petabyte-Scale Data in Real-Time: ClickHouse®, S3 Object Storage, and Data Lakes
These days new ClickHouse applications start with petabyte-sized datasets and scale up from there. Fortunately, ClickHouse gives you open-source tools for real-time analytics on big data: MergeTree backed by object storage as well as reading on data lakes. We’ll start…
Building A Better ClickHouse® for Parquet in Practice
A few weeks ago we discussed how to read external Parquet data from ClickHouse. The article raised some performance concerns when querying big collections of Parquet files out of AWS S3 buckets. Time flies fast. Altinity engineers have made some…
Building A Better ClickHouse®
In this article, we give a short retrospective of Altinity contributions to ClickHouse and also introduce our view on how ClickHouse should evolve to be the best database on the planet!
ClickHouse® Performance Master Class – Tools and Techniques to Speed up any ClickHouse App
ClickHouse gives impressive performance out of the box. Our webinar will show you how to make it amazing. We start by providing a framework for performance that includes basic drivers like I/O and compute, as well as ClickHouse structures like…
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
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.
Altinity Grafana Plugin for ClickHouse®: Ready for Grafana 10 and Beyond
The Altinity Grafana Plugin for ClickHouse 3.0.0 is fully compatible with Grafana 10. Find out how to get it and see the roadmap. 15M downloads can’t be wrong!
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…