ClickHouse Reviews

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

4.4 out of 5

9 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, MariaDB, PostgreSQL and more!

ClickHouse is the #8 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 MariaDB: ClickHouse vs MariaDB. ClickHouse is popular among the large enterprise segment, accounting for 50% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a computer software company, accounting for 26% of all views.

Helped 832,138 peers since 2012

Featured reviews

Dmitriy Yugin

Senior Data/Web Analyst at Raiffeisen Bank

The tool is open-source, so you don't need to pay for the software itself. However, you need to consider hardware costs and maintenance. A small company can install it on a company computer. For larger companies, you might need to hire a team for maintenance and consider data safety and privacy issues. Integrating ClickHouse with other tools in our data stack was easy. It has native connections to many tools, such as Google and Amazon cloud solutions, and can easily connect with other databases. For beginners, the ease of use depends on your background. If you're familiar with relational databases, it's easy. If not, you might need to read the documentation or ask for support.

Read full review

Ayham Al-Adm

Full-stack Web Developer at a tech services company with 51-200 employees

For about six gigabytes, we took about two seconds to fetch all data at the maximum performance. Otherwise, it was really nice to have a medium CPU or database engine and resources. We don't have a really huge server; it's just traditional servers and traditional resources. ClickHouse is not a straightforward tool for anyone to use. Users need some time to switch from traditional things to study new concepts. We had just one client, Apache Superset. Apache Superset connects with just one connection but with too many requests. We had about 20 to 30 reports on the same page, and they work concurrently. The solution’s documentation is amazing. I would recommend the solution to other users. ClickHouse is the first step to the next generation of databases. When we deal with this amount of data and this performance, I think it's a respected technology. Overall, I rate the solution a nine out of ten.

Read full review

Eden Chen

Software Engineer [Data] at a educational organization 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 February 2025, the mindshare of ClickHouse in the Open Source Databases category stands at 2.3%, up from 0.1% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Open Source Databases

PeerAnalyst reports

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

Title	Rating	Mindshare	Recommending
MariaDB	4.1	6.7%	96%	59 interviews Add to research
PostgreSQL	4.2	18.6%	96%	125 interviews Add to research

Valuable Features

ClickHouse offers blazing speed and efficient real-time query performance, significantly outpacing traditional databases. Its column-row strategy and compression capability enable handling large data efficiently. Users appreciate its scalability with Kubernetes, cost-effectiveness for large datasets, and ease of integration with tools like Kafka and Tableau. ClickHouse supports SQL standards, offers robust aggregation features, and simplifies working with big data. It is especially advantageous for startups and those needing flexible deployment and rapid data analysis.

"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."
"The main feature of ClickHouse is the optimizer because we had too many records to deduplicate, and the optimizer took this task by itself."
"The tool is column-based and infinitely scalable."

Room for Improvement

ClickHouse requires improvements in integration with third-party tools and cloud service costs. Users often encounter challenges in setup, particularly with Kubernetes deployments. Compatibility issues arise when migrating from other SQL systems, and difficulties are noted with the lack of support for traditional database triggers. Clusters can be troublesome, especially when starting or shutting down nodes. Users find the SQL syntax differences challenging to address, and the absence of a Django driver adds complexity.

"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."
"ClickHouse has its own concept of database triggers and doesn't support traditional database triggers."
"There are some areas where ClickHouse could improve. Specifically, we encountered incompatibilities with its SQL syntax when migrating queries from MySQL or SQL to ClickHouse. This difference in details made it challenging to figure out the exact issues. Additionally, we faced difficulties due to the lack of a proper Django driver for ClickHouse, unlike MySQL, which Django supports out of the box."

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 options catering to enterprise buyers. The open-source version is free, ideal for self-hosting on platforms like Kubernetes, minimizing costs. The cloud version is affordable and competitive, providing fast performance for a nominal monthly fee. Users find the cloud services reasonably priced, rating them eight out of ten. For those preferring external support, ClickHouse provides scalable cloud solutions, though overall costs depend on usage and deployment scale.

"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, as well as logging clickstream data. Many organizations deploy it in production environments for applications like tracking, ETL engine use, machine learning classification, data warehousing, and passive monitoring systems in telecommunications. Its ability to handle large data volumes efficiently, store live data, and integrate with business intelligence tools makes it a central hub for companies. It supports internal services communication, providing easy SQL database utilization.

Service and Support

ClickHouse cloud users find the support team helpful and responding promptly within 24 hours. Those using the open-source version rely on community channels like GitHub and Telegram for assistance. Technical support, available in English and Russian, is valued but seems limited for in-house installations. Many users appreciate ClickHouse Docs for self-help. Community support is widespread and effective, although occasionally hindered by NDAs. Telegram provides another platform for addressing technical queries efficiently.

Deployment

Some found ClickHouse's initial setup challenging, particularly with self-deployment and replication. Others with engineering skills found it straightforward and preferred personal management. Experience levels influenced difficulty, with mentoring highlighting challenges. Deployment on Windows with WSL was smooth. Some users noted that while deploying on one server is easy, tuning for performance needs expertise. Community support aids in addressing issues, and focusing on cost-saving led to transitioning from cloud to on-premises setups.

Scalability

ClickHouse is perceived as highly scalable, with many companies utilizing it, including Uber and various Russian businesses. Users appreciate its out-of-the-box scalability features, although some find its lack of data rebalancing a limitation. Companies report usage by diverse numbers, ranging from ten to over a thousand, with scalability ratings often being high, typically scoring eight, nine, or ten out of ten.

Stability

ClickHouse requires persistent volumes to prevent data loss in case of system failure. Some users note that while stability has improved over time, bugs still appear. Memory usage can be high, necessitating ample RAM for optimal performance. Users commonly rate stability between seven and nine out of ten. Some encounter no stability issues, while others experience occasional bugs. Proper configuration is essential to avoid performance bottlenecks.

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

26%

Educational Organization

16%

Financial Services Firm

13%

Manufacturing Company

Comms Service Provider

University

Retailer

Media Company

Insurance Company

Healthcare Company

Hospitality Company

Real Estate/Law Firm

Marketing Services Firm

Legal Firm

Construction Company

Logistics Company

Outsourcing Company

Performing Arts

Energy/Utilities 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.