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.
Altinity ClickHouse Expertise and Tools
ClickHouse is very capable and fast DBMS but it is quite different from other databases. The principles of schema physical design are not like in other systems, SQL-dialect is a bit different, efficient data load and query comes from the understanding how ClickHouse works internally. ClickHouse lacks many features that more mature databases 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.
Need help with ClickHouse?
Want to get a proof of concept and evaluation support?
✉ Contact Altinity team at Info@altinity.com
✆ +1 628 400 4455 (USA) or +44 (0) 2036 087444 (UK)
Switching to Clickhouse has allowed us to reduce costs, improve performance, as well as unlock features we would have never been able to deliver with existing systems. Clickhouse has successfully replaced several of our systems, both internal and customer-facing, and has become Mux's default for analytics workloads.