Who and Why is Using ClickHouse®
In this article we discover several companies that are using ClickHouse in production for different use cases.
ClickHouse® 1.1.54245 release
Few weeks ago Yandex released ClickHouse 1.1.54245 that included a number of features requested by community. The new deb packages are available from Yandex repo and RPMs from Altinity repo. So let’s see what’s new in this release. New features…
ClickHouse® AggregateFunctions and Aggregate State
Jul 10, 2017 The guest article from ClickHouse evangelist Yegor Andreenko (@f1yegor) about an interesting extension of aggregate functions aggregate states, that can be used to pre-aggregate data that usually has to be kept in raw, like uniques.
ClickHouse® vs Amazon RedShift Benchmark #2: STAR2002 dataset
Jul 3, 2017 We continue to benchmark ClickHouse against other analytic DBMSs. We were inspired by the benchmark with star2002 experiment dataset described here, and decided to replicate it using ClickHouse. That gives another interesting comparison vs Amazon RedShift.
ClickHouse® in a general analytical workload (based on Star Schema Benchmark)
Jun 26, 2017 In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
ClickHouse® vs Amazon RedShift Benchmark
Jun 19, 2017 We continue benchmarking ClickHouse. In this article we discuss a benchmark against Amazon RedShift.
ClickHouse® Data Distribution
Jun 5, 2017 ClickHouse data distribution and replication are fundamental techniques for building reliable and scalable ClickHouse systems. In this article we will explain how it works from the user perspective
ClickHouse® Release Notes
ClickHouse is an exellent DBMS with very smart people working on it. Unfortunately, it still lacks some important communication procedures, and arguable the most wanted one is release notes. Altinity mission is to make ClickHouse use easy for everbody, and we…
Altinity ClickHouse® Repository
We are pleased to announce that Altinity repository hosting ClickHouse RHEL/CentOS RPMs as well as packages for Fedora is available at packagecloud
ClickHouse® Dictionaries Benchmarking
Apr 26, 2017 There are few ClickHouse benchmarks in the web already. Most of them use denormalized database schema. However, in denormalization is not always possible or desirable. In this article we will compare the query performance between denormalized and…
ClickHouse® Dictionaries Explained
One of the most useful ClickHouse features is external dictionaries. They are extremely powerful, and if used efficiently may lead to quite elegant designs. I will lead you through the dictionaries using few examples that highlight basic and advanced usage…