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
How ClickHouse processes queries: MergeTree parts, sparse indexes, aggregation hash tables, joins, and distributed execution — with performance tuning tips.
Altinity Quickstart for ClickHouse®! Build Your First App
ClickHouse quickstart for developers: install, connect, create tables, load data, run queries, and tune performance to build your first app.
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!
Database on Fire: Reflections on Embedding ClickHouse® in Firebolt
Review of Ben Wagner presenting How We Built Firebolt. Firebolt embedded ClickHouse as their query engine!
Connecting ClickHouse® to External Data Sources using the JDBC Bridge
ClickHouse is never used as a standalone – it integrates with other data sources and exposes query results to applications. Upstream data for OLAP is sometimes in relational databases like MSQL SQL Server. The JDBC and ODBC bridges provide a…
Redpanda and a ClickHouse® Operator UI: December ‘21 SF Bay Area ClickHouse Meetup
The final SF Bay Area ClickHouse Meetup for 2021 took place on December 15th. We had talks on Redpanda event streaming to ClickHouse as well as Altinity Dashboard, a new UI for the ClickHouse Kubernetes Operator.