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 an open source technology. In that article Rick used the popular Star Schema Benchmark (SSB). […]

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 to ClickHouse using the Mondrian OLAP server. This approach has been pioneered in Sergei Semenkov’s[…]

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 changed as well, but fortunately most changes were good.

High Performance, High Reliability Data Loading on ClickHouse

High Performance, High Reliability Data Loading on ClickHouse

Arrays are a prominent ClickHouse SQL extension that can accelerate query speed up to 100x in well-chosen use cases. This webinar introduces ClickHouse arrays and shows how to use them effectively. We provide examples of idiomatic usage and guides you on use cases where you should immediately reach for arrays. Please join us to become a power user of this popular ClickHouse feature.

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 to other systems (aka a data lake) and offer cheap and highly durable storage for table data. ClickHouse now supports both of these uses for S3 compatible object storage.

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 research results.

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 is 1.3 billion rows.

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 release.