Handling Real-Time Updates in ClickHouse

Handling Real-Time Updates in ClickHouse

Mutable data is generally unwelcome in OLAP databases. ClickHouse is no exception to the rule. Like some other OLAP products, ClickHouse did not even support updates originally. Later on, updates were added, but like many other things they were added…

Five Ways to Handle as-of Queries in ClickHouse

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…

Altinity Stable Release update 19.16.14.65

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.

Altinity ClickHouse Operator at Red Hat’s OperatorHub.io

Altinity ClickHouse Operator at Red Hat’s OperatorHub.io

CoreOS introduced operators for Kubernetes in 2016. A Kubernetes Operator is an application that integrates into Kuberentes and manages other applications. It significantly simplifies deployment and management of cloud native apps by leveraging application specific operational knowledge. Since then operators…

ClickHouse New Home

ClickHouse New Home

It is already more than 3 years since ClickHouse surprisingly popped up from inside the Yandex labs and moved to open source. Since then it grew up from an ugly duckling, that was sometimes not that easy to deal with,…

Moscow Meetup, Cutting Edge ClickHouse Features and Roadmap

Moscow Meetup, Cutting Edge ClickHouse Features and Roadmap

The recent Moscow ClickHouse meetup was quite a big event, as expected. ClickHouse is very popular in Russia and usage has penetrated widely among companies here.  450 people registered, and around 200 showed up at the Yandex conference hall on…

New Encodings to Improve ClickHouse Efficiency

New Encodings to Improve ClickHouse Efficiency

July 10, 2019Modern analytical databases would not exist without efficient data compression. Storage gets cheaper and more performant, but data sizes typically grow even faster. Moore’s Law for big data outperforms its analogy in hardware. In our blog we already…

Handling Variable Time Series Efficiently in ClickHouse

Handling Variable Time Series Efficiently in ClickHouse

May 23, 2019ClickHouse offers incredible flexibility to solve almost any business problem in a multiple of ways. Schema design plays a major role in this. For our recent benchmarking using the Time Series Benchmark Suite (TSBS) we replicated TimescaleDB schema…

Altinity ClickHouse Operator for Kubernetes

Altinity ClickHouse Operator for Kubernetes

Apr 9, 2019When I was setting up my first ClickHouse clusters 3 years ago it was like a journey to an unknown world full of caveats. ClickHouse is very simple and easy to use but not THAT simple. Sometimes I…

A Magical Mystery Tour of the LowCardinality Data Type

A Magical Mystery Tour of the LowCardinality Data Type

Mar 27, 2019Many ClickHouse features like LowCardinality data type seem mysterious to new users.  ClickHouse often deviates from standard SQL and many data types and operations do not even exist in other data warehouses. The key to understanding is that…