Turning Pages of 2021

Turning Pages of 2021

2021 was so far the best year for Altinity and ClickHouse. Sitting with a glass of wine in front of the fire and overlooking the Christmas tree or a snowstorm behind the icy window, let’s remember what has happened.

Altinity.Cloud Extends Managed ClickHouse to ARM

Altinity.Cloud Extends Managed ClickHouse to ARM

ARM processors are hot. Amazon AWS and Apple have been building their own ARM processors for a few years already. Today we are happy to announce the first ever managed ClickHouse on ARM!

Ultra-Fast Data Loading and Testing in Altinity.Cloud

Ultra-Fast Data Loading and Testing in Altinity.Cloud

Learn how you can load and test ClickHouse datasets with lightning speed and leverage the power of cloud operation with this Altinity.Cloud tutorial. PS…You’ll find it’s really easy too!

Altinity.Cloud Extends to GCP

Altinity.Cloud Extends to GCP

We launched Altinity.Cloud a year ago, providing the first-ever fully managed ClickHouse service in AWS. Since then we have continued to improve the product. Today, we are happy to announce Altinity.Cloud at Google Compute Platform, the first-ever multi-cloud managed ClickHouse offering!

ClickHouse Altinity Stable 21.8

ClickHouse Altinity Stable 21.8

Today we annouce ClickHouse Altinity Stable release 21.8. This release is a significant upgrade since the previous Altinity Stable release. It includes 1472 pull requests from 224 contributors. Continue reading for full release notes.

Tips for High-Performance ClickHouse Clusters with S3 Object Storage

Tips for High-Performance ClickHouse Clusters with S3 Object Storage

ClickHouse often runs in a cluster, and cluster operation poses some interesting questions regarding S3 usage. They include parallelizing data load across nodes, benefits of horizontal vs. vertical scaling, and avoiding unnecessary replication. In this article, we will discuss how ClickHouse clusters can be used with S3 efficiently thanks to two important new features: the ‘s3Cluster‘ table function and zero-copy replication.

ClickHouse at LifeStreet: Performance Marketing is as Strong as Your Data Platform
·

ClickHouse at LifeStreet: Performance Marketing is as Strong as Your Data Platform

We live in a rapidly changing world. The ability to discover and apply business-critical insights from petabyte datasets in real-time is now a key factor in many businesses. Digital marketing is no exception. In fact, digital marketing is now one of the major sources of Big Data. In this article, we will explain how ClickHouse is used by the digital marketing company LifeStreet.

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[…]