What is ClickHouse®?

Open Source Meets SQL Column Stores.

ClickHouse is the first open source SQL data warehouse to match the performance, maturity, and scalability of proprietary databases like Sybase IQ, Vertica, and Snowflake.

Get objective advice on the best solution for you. Altinity can help you evaluate different databases. We discuss your use case and see if ClickHouse could fit your requirements. Learn more about ClickHouse POC and evaluative support.

New to ClickHouse? Start with this video series that covers just how fast ClickHouse is, how to install ClickHouse on Ubuntu, and why you would need a Data Warehouse.

These state-of-the-art features are built into ClickHouse:

  • Column storage that handles tables with trillions of rows and thousands of columns
  • Compression and codecs to reduce I/O dramatically
  • Linear scaling through vectorized query and sharding
  • Fault-tolerance and read scaling thanks to built-in replication
  • Fast ingestion with data instantly queryable after INSERT
  • Outstanding aggregation through materialized views
  • Features to solve real-world problems like funnel analytics and last point queries

ClickHouse development is driven by a community consisting of hundreds of contributors focused on solving real problems, not implementing corporate roadmaps.

Get Low Latency Analytics Everywhere

ClickHouse excels at business problems that require consistent low-latency response across petabyte tables. It can handle data arrival rates of millions of rows per second. Achievable response times include:

  • Ad-Hoc queries on source data: 1 second or less
  • Queries on aggregates:  10 milliseconds or less
  • Ingestion to query response: 500 milliseconds

ClickHouse dominates in use cases like web analytics, real-time network management, service log analysis, real-time ad bidding, asset valuation in financial markets, and security threat identification. 

ClickHouse is Developer Friendly

Thanks to Apache 2.0 licenses for ClickHouse and ecosystem projects, developers can build innovative analytics without spending a cent for proprietary licenses or expensive cloud services. However, there’s a lot more to make a developer happy:

  • Builds that install in 60 seconds or less
  • Run ClickHouse and your entire analytic stack in Kubernetes
  • Robust client connectivity: Python, Javascript, C++, Golang, Java, ODBC
  • Simple integration with Kafka for rapid data ingestion
  • A wealth of features designed to solve problems like funnel analysis, last point queries, and pivoting results
  • Ability to read directly from S3, MySQL, PostgresQL, Redis, and ODBC data sources
  • Tight integration with popular visualization tools like Grafana, Superset, and Tableau.

Get Unrivaled Cost-Efficiency and Flexibility with ClickHouse

ClickHouse runs anywhere that Linux does: public clouds, Kubernetes, and on-prem environments. Resource stingy algorithms keep operating costs low while maximizing performance on available hardware. The permissive Apache 2.0 license makes ClickHouse an ideal choice for applications ranging from multi-tenant cloud services to embedded applications.

Want to learn the ClickHouse fundamentals?

Check out video series and receive a complete introduction to ClickHouse for developers. Upon completion, you will be able to:

  • Design tables and load data into them, including CSV and JSON
  • Issue a wide range of analytic queries and improve their performance – use features like compression, materialized views, and indexes effectively
  • Understand how to integrate ClickHouse with Kafka
  • Design schema and issue queries on ClickHouse clusters.
5 star rating
5 star rating
5 star rating
5 star rating
5 star rating
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.
Adam Brown
CTO, Mux.com

Get Your Free Consultation with a ClickHouse Expert.

Altinity can help you determine if ClickHouse fits your requirements, and we’ll show you the key benefits of using ClickHouse for your specific data analytics application.