ClickHouse is a column-oriented database management system designed for online analytical processing of queries (OLAP). Database guru Robert Hodges referred to it as the first open-source SQL data warehouse.  

ClickHouse is said to be nearly 1000X faster than the traditional DBMS system and scales to hundreds of petabytes. It runs on shared-nothing architecture and stores data in columns. Some of the world’s largest organizations use it, including its founder Yandex.   

Project Background

• Platform: ClickHouse 
• Author: ClickHouse, Inc. Yandex
• Released: June 2016
• Type: SQL data warehouse
• License: Apache License 2.0
• Supports: Linux, FreeBSD, or Mac OS X with x86_64, AArch64, or PowerPC64LE CPU architecture
• Language: C++
• GitHub: /ClickHouse
• Runs on: Multi-platform

Features

• Data compression
• Disk storage of data
• Parallel processing on multiple cores
• Distributed processing on multiple servers
• Vector computation engine
• Suitable for online queries
• Real-time data updates

Summary

• Works with tables containing a large number of columns 
• Rare queries 
• Small Column values, consisting of numbers and short strings
• Need high throughput from a single-query processing 
• Filtered or aggregated query result
• Batch-only transactions