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 and Redshift Face Off Again in NYC Taxi Rides Benchmark

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…

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…

Altinity Stable Release is updated to 19.16.19.85

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.