# ClickHouse Reviews **Vendor:** ClickHouse **Category:** [Real-time Analytic Database Software](https://www.g2.com/categories/real-time-analytic-database) **Average Rating:** 4.5/5.0 **Total Reviews:** 23 ## About ClickHouse ClickHouse is the fastest and most resource efficient real-time database and data warehouse. ClickHouse is optimized to serve a wide range of data-intensive workloads, from powering interactive user-facing dashboards to running ad-hoc historical analysis over petabytes of data. Today, ClickHouse Cloud is used by enterprises all over the world, including Lyft, Sony, IBM, GitLab, Twilio, HubSpot, and many more. ClickHouse is available open-source or through cloud services on AWS, GCP, and soon, Azure. ## ClickHouse Pros & Cons **What users like:** - Users value the **easy integrations** of ClickHouse, allowing seamless connections with tools like Grafana and dbt. (2 reviews) - Users appreciate the **seamless integrations** of ClickHouse with various tools, enhancing their analytical and operational capabilities. (2 reviews) - Users praise ClickHouse for its **exceptional query efficiency** , enabling rapid analytics on extensive datasets effortlessly. (2 reviews) - Users highlight the **exceptional query speed** of ClickHouse, enabling rapid analytics on large datasets effortlessly. (2 reviews) - Users praise ClickHouse for its **exceptional speed** in querying large datasets, enhancing analytics efficiency dramatically. (2 reviews) - Analytics (1 reviews) - Availability (1 reviews) - Big Data Handling (1 reviews) - Data Analytics (1 reviews) - Data Storage (1 reviews) **What users dislike:** - New users may struggle with **complex query optimizations** , as they often require deeper expertise to navigate effectively. (1 reviews) - Users find that **complex usage** of ClickHouse can be challenging due to the need for deeper expertise in query optimizations. (1 reviews) - Users find **query optimization challenging** as it requires deeper expertise, especially for those new to ClickHouse. (1 reviews) - Users find that **required expertise for complex query optimizations** can be challenging for new users to navigate. (1 reviews) - Users find that **training is required** for complex query optimizations, posing challenges for beginners. (1 reviews) ## ClickHouse Reviews ### 1. ClickHouse Delivers Blazing-Fast Performance for Real-Time Analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Sachin S. | Customer Success & Growth Head, Financial Services, Small-Business (50 or fewer emp.) **Reviewed Date:** April 04, 2026 **What do you like best about ClickHouse?** What I like most about ClickHouse is its speed and performance when working with large volumes of data, along with its ease of use and complete ease of implementation. Queries run extremely fast, even on complex datasets, which makes real-time analysis much more practical. I also appreciate the flexibility it offers for structuring data and generating insights through dashboards, charts, and custom queries. **What do you dislike about ClickHouse?** One challenge with ClickHouse is the initial learning curve, especially around data modeling and query optimization. It can take some time to fully understand how to structure data for best performance. Additionally, documentation for certain advanced use cases could be more detailed, which would make onboarding smoother. **What problems is ClickHouse solving and how is that benefiting you?** ClickHouse helps us handle and analyze large volumes of transaction data efficiently. Earlier, getting detailed insights or running complex queries used to take time, but now we can access near real-time analytics. This has significantly improved our ability to monitor performance, identify issues quickly, and make faster, data-driven decisions. ### 2. Best Tool for Collecting Logs and Traces for My AI Data Warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Pintraj K. | Devops engineering, Small-Business (50 or fewer emp.) **Reviewed Date:** March 30, 2026 **What do you like best about ClickHouse?** It was the best tool for my data warehouse, especially because I used it to collect logs and traces for my AI application. **What do you dislike about ClickHouse?** We need a larger server to maintain the system, otherwise we have to go through their cloud option, which is expensive. **What problems is ClickHouse solving and how is that benefiting you?** We built the application to track and monitor the logs of our AI application. For that, we chose ClickHouse as our data warehouse, and it really worked better than we expected. ### 3. Handles Large Data Volumes with Fast Fetch Speeds **Rating:** 5.0/5.0 stars **Reviewed by:** Ragul J. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 20, 2026 **What do you like best about ClickHouse?** It can handle the amount of data we need, and data fetch speed **What do you dislike about ClickHouse?** Deduplication strategy and the blackbox tracking of dedups **What problems is ClickHouse solving and how is that benefiting you?** Providing analytics on top of clickhouse via complex analytical queries ### 4. Clickhouse: The New Era DB **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** November 02, 2025 **What do you like best about ClickHouse?** ClickHouse delivers exceptional query performance even on large datasets, making analytics lightning-fast and efficient. Its columnar storage design significantly optimizes storage and computation, ideal for real-time analytics workloads. The integration with tools like Grafana and dbt is smooth, making it easy to visualize and operationalize insights. The system is highly reliable and scalable, handling large-scale data ingestion with minimal latency. ClickHouse’s community and documentation are strong, providing great support for troubleshooting and best practices. **What do you dislike about ClickHouse?** Some complex query optimizations require deeper expertise, which can be a bit challenging for new users. **What problems is ClickHouse solving and how is that benefiting you?** We use Clickhouse for storing our historical reporting data which enables contact centre managers to optimize their work operations. We also use it for our internal observability. Our Insights APIs are also powered by Clickhouse. ### 5. great to manage bigger logs **Rating:** 5.0/5.0 stars **Reviewed by:** Gaurav b. | Web Maintenance Specialist, Small-Business (50 or fewer emp.) **Reviewed Date:** October 21, 2024 **What do you like best about ClickHouse?** The best tool for quering millions of rows in one second, It is simple and easy and similar queries to sql but provides variation in queries. The integeration to logs is also awesome **What do you dislike about ClickHouse?** Nothing yes, it had made my work easy only **What problems is ClickHouse solving and how is that benefiting you?** It has helped me query millions of rows in no time that is seconds ### 6. If ClickHouse was a car it would be the Lightning McQueen of data. **Rating:** 5.0/5.0 stars **Reviewed by:** Andy G. | Consulting Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 16, 2022 **What do you like best about ClickHouse?** Everyone knows that ClickHouse is the fastest database on the planet, massively reducing the hardware footprint to $100 for most projects. But what makes it shine is the enormous range of procedural functions that can be intertwined with the SQL, which bridge scripting with query negating repetitive queries altogether and allowing itterative, selective and extrapolative access to extended field formats such as complex structures. Finally, the materialised view pre-calculates an abstracted table in the background. All around, it's incredible. **What do you dislike about ClickHouse?** There are no significant drawbacks except a slight learning curve when you get started, but as standard SQL works fine, the transition into more complex queries is painless, and the documentation helps a lot. **What problems is ClickHouse solving and how is that benefiting you?** Querying billions of records on a $100 device and speed benefit me the most. ### 7. Strongest and Powerful DB for large scale of data analysis **Rating:** 4.0/5.0 stars **Reviewed by:** Daksh P. | Sr. QA Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 10, 2022 **What do you like best about ClickHouse?** Basically, clickhouse DB is column-oriented and so whenever we are using a query to fetch a huge amount of data it provides a result in less time. it's so amazing as we can quicky retrive the millions of records to analyze the data. Clickhouse having a nice compression algorithm which makes software easier with dumping the data into a database and retrieving the data to show at GUI. **What do you dislike about ClickHouse?** I guess so far I do not find any of but in some points, I got the updates as it's in pipeline for development but need to highlight one thing as sometimes unable to get the actual answers from the forum hence I would say it's time-consuming for getting the resolution **Recommendations to others considering ClickHouse:** Yes, I would suggest who deals with a huge amount of data and is required to get all the results as much as quickly then definitely go with clickhouse DB. It helps with getting data about analytical results for web applications. **What problems is ClickHouse solving and how is that benefiting you?** so many problems but would like to highlight one which is like We have faced an issue with dumping a huge amount of data and would like to call a bunch of queries in 5 minutes and in that case click-house is the only way to scale any number of huge data to get a quick result. In addition, it helps with the real-time aggregation of data. ### 8. A Column-oriented Database which is blazingly fast. **Rating:** 5.0/5.0 stars **Reviewed by:** MAYANK B. | Head of Public Relations, Mid-Market (51-1000 emp.) **Reviewed Date:** July 14, 2021 **What do you like best about ClickHouse?** Clickhouse is a column-oriented DBMS, and it is fault-tolerant and blazingly fast. Sql like syntax makes it super easy to use. The mathematics using behind scenes using vectors and merging algorithms gives the power to it. I like how quickly we can retrieve the data from the database. In Analytics/Reports we require to get/insert the millions of records and Clickhouse fulfills the purpose. Since it is a column-oriented DBMS, it performs things quickly. **What do you dislike about ClickHouse?** I disliked the fact there I can't make custom functions, I want that in Clickhouse so that we can form our own functions and use them. Materialized Views are still a mystery here they are super valuable but sometimes it tedious to use them and really required multiple joins in materialized views, currently, it's supporting only a single join which is not fulfilling the purpose sometimes. Clickhouse should introduce triggers since materialized views are not helping much here. **Recommendations to others considering ClickHouse:** If dealing with analytics, then this one is a must-try. **What problems is ClickHouse solving and how is that benefiting you?** I have been using Clickhouse for reporting in my company. Previously we were using MySQL, and retrieval for half a million was taking 5-10 min there while after using Clickhouse it took only seconds. Clickhouse is really useful when it comes to reporting since there we have to retrieve the huge data and perform transformations, its mysql like syntaxes are super useful that takes no time to adapt this. There are many supportive engines like mergetree, collapsingtree, and engines helping to interact with other dbs like mysql are really useful. ### 9. The fastest and most powerful DB ever used **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Automotive | Small-Business (50 or fewer emp.) **Reviewed Date:** July 14, 2021 **What do you like best about ClickHouse?** TLDR: Fast, Very Very Very Fast, Rich SQL, Good compression algorithms Detail: 1) Rich SQL syntax. There are a lot of in-build functions (including GeoDistances, Uber Hexagons support, time functions, comprehensive mah, and many others). Functions could be combined (e.g. with If: SumIf, AvgIf, etc) which is very convenient. 2) Fast. Arrays and MapReduce make CH working LIGHTNING FAST. I was extremely surprised when several GBs of data were processed in under 1 second. 3) Fast. Materialized Views work differently than in other databases, but the correct usage allows instant processing of TBs of data. 4) Efficient. Vast amount of data types and compression algorithms help you to store data extremely efficiently. Make sure to check the docs and choose the best compression types for your tables. You will be very surprised. Overall you see very smart engineers worked on this database. It was made by engineers for engineers. **What do you dislike about ClickHouse?** TLDR: You gotta read docs first. Requires Zookeeper. Detail: 1) I faced a lot of problems with Zookeeper, Partitioning, Sharding, and replication. 2) Learning is not that easy, but it worth it. **Recommendations to others considering ClickHouse:** Make sure to spend a few hours in the docs first and especially learn about Arrays. Thank me later. **What problems is ClickHouse solving and how is that benefiting you?** We had a lot of data coming from devices permanently (with around 50 Hz frequency). All this data had to be stored and processed. CH allowed us to store efficiently and process in real time. It's very fast. ### 10. Great data store solution for large data analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 25, 2021 **What do you like best about ClickHouse?** Very fast when it comes to querying large amounts of data. The count operation in specific is super quick. **What do you dislike about ClickHouse?** It is a lot of work if you want to edit any value that is already stored in the database. **What problems is ClickHouse solving and how is that benefiting you?** We add billions of records to it every day and use different materialized views to gather various analytics. The read time and processing are very optimal compared to other solutions. It compresses and stores data and that saves a lot of disk space. ### 11. Clickhouse does a lot of things right and but it still not stable for production use. **Rating:** 2.5/5.0 stars **Reviewed by:** Aby K. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 16, 2021 **What do you like best about ClickHouse?** Perfom and huge arsenal of Engines that helps you ingest and process data at scale. Like they have an Engine for almost all use case. **What do you dislike about ClickHouse?** Stability and predictability. Clickhouse despite it's huge advantages sometimes doesn't provide you with the stability and behaviour needed for a production system. **Recommendations to others considering ClickHouse:** The documents are sometimes outdated and there isn't a huge community support out there. For a production system that needs absolute reliance, I won't recomend. **What problems is ClickHouse solving and how is that benefiting you?** Bulk data ingestion and Big data analysis ### 12. ClickHouse Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** June 30, 2021 **What do you like best about ClickHouse?** Clickhouse is easy to use as compare to other distributed DBMS. It provides SQL-like functionality. Its multi-master architecture is also a plus point. **What do you dislike about ClickHouse?** There is no such point. The main point is there are some feature still in development and lots of frequent update thet we have to keep an eye on. **Recommendations to others considering ClickHouse:** If anyone is looking for SQL-like database and distributed as well at the same time, then clickhouse can be your choice. **What problems is ClickHouse solving and how is that benefiting you?** I have to store bulk data into clickhouse, which I stored earlier in HBase. Clickhouse provides faster read operation as compare to HBase. Also, the number of machines clickhouse requires is far less than HBase for same amount of reading and fetch operation. ### 13. Blazing fast Clickhouse **Rating:** 4.0/5.0 stars **Reviewed by:** Aubry V. | Data Intelligence Manager, Enterprise (> 1000 emp.) **Reviewed Date:** July 05, 2021 **What do you like best about ClickHouse?** Clickhouse is a super fast database system (insert and select data) and it's even free. Github community is also very active. **What do you dislike about ClickHouse?** The downside of clickhouse when you come from traditional DB system like sql or oracle is the way you need to handle updates and deletes **What problems is ClickHouse solving and how is that benefiting you?** Speed issue on billions rows tables ### 14. Over 100 billion records in my hands **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** July 22, 2021 **What do you like best about ClickHouse?** I like good data compression and fast query execution **What do you dislike about ClickHouse?** I dislike upgrade issues from v.19 to v.21 **Recommendations to others considering ClickHouse:** I would recommend clickhouse for big data analytics **What problems is ClickHouse solving and how is that benefiting you?** Fast query results over billions of records, storage savings with data compression ### 15. Clickhouse Review **Rating:** 4.0/5.0 stars **Reviewed by:** Kshitij G. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 04, 2021 **What do you like best about ClickHouse?** Great functionality and capability in regards to performing operations on a database **What do you dislike about ClickHouse?** The clock house documentation could be a little more elaborate. **What problems is ClickHouse solving and how is that benefiting you?** Easy to leverage analytical abilities for data operations. ### 16. Performance is above expectations with just con **Rating:** 4.5/5.0 stars **Reviewed by:** Avinash G. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 08, 2021 **What do you like best about ClickHouse?** Searching and partitioning. Replications. **What do you dislike about ClickHouse?** It takes comapratively more time to start if data present in clickhouse is huge **What problems is ClickHouse solving and how is that benefiting you?** Searching problems. Purging the old data is easy ### 17. blazing fast analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** July 06, 2021 **What do you like best about ClickHouse?** we recommend for using fast analytics for big peta bytes of data particularly clickhouse has rich functions **What do you dislike about ClickHouse?** need more stack for discussions and solution and errors **What problems is ClickHouse solving and how is that benefiting you?** we as a way2online we store terrabytes of adtech data and use them to get counts for multiple requirements and found that its fast when compared to other olap and its opensource too ### 18. ClickHouse is best for log big data given its query performance is very fast. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** July 04, 2021 **What do you like best about ClickHouse?** ClickHouse gives very fast write and query performance compared to RDBMS. **What do you dislike about ClickHouse?** The downside is that the record is immutable so not work well with some kinds of records other than logs. It was a bit tricky to setup cluster too. **What problems is ClickHouse solving and how is that benefiting you?** I have used ClickHouse for saving large log records for reporting purpose. ### 19. Clickhouse is a very good OLAP base system work more efficiently then any RDBMS like MYSQL. **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Wholesale | Small-Business (50 or fewer emp.) **Reviewed Date:** July 27, 2021 **What do you like best about ClickHouse?** The functionality of solving various problems is effortless, what is have found in the clickhouse most appealing **What do you dislike about ClickHouse?** As of now, Nothing I dislike about click house. **What problems is ClickHouse solving and how is that benefiting you?** Various problems I have solved like intent creation, high-speed calculations, and much more ### 20. this is awesome and i will suggest this to everyone **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** July 06, 2021 **What do you like best about ClickHouse?** I like every feature of it and thanks for creating this **What do you dislike about ClickHouse?** Bit slow and i didn't like a bit of the interface but remaining all is good **Recommendations to others considering ClickHouse:** it is simple to use just start and you get it **What problems is ClickHouse solving and how is that benefiting you?** We are solving healthcare problem using this and analysing data ### 21. Clickhouse db for real time analysis **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 08, 2021 **What do you like best about ClickHouse?** Best part of Clickhouse database is it has very easy installation and easy to use for high performance and reliablity **What do you dislike about ClickHouse?** The worst thing in clickhose db is it doesn't support transactions. **What problems is ClickHouse solving and how is that benefiting you?** I was using for querying the records on large dataset size. It is very fast. ### 22. Smooth Real TIme Analytics on TerraBytes of Data **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Leisure, Travel & Tourism | Mid-Market (51-1000 emp.) **Reviewed Date:** July 12, 2021 **What do you like best about ClickHouse?** The flexibility of choice of engines for your varying needs broad coverage of tests **What do you dislike about ClickHouse?** Community support is at times lagging. however test cases are broad **What problems is ClickHouse solving and how is that benefiting you?** We were solving near realtime aggregation of bus routes for traffic analysis ### 23. Quick Result for large dataset **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Services | Small-Business (50 or fewer emp.) **Reviewed Date:** July 08, 2021 **What do you like best about ClickHouse?** Its query efficiency on large data for optimization of response time **What do you dislike about ClickHouse?** Its dictionary freature and server down sometimes **What problems is ClickHouse solving and how is that benefiting you?** Analytical queries for web app ## ClickHouse Discussions - [Why is ClickHouse faster?](https://www.g2.com/discussions/why-is-clickhouse-faster) - [Is ClickHouse SQL database?](https://www.g2.com/discussions/is-clickhouse-sql-database) - [Is ClickHouse a datawarehouse?](https://www.g2.com/discussions/is-clickhouse-a-datawarehouse) - [What is ClickHouse good for?](https://www.g2.com/discussions/what-is-clickhouse-good-for) - [View ClickHouse pricing details and edition comparison](https://www.g2.com/products/clickhouse/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-11+22%3A54%3A25+-0500&secure%5Bsession_id%5D=ea895900-32dc-4877-bf75-42c9a245cc9b&secure%5Btoken%5D=9ab07b4c46395514d812994ad5c0621c07baa8b82221673414c6a3c13357567a&format=llm_user) ## ClickHouse Integrations - [Openlit](https://www.g2.com/products/openlit/reviews) - [Vector By Datadog](https://www.g2.com/products/vector-by-datadog/reviews) ## ClickHouse Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Management ** - Data Schema - Query Language - Data Replication **Storage** - Data Model - Data Types **Query latency** - Lower query latency - Continuous queries **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Support ** - Text Search - Data Types - Languages - Operating Systems **Availability** - Auto Recovery - Data Replication **Data latency** - Lower data latency - Data pipeline performance **Security** - Data Encryption - User Access Control **Security** - Access Control - Encryption - Authentication **Performance** - Integrated Cache **Connectors** - Faster ingestion - Built-in connectors **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Security** - Role-Based Authorization - Authentication - Audit Logs - Encryption **Scale** - Linearly scalable database - Storage management **Support** - Multi-Model - Operating Systems **Architecture** - Data security - Lockless architecture **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top ClickHouse Alternatives - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,148 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,578 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (705 reviews)