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.
ClickHouse® Black Magic, Part 2: Bloom Filters
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.
Announcing the New Altinity & PostHog Partnership
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…
How to Set Up a ClickHouse® Cluster with Zookeeper
One of the first when working with ClickHouse is “How do I set up my own ClickHouse cluster™?” This guide is the answer.
Statement re: recently reported vulnerabilities in ClickHouse®
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.
Fixing the Dreaded ClickHouse® Crash Loop on Kubernetes
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…
Loading 100B Rows in Minutes in Altinity.Cloud®
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…
ClickHouse® Black Magic: Skipping Indices
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…
Altinity Celebrates Company Growth in 2021 and a Great Future in 2022
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.
A Day in the Life of a ClickHouse® Query
This webinar is a gentle introduction to ClickHouse internals, focusing on topics that will help your applications run faster and more efficiently.
Altinity Quickstart for ClickHouse®! Build Your First App
About to build your first analytic app on ClickHouse? Altinity Quickstart for ClickHouse (formerly ClickHouse Bootcamp) is for you. We’ll teach you what you need to know, from installation to connecting to BI tools and Kafka.
Altinity Introduces macOS Homebrew Tap for ClickHouse®
With our new Homebrew tap, macOS developers and systems operators can type in a few commands and retrieve their preferred version of ClickHouse. Keep reading to learn how!