ClickHouse Reviews

Name: ClickHouse
Brand: ClickHouse
Rating: 4.4 (11 reviews)

4.4 out of 5

11 reviews
100% willing to recommend

What is ClickHouse?

ClickHouse is renowned for its speed, scalability, and real-time query performance. Its compatibility with SQL standards enhances flexibility while enabling integration with popular tools.

Get the ClickHouse Buyer's Guide and find out what your peers are saying about ClickHouse, MySQL, PostgreSQL and more!

ClickHouse is the #6 ranked solution in top Open Source Databases and #11 ranked solution in top Vector Databases solutions. PeerSpot users give ClickHouse an average rating of 8.8 out of 10. ClickHouse is most commonly compared to MySQL: ClickHouse vs MySQL. ClickHouse is popular among the large enterprise segment, accounting for 51% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a computer software company, accounting for 24% of all views.

Helped 861,524 peers since 2012

Featured ClickHouse reviews

Aswini Atibudhi

Distinguished AI Leader at Walmart Global Tech at Walmart

The basic challenge for ClickHouse is the documentation, which isn't ideal, but it's mature and stable with more columnar storage, compression, and parallel processing, making it the best for OLAP. In terms of improvements, it's not designed for very frequent small writes, making it less scalable in write-intensive workloads, and it's not flourishing in transactional use cases or when ingesting streaming data, such as batching or buffering, which is something ClickHouse will improve.

Read full review

ArpitShah

Software Analyst at CLSA

A significant area for improvement is the documentation, which is not comprehensive and lacks centralized resources, making it difficult to find information. Additionally, ClickHouse lacks robust support for transactional data, which limits its use as a primary database. My developer experience could be enhanced through better-organized documentation, perhaps by offering a cheat sheet or centralized guide for common setup and usage scenarios.

Read full review

Eden Chen

Senior Software Engineer at a energy/utilities company with 1,001-5,000 employees

The aggregation capability is a valuable feature. It's highly efficient, allowing us to review entire transaction histories and user activities in the market. We've tried MongoDB, Postgres, MariaDB, and BigQuery, but ClickHouse is the most cost-efficient solution for collecting data at high speeds with minimal cost. We even used ClickHouse Cloud for a month, and it proved to be a great setup, especially for startups looking to handle big data. For example, if there is a need for 2-4 terabytes of data and around 40 billion rows with reasonable computing speed and latency, ClickHouse is ideal. Regarding the real-time query performance of ClickHouse, when using an API server to query it, I achieved query results in less than twenty milliseconds in some of my experiments with one billion rows. However, it depends on the scenario since ClickHouse has limitations in handling mutations. Additionally, one of ClickHouse's strengths is its compression capability. Our experimental server has only four terabytes, and ClickHouse effectively compresses data, allowing us to store large amounts of data at high speed. This compression efficiency is a significant advantage of using ClickHouse.

Read full review

ClickHouse mindshare

Product category:

As of July 2025, the mindshare of ClickHouse in the Open Source Databases category stands at 4.7%, up from 0.5% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Open Source Databases

PeerResearch reports based on ClickHouse reviews

Type	Title	Date
Category	Open Source Databases	Jul 14, 2025	Download
Product	Reviews, tips, and advice from real users	Jul 14, 2025	Download
Comparison	ClickHouse vs Firebird SQL	Jul 14, 2025	Download
Comparison	ClickHouse vs MySQL	Jul 14, 2025	Download
Comparison	ClickHouse vs PostgreSQL	Jul 14, 2025	Download

Title	Rating	Mindshare	Recommending
MySQL	4.1	9.7%	91%	149 interviews Add to research
PostgreSQL	4.2	17.7%	96%	125 interviews Add to research

Valuable Features

ClickHouse offers superb speed, efficient aggregation, and column-based architecture. Its flexibility supports APIs and integrates seamlessly with tools like Kafka and Tableau. It provides real-time performance and excellent compression capabilities. Open-source nature without vendor lock-in and ease of deployment add value. Users appreciate its compatibility with SQL standards, user-friendly interface, and scalability. ClickHouse handles large data volumes and complex analytical functions effectively, making it ideal for startups managing terabytes of data.

"ClickHouse is very easy to use; one of the good features is that it has joins, which were not present in Druid, and Druid was quite expensive, especially with our applications at Sam's Club utilizing ClickHouse very quickly."
"ClickHouse is open source with no vendor lock-in, providing excellent freedom to choose any vendor without restrictions."
"The best thing about the tool is that I can set it up on my computer and run queries without depending on the cloud. This is why I use it every day."

Room for Improvement

ClickHouse needs better integration with third-party tools and improved cloud deployment options. Its SQL syntax causes challenges when migrating queries from MySQL or SQL. Documentation is incomplete and lacks centralized resources, making setup difficult. Users find cost issues with ClickHouse Cloud. ClickHouse struggles with frequent small writes and transactional data support. Deploying on Kubernetes presents challenges, and traditional database triggers are unsupported. Overall, better tools and resources are needed for effective use.

"In terms of improvements, it's not designed for very frequent small writes, making it less scalable in write-intensive workloads, and it's not flourishing in transactional use cases or when ingesting streaming data, such as batching or buffering, which is something ClickHouse will improve."
"The main issue is the lack of documentation. Many features are available but are not fully documented, which can make finding information challenging."
"There aren't too many improvements I'd suggest for ClickHouse as it covers all my needs. There are just a few technical issues. For example, sometimes, when you want to get unique values and use certain tables, they don't work as expected. But it's not a major problem."

ROI

ClickHouse excels in handling large volumes of data and queries with high efficiency, which significantly reduces processing time and resource consumption. Businesses have benefited from cost savings due to its open-source nature and its ability to scale vertically and horizontally. Additionally, the speed and performance of ClickHouse have enabled users to enhance their data analysis capabilities, leading to better, data-driven decision-making.

Pricing

ClickHouse offers flexible pricing with its open-source version being free and self-hosted options allowing for cost-effective solutions. The cloud version, known as ClickHouse Cloud, is competitively priced, costing a few dollars per month, and is noted for its robust performance. Enterprises can choose between the self-managed deployment for cost-effectiveness or the cloud-based solution for ease of use, with no hidden fees or licensing constraints.

"The tool is open-source."
"We used the free, community version of ClickHouse."
"For pricing, if you use the self-hosted version, it would be free. Cloud services pricing would be an eight out of ten. I try to minimize costs but still have to monitor usage."

Popular Use Cases

ClickHouse is primarily used for data analytics, both real-time and batch processing. Organizations utilize it for storing and analyzing large volumes of data, tracking and monitoring activities, data warehousing, ETL engines, and machine learning tasks. It supports analytics and ML teams, streamlines log management, and integrates with business intelligence tools for insightful reporting. Companies value its fast performance, scalability, and capability to handle various data sources and types, making it suitable for analytics across various industries.

Service and Support

ClickHouse technical assistance is highly regarded for cloud subscribers, offering quick responses within 24 hours. Community channels like Slack and Telegram provide effective peer support. Although enterprise support is available, non-commercial users mainly utilize forums and GitHub for communication. Experience sharing indicates that both community and enterprise support teams are responsive and strive to understand and resolve challenges efficiently. Some users find their support particularly helpful against database limitations.

Deployment

Some users find ClickHouse's initial setup difficult, especially for in-house deployment requiring replication and persistent volumes. Those familiar with engineering skills deem it straightforward, noting ease with single-node setups via Yum or apt. Installation is easier on Windows with WSL, following documentation. Fast deployment is possible in minutes, though cluster planning is complex. Newcomers face challenges, but the ClickHouse community offers helpful resources. Cost savings drive many to choose on-premises deployments.

Scalability

ClickHouse is noted for its scalability, with many organizations utilizing it, including companies like Uber. It is designed for scalability out of the box. Some rate its scalability as high as nine or ten out of ten, although there are challenges like data rebalancing. Scalable for both small and large user groups, ClickHouse handles extensive data volumes, offering vertical scalability and suitability for distributed systems through cloud services.

Stability

ClickHouse is generally stable, handling large datasets efficiently without slowing down. Users suggest ensuring adequate RAM and proper configurations to avoid performance issues like queuing. While some bugs still occur, improvements have been noted over time. Persistent volumes are necessary to prevent data loss if a system failure occurs. Users rate stability mainly between seven to nine out of ten, indicating a reliable performance, though setup knowledge is crucial.

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our ClickHouse Buyer's Guide for additional reliable information.

Review data by company size

By reviewers

By visitors reading reviews

Top industries

By visitors reading reviews

Computer Software Company

24%

Financial Services Firm

16%

Educational Organization

10%

Manufacturing Company

Comms Service Provider

Retailer

Healthcare Company

University

Media Company

Hospitality Company

Real Estate/Law Firm

Energy/Utilities Company

Insurance Company

Construction Company

Outsourcing Company

Performing Arts

Legal Firm

Wholesaler/Distributor

Marketing Services Firm

Recreational Facilities/Services Company

Transportation Company

Compare ClickHouse with alternative products

Learn more about ClickHouse

ClickHouse leverages a column-based architecture for efficient data compression and real-time analytics. It seamlessly integrates with tools like Kafka and Tableau and is effective in handling large datasets due to its cost-efficient aggregation capabilities. With robust data deduplication and strong community backing, users can access comprehensive documentation and up-to-date functionality. However, improvements in third-party integration, cloud deployment, and handling of SQL syntax differences are noted, impacting ease-of-use and migration from other databases.

What features make ClickHouse outstanding?

Speed and Scalability: Enables rapid deployment and scalability, particularly on Kubernetes.
SQL Compatibility: Aligns with SQL standards for flexible database management.
Column-based Structure: Offers efficient data compression and quick query performance.
Integration Support: Works with Kafka, Tableau, and other popular platforms.
Data Deduplication: Manages complex data duplication efficiently.

What benefits should users consider?

Cost-Efficiency: Reduces expenses while managing large datasets effectively.
Real-Time Analytics: Provides fast data processing for real-time insights.
Flexibility: Offers multiple integration points and compatibility options.
Robust Documentation: Backed by an active development community, ensuring comprehensive support.

ClickHouse is deployed in sectors like telecommunications for passive monitoring and is beneficial for data analytics, logging Clickstream data, and as an ETL engine. Organizations harness it for machine learning applications when combined with GPT. With the ability to be installed independently, it's an attractive option for avoiding cloud service costs.