ClickHouse Reviews

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

4.4 out of 5

10 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 #6 ranked solution in top Open Source Databases and #10 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 841,205 peers since 2012

Featured ClickHouse reviews

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

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

ClickHouse mindshare

Product category:

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

Open Source Databases

PeerAnalyst reports based on ClickHouse reviews

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

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

Valuable Features

ClickHouse is known for its super-fast query engine, user-friendliness, SQL compatibility, and scalability. It excels in column-based data organization, compression, real-time query performance, and is easy to integrate with tools like Kafka and Tableau. Its open-source nature allows freedom from vendor lock-in, while its efficient aggregation capability and cost-effectiveness make it ideal for handling big data. ClickHouse is praised for its powerful optimizer, ease of use, and extensive documentation and development support.

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

Room for Improvement

ClickHouse needs improvements in integration and third-party compatibility, particularly with cloud services. Users encounter challenges with documentation, leading to setup difficulties. Integration with Kubernetes and transactional data is limited. SQL syntax incompatibilities cause migration issues. There is a lack of proper Django support and database triggers. High cloud costs are a concern, and cluster management can be problematic. Enhanced documentation and better organized resources could improve user experience. Users want seamless integration and setup processes.

"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."
"ClickHouse has its own concept of database triggers and doesn't support traditional database triggers."

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 a cost-effective pricing structure ideal for enterprise buyers. The open-source version is free, allowing for flexibility and independence from licensing constraints. For those seeking more managed solutions, ClickHouse Cloud provides an affordable alternative, offering competitive pricing with efficient performance. Organizations can choose to deploy in-house on platforms like Kubernetes, which can significantly reduce costs. However, cloud costs require monitoring to prevent overruns despite their competitive nature.

"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 used for data analytics, both real-time and batch, logging clickstream data, monitoring, and tracking. Companies use it for data classification, machine learning, passive monitoring in telecommunications, and as a data warehouse for large datasets. It integrates with services for dashboards, ETL, and business intelligence, storing and analyzing substantial volumes of data efficiently. Data analysts and developers utilize it with SQL databases for applications in various industries, such as IoT and telecommunications.

Service and Support

ClickHouse support is praised for its responsiveness, especially with a cloud subscription. Users describe the team as small but effective, with prompt assistance through tickets and community channels like Telegram and GitHub. The cloud services support is noted for quick bug fixes, although some rely on community help for the open-source version. Multiple users highlight the helpfulness and understanding of the support team, with avenues in both English and Russian.

Deployment

Initial setup of ClickHouse varies in complexity based on expertise. Some find it straightforward, especially experienced users, while others face challenges, particularly with replication and persistent volumes. Implementing it on-premises can save costs but may lack features compared to the cloud version. Documentation effectively guides through installation, and the process is generally quick, though additional tuning for performance demands more skill. Community support can aid in resolving deployment issues.

Scalability

Many users find ClickHouse highly scalable, with companies like Uber utilizing it effectively. It is designed for scalability, offering vertical scalability and distributed system support. Some users note it does not support data rebalancing, which causes scalability issues. Several organizations rate its scalability between eight and ten out of ten. Examples include companies with over 1000 people accessing it and start-ups with fewer active users.

Stability

ClickHouse shows improved stability over time, though occasional bugs persist. Users find it stable and efficient with large data sets, noting it handles volume better than Postgres. Some report no issues, while others point out persistent volume requirements and memory consumption. Configurations play a role in performance, leading to job queuing if not set correctly. User ratings vary from seven to nine out of ten for stability, citing fewer bugs than in earlier versions.

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

15%

Financial Services Firm

13%

Manufacturing Company

10%

Comms Service Provider

University

Healthcare Company

Retailer

Media Company

Real Estate/Law Firm

Insurance Company

Hospitality Company

Outsourcing Company

Marketing Services Firm

Legal Firm

Energy/Utilities Company

Construction Company

Logistics Company

Performing Arts

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.