ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.


  • Blazing Fast
  • Linearly Scalable
  • Hardware Efficient
  • Fault Tolerant
  • Feature Rich
  • Highly Reliable
  • Simple and Handy

Key Features

  • True column-oriented storage
  • Vectorized query execution
  • Data compression
  • Parallel and distributed query execution
  • Real time query processing
  • Real time data ingestion
  • On-disk locality of reference
  • Cross-datacenter replication
  • High availability
  • SQL support
  • Local and distributed joins
  • Pluggable external dimension tables
  • Arrays and nested data types
  • Approximate query processing
  • Probabilistic data structures
  • Full support of IPv6
  • Features for web analytics
  • State-of-the-art algorithms
  • Detailed documentation
  • Clean documented code

When to use ClickHouse

For analytics over stream of clean, well structured and immutable events or logs. It is recommended to put each such stream into a single wide fact table with pre-joined dimensions.

Some examples of viable applications:

  • Web and App analytics
  • Advertising networks and RTB
  • Telecommunications
  • E-commerce and finance
  • Information security
  • Monitoring and telemetry
  • Time series
  • Business intelligence
  • Online games
  • Internet of Things

When NOT to use ClickHouse

  • Transactional workloads (OLTP)
  • Key-value access with high request rate
  • Blob or document storage
  • Over-normalized data