ClickHouse® Altinity Stable Release 21.3

ClickHouse® Altinity Stable Release 21.3

A few months ago we certified ClickHouse 21.1 as an Altinity Stable release. Since then, we have worked on newer releases and run them in-house. We completed several new features, and even more have been added by community contributors.

ClickHouse® Altinity Stable Release 21.1

ClickHouse® Altinity Stable Release 21.1

The latest ClickHouse Altinity Stable Release 21.1 introduces significant new security features like LDAP external users directory, AES encryption functions along with MergeTree features, SQL compatibility, backward incompatible changes, and more.

ClickHouse® Nails Cost Efficiency Challenge Against Druid & Rockset

ClickHouse® Nails Cost Efficiency Challenge Against Druid & Rockset

Rick Bilodeau from Imply published an excellent article in June 2020 comparing Druid cost-efficiency to Google Big Query for what they called ‘hot analytics’ — sub-second response time with high query concurrency. We appreciate this effort and great results of…

Accessing ClickHouse® from Excel using Mondrian ROLAP engine

Accessing ClickHouse® from Excel using Mondrian ROLAP engine

ClickHouse is a very powerful database for analytics. Microsoft Excel is one of the world’s most popular business applications. There are several ways to bring ClickHouse data to Excel spreadsheets. In this article we will explain how to connect Excel…

New Year Greetings and ClickHouse® Updates

New Year Greetings and ClickHouse® Updates

The year 2020 has been a tough one for the world. It changed the way people work, communicate and travel. It taught us to care more about family, friends, and colleagues. It highlighted the fragility of our world. Altinity and…

ClickHouse® and S3 Compatible Object Storage

ClickHouse® and S3 Compatible Object Storage

ClickHouse is a polyglot database that can talk to many external systems using dedicated engines or table functions. In modern cloud systems, the most important external system is object storage. It can hold raw data to import from or export…

Altinity Stable® Release Update 20.3.19.4

Altinity Stable® Release Update 20.3.19.4

We are delighted to announce that the ClickHouse 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.

ClickHouse® vs Redshift Performance for FinTech Risk Management

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…

ClickHouse® Birthday Altinity Stable Release 20.3.12.112

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® Dictionaries, Reloaded!

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…