What is ClickHouse?

ClickHouse is a highly efficient, open-source OLAP database management system that is specifically engineered for rapid data processing. Its unique column-oriented design allows users to generate analytical reports through real-time SQL queries with ease. In comparison to other column-oriented databases, ClickHouse demonstrates superior performance capabilities. This system can efficiently manage hundreds of millions to over a billion rows and can process tens of gigabytes of data per second on a single server. By optimizing hardware utilization, ClickHouse guarantees swift query execution. For individual queries, its maximum processing ability can surpass 2 terabytes per second, focusing solely on the relevant columns after decompression. When deployed in a distributed setup, read operations are seamlessly optimized across various replicas to reduce latency effectively. Furthermore, ClickHouse incorporates multi-master asynchronous replication, which supports deployment across multiple data centers. Each node functions independently, thus preventing any single points of failure and significantly improving overall system reliability. This robust architecture not only allows organizations to sustain high availability but also ensures consistent performance, even when faced with substantial workloads, making it an ideal choice for businesses with demanding data requirements.

Pricing

Free Version:
Free Version available.

Screenshots and Video

ClickHouse Screenshot 1

Company Facts

Company Name:
ClickHouse
Date Founded:
2021
Company Location:
United States
Company Website:
clickhouse.com

Product Details

Deployment
SaaS
On-Prem

Product Details

Target Company Sizes
Individual
1-10
11-50
51-200
201-500
501-1000
1001-5000
5001-10000
10001+
Target Organization Types
Mid Size Business
Small Business
Enterprise
Freelance
Nonprofit
Government
Startup
Supported Languages
English

ClickHouse Categories and Features

Database Software

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

ClickHouse Customer Reviews

Write a Review
  • Reviewer Name: Ramazan P.
    Position: Solution Architect
    Has used product for: 2+ Years
    Uses the product: Weekly
    Org Size (# of Employees): 20,000 or More
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Best in class

    Date: Jan 08 2022
    Summary

    ClickHouse is my go to database for all my projects. Although it does not support ACID, you can fire a PostgreSQL and create a link to it, then use it like a local database.

    Positive

    ClickHouse is really really fast. I can say that it is THE fastest I've came across. It has lots of native integration options S3, Kafka, SQLite, PostgreSQL and so on. Its SQL capabilities are top notch. And it is 100% free!

    Negative

    - Updates and deletes are eventual.
    - Hard to setup a cluster.
    - Does not have ACID.

    Read More...
  • Previous
  • You're on page 1
  • Next