Audience

Companies of all sizes

About ClickHouse

ClickHouse is a fast open-source OLAP database management system. It is column-oriented and allows to generate analytical reports using SQL queries in real-time. ClickHouse's performance exceeds comparable column-oriented database management systems currently available on the market. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second. ClickHouse uses all available hardware to its full potential to process each query as fast as possible. Peak processing performance for a single query stands at more than 2 terabytes per second (after decompression, only used columns). In distributed setup reads are automatically balanced among healthy replicas to avoid increasing latency. ClickHouse supports multi-master asynchronous replication and can be deployed across multiple datacenters. All nodes are equal, which allows avoiding having single points of failure.

Other Popular Alternatives & Related Software
MongoDB
MongoDB
(20 Ratings)
MongoDB is a general purpose, document-based, distributed database built for modern application developers and for the cloud era. No database is more productive to use. Ship and iterate 3–5x faster with our flexible document data model and a unified query interface for any use case. Whether it’s your first customer or 20 million users around the world, meet your performance SLAs in any environment. Easily ensure high availability, protect data integrity, and meet the security and compliance standards for your mission-critical workloads. An integrated suite of cloud database services that allow you to address a wide variety of use cases, from transactional to analytical, from search to data visualizations. Launch secure mobile apps with native, edge-to-cloud sync and automatic conflict resolution. Run MongoDB anywhere, from your laptop to your data center.
Learn more
Amazon Redshift
Amazon Redshift
Amazon Redshift is a cloud-based data warehouse solution from AWS designed to deliver high-performance analytics and support modern AI-driven workloads. The platform enables organizations to analyze large volumes of structured and unstructured data across data warehouses, data lakes, and third-party sources using SQL. Redshift is built for scalability and cost efficiency, offering improved throughput and price-performance with AWS Graviton-powered RG instances and Redshift Serverless options. The solution also supports near real-time analytics through zero-ETL integrations that connect operational databases, streaming services, and enterprise applications without complex data pipelines. Amazon Redshift integrates with Amazon SageMaker and Amazon Bedrock to support advanced machine learning, analytics, and generative AI use cases.
Learn more
StarTree
StarTree
StarTree, powered by Apache Pinot™, is a fully managed real-time analytics platform built for customer-facing applications that demand instant insights on the freshest data. Unlike traditional data warehouses or OLTP databases—optimized for back-office reporting or transactions—StarTree is engineered for real-time OLAP at true scale, meaning: - Data Volume: query performance sustained at petabyte scale - Ingest Rates: millions of events per second, continuously indexed for freshness - Concurrency: thousands to millions of simultaneous users served with sub-second latency With StarTree, businesses deliver always-fresh insights at interactive speed, enabling applications that personalize, monitor, and act in real time.
Learn more
Databricks
Databricks
The Databricks Data Intelligence Platform allows your entire organization to use data and AI. It’s built on a lakehouse to provide an open, unified foundation for all data and governance, and is powered by a Data Intelligence Engine that understands the uniqueness of your data. The winners in every industry will be data and AI companies. From ETL to data warehousing to generative AI, Databricks helps you simplify and accelerate your data and AI goals. Databricks combines generative AI with the unification benefits of a lakehouse to power a Data Intelligence Engine that understands the unique semantics of your data. This allows the Databricks Platform to automatically optimize performance and manage infrastructure in ways unique to your business. The Data Intelligence Engine understands your organization’s language, so search and discovery of new data is as easy as asking a question like you would to a coworker.
Learn more

Pricing

Free Version:
Free Version available.

Integrations

See Integrations

Ratings/Reviews - 1 User Review

Overall 5.0 / 5
ease 3.0 / 5
features 4.0 / 5
design 5.0 / 5
support 5.0 / 5
More Reviews Write a Review

Company Information

ClickHouse
Founded: 2021
United States
clickhouse.com

Videos and Screen Captures

ClickHouse Screenshot 1
ClickHouse Screenshot 1
Other Useful Business Software
PRTG Catches Network Issues Before They Cause Downtime Icon
PRTG Catches Network Issues Before They Cause Downtime

Threshold-based alerts flag problems early, so your team can act before users notice, not after.

Reactive troubleshooting usually means hearing about a problem from frustrated users, not your monitoring tool. PRTG sets threshold-based alerts across devices, servers and applications, notifying your team by email, SMS or push the moment a metric crosses a set limit. That means catching a failing disk or overloaded server before it becomes an outage and getting time back from firefighting. Start a free trial and set your first alerts today.
Download 30-Day Trial

Product Details

Platforms Supported
Cloud
On-Premises

ClickHouse Frequently Asked Questions

Q: What kinds of users and organization types does ClickHouse work with?
Q: What languages does ClickHouse support in their product?
Q: What other applications or services does ClickHouse integrate with?

ClickHouse Product Features

Database

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

ClickHouse Verified User Reviews

Write a Review
  • Ramazan P.
    Solution Architect
    Used the software for: 2+ Years
    Frequency of Use: Weekly
    User Role: User, Administrator
    Company Size: 20,000 or More
    Design
    Ease
    Features
    Pricing
    Support
    Probability You Would Recommend?
    1 2 3 4 5 6 7 8 9 10

    "Best in class"

    Posted 2022-01-08

    Pros: 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!

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

    Overall: 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.

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