ClickHouse

    ClickHouse® Dictionaries, Reloaded!

    ClickHouse external dictionaries are a “ClickHouse way” to handle multi-dimensional schema. ClickHouse Dictionaries Explained was the very first article in the Altinity blog three years ago. ClickHouse has improved significantly since then, and dictionaries have achieved a new level of…

    SQL for ClickHouse DBA

    My name is Meo and I’ve been a DataBase Administrator (DBA) for the last 35 years of my life. After getting a degree at the University in Turin (Italy) many years ago, I started working with relational databases, and I’m…

    Monitoring ClickHouse® on Kubernetes with Prometheus and Grafana

    The ClickHouse Kubernetes operator is great at spinning up data warehouse clusters on Kubernetes. Once they are up, though, how can you see what they are actually doing? It’s time for monitoring!In this article we’ll explore how to configure two…

    ·

    ClickHouse® Kafka Engine FAQ

    Kafka is a popular way to stream data into ClickHouse. ClickHouse has a built-in connector for this purpose — the Kafka engine. This article collects typical questions that we get in our support cases regarding the Kafka engine usage. We…

    Five Ways to Handle as-of Queries in ClickHouse®

    A common use case in time series applications is to get the measurement value at a given point of time. For example, if there is a stream of measurements, one often needs to query the measurement as of current time…

    Webinar: ClickHouse® Monitoring 101. What to monitor and how

    You are about to deploy ClickHouse into production. Congratulations! But what about monitoring? In this webinar we will introduce how to track the health of individual ClickHouse nodes as well as clusters. We’ll describe available monitoring data, how to collect…

    Altinity Stable® Release update 19.16.14.65

    We are delighted to announce that Altinity Stable Release is updated to 19.16.14.65. The release includes several important bug fixes not present in the previous 19.16.12.49, and one compatibility fix that is important for future upgrades.

    Real-time Moving Average with ClickHouse® Live Views

    In data analytics, analysts often use moving averages. Moving averages help to smooth data series as well as identify long term trends. New Live View tables start to bring real-time capabilities to ClickHouse.One of the applications of Live View tables…

    ClickHouse® February Community Events

    US-based 2020 ClickHouse meetups started the year with a bang: two events in San Francisco and New York City. Here is a summary of the talks including links to presentation slides.