What is ClickHouse?
ClickHouse is an open source analytic DBMS developed by Russian Internet giant Yandex (NASDAQ: YNDX). It powers multiple petabytes of data in Yandex and is a core technology of Yandex.Metrica -- one of the biggest web-analytics platforms in the world. In June 2016 Yandex released ClickHouse as an open source product, continuing to be the major contributor. Since then multiple companies deployed ClickHouse as their analytics platform often replacing popular vendor solutions.
ClickHouse has been designed for the speed and scalability. It is extremely fast in loading and querying huge amounts of data, thanks to column store, CPU level optimizations, vectorized query processing and shared-nothing cluster architecture. A lot of independent tests and benchmarks have been conducted recently, and all of them demonstrate that ClickHouse significantly outperforms existing open source and commercial offerings on similar workloads. See benchmark section for details.
In addition to outstanding performance, ClickHouse delivers a number of unique useful features that can not be found in most other DBMSs. For example, ClickHouse has array data types, build-in data sampling support, approximate uniques, aggregating materialized views, in-memory data dictionaries and other.
And last but not least -- ClickHouse is open source and free to use. There are no license costs.
ClickHouse Expertise and Tools
ClickHouse is very capable and fast DBMS but it is quite different from others. The principles of schema physical design are not like in other systems, SQL-dialect is different, efficient data load and query welcomes the understanding how ClickHouse works internally. ClickHouse lacks many features that more mature DBMSs usually have. Instead, it proposes different and often more efficient approaches to the same problems. This is where ClickHouse Expertise helps to find the optimal solutions and significantly shorten the implementation and deployment times.
Altinity delivers both Expertise to build analytic solutions, and Tools to operate them.