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


  • 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


  • 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
Scroll to Top