ClickHouse Aggregation Fun, Part 1: Internals and Handy Tools
Summarization is a powerful tool for understanding masses of data. Learn how to make this process efficient and fast through ClickHouse — in part 1 of our ClickHouse aggregation series.
Summarization is a powerful tool for understanding masses of data. Learn how to make this process efficient and fast through ClickHouse — in part 1 of our ClickHouse aggregation series.
Bloom filters are an important ClickHouse index type with mysterious parameters. Take a closer look at the theory behind bloom filters, parameter selection using queries on a test dataset, and effective tuning.
Today we’re excited to officially announce our partnership with PostHog. We’ve worked with PostHog’s teams on this integration and have collaborated on ClickHouse-related topics since 2020. It’s great to be able to share with the wider open source analytics community what we’ve been working on together.
One of the first when working with ClickHouse is “How do I set up my own ClickHouse cluster™?” This guide is the answer.
Hacker News published a report detailing ClickHouse vulnerabilities. The good news – these were fixed months ago, and the latest Altinity Stable Builds are already updated so they are not affected.
As countless ClickHouse users have learned, Kubernetes is a great platform for data. It’s portable to almost every IT environment. But there’s still the occasional dark cloud. One of these is pod crash loops, which arise when a ClickHouse pod crashes on startup. This article shows how to diagnose and fix them.
A few weeks ago the SingleStore team published interesting research in their blog. They demonstrated how to load 100 billion rows in a database in 10 minutes. While it did not seem outstanding for ClickHouse, we were intrigued to learn how much faster we can accomplish the same task, so we conducted some experiments in Altinity.Cloud.
ClickHouse indices are different from traditional relational database management systems. Instead, ClickHouse uses secondary ‘skipping’ indices. Those are often confusing and hard to tune even for experienced ClickHouse users.
In this article we will dive into skipping indices and learn some of ClickHouse black magic.
Read Altinity’s 2021 earnings report to learn more about YoY increase in ClickHouse service bookings and Altinity.Cloud subscriptions, product milestones, and plans for 2022.
Presentation slides from webinar hosted on February 10,2021.
This webinar is a gentle introduction to ClickHouse internals, focusing on topics that will help your applications run faster and more efficiently.
Presentation slides from webinar hosted on October 6, 2021.