Altinity Stable Release™ Update 20.3.19.4

We are delighted to announce that Altinity Stable Release is updated to 20.3.19.4. This release includes several dozen bug fixes not present in the previous 20.3.12.112.

Read More
ClickHouse vs Redshift Performance for FinTech Risk Management

ClickHouse SQL extensions, arrays, in particular, allow it to solve the business use case up to 100 times more efficiently than Redshift at 1/6th the cost. We know that ClickHouse is fast, but we were a bit surprised by these research results.

Read More
ClickHouse and Redshift Face Off Again in NYC Taxi Rides Benchmark

Being that it has been roughly three years since we last compared ClickHouse to Amazon Redshift, we thought it was time for an update. Using the same popular benchmarking dataset of NYC taxi trips data over multiple years, current size is 1.3 billion rows.

Read More
ClickHouse Birthday Altinity Stable Release 20.3.12.112

HAPPY BIRTHDAY, ClickHouse! In honor of ClickHouse turning 4, we have prepared several presents for ClickHouse users and ClickHouse itself: new releases of ClickHouse operator for Kubernetes, the Grafana ClickHouse Datasource and last but not least, the new Altinity Stable ClickHouse release.

Read More
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 utility. In this article, I will explain two new cool ClickHouse features that completely change the way how dictionaries can be used. Change in a good sense, of course.

Read More
Altinity Stable Release is updated to 19.16.19.85

We are delighted to announce that Altinity Stable Release is updated to 19.16.17.85. The release includes several bug fixes not present in the previous 19.16.14.65 release.

Read More
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 in a “ClickHouse way.”

Even now, ClickHouse updates are asynchronous, which makes them difficult to use in interactive applications. Still, in many use cases users need to apply modifications to existing data and expect to see the effect immediately. Can ClickHouse do that? Sure it can.

Read More
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 or as of the same day yesterday and so on. Financial market data analysis and all sorts of monitoring applications are typical examples.

Databases have different ways to achieve this task and ClickHouse is not an exception here. In fact, ClickHouse offers at least 5 different approaches. In this article, we will review and compare them.

Read More
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.

Read More
ClickHouse Cost-Efficiency in Action: Analyzing 500 Billion Rows on an Intel NUC

Jan 1, 2020
Cost-efficiency and performance are critical for big data analytics. For this reason a recent blog post from ScyllaDB guys caught our attention. They collected over 500 billion data points and were able to query it with 1B rows/sec query scan performance. The test rig was a beefy and expensive packet.com cluster: 83 n2.xlarge.x86 instances, 28 cores and 384RAM each. This is a nice demo of ScyllaDB cluster management. But looking at the numbers we realized it’s not very impressive as an example of efficient analytics. We can prove that using ClickHouse.

Read More
Altinity Stable Releases repository and new 19.13.7.57 Altinity Stable ClickHouse

Altinity is glad to announce the certification of 19.13.7.57 ClickHouse release as Altinity Stable. This is a minor upgrade over the previous 19.11.8 release, but we recommend users install it before moving to more recent releases due to a few important fixes and changes. 

Read More
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 have been developed for many applications in Kubernetes, including some databases. As a result, operators became a successful pattern for managing cloud native applications. 

Read More