--- title: ClickHouse Reviews meta_title: 'ClickHouse Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 23 reviews by the users' company size, role or industry to find out how ClickHouse works for a business like yours. aggregate_rating: rating_value: 4.5 review_count: 23 scale: '5' date_modified: '2026-09-22' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # 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 **AI Enabled:** This product embeds AI to enhance or extend its core functionality. ## 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 Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews. **What users like:** - Users value the **easy integrations** of ClickHouse, enhancing data visualization and operational insights effortlessly. (2 reviews) - Users value the **smooth integrations** with tools like Grafana and dbt for enhanced data visualization and insights. (2 reviews) - Users praise the **query efficiency** of ClickHouse, noting its speed and effectiveness even with massive datasets. (2 reviews) - Users commend ClickHouse for its **exceptionally fast query performance** , enabling rapid analytics on large datasets. (2 reviews) - Users love the **exceptional speed** of ClickHouse, enabling rapid analytics on massive datasets effortlessly. (2 reviews) - Users value the **exceptional query performance** of ClickHouse, enabling lightning-fast and efficient analytics on large datasets. (1 reviews) - Users praise the **high availability** of ClickHouse, ensuring seamless performance even with large data loads. (1 reviews) - Users praise ClickHouse for its **exceptional big data handling** , enabling fast analytics and efficient performance on large datasets. (1 reviews) - Users value the **exceptional query performance** of ClickHouse, enhancing their data analytics experience significantly. (1 reviews) - Users value the **efficient data storage** of ClickHouse, enhancing performance for large-scale analytics seamlessly. (1 reviews) **What users dislike:** - Users find **beginner unfriendliness** in ClickHouse due to the complexity of query optimizations requiring advanced knowledge. (1 reviews) - Users find that **complex usage** of ClickHouse necessitates advanced expertise, posing challenges for beginners. (1 reviews) - Users find that **complex query optimizations** demand specialized knowledge, posing challenges for newcomers to ClickHouse. (1 reviews) - Users find that **required expertise for complex queries** can be challenging, especially for newcomers to ClickHouse. (1 reviews) - Users find that **training is required** for complex query optimizations, posing challenges for new users. (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.) **Validated Reviewer:** Validated through Google One Tap using a business email account **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **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.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal incentive as thanks for completing this review. **Source: Organic:** Organic review. This reviewer was offered a nominal incentive as thanks for completing this review. **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.) **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through Google using a business email account **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **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.) **Validated Reviewer:** Validated through LinkedIn **Source: Organic Review from User Profile:** Invitation from G2. This reviewer was not provided any incentive by G2 for completing this review. **Reviewed Date:** October 21, 2024 **What do you like best about ClickHouse?** The best tool for querying millions of rows in one second, It is simple and easy and similar queries to SQL but provides variation in queries. The integration to logs is also awesome **What do you dislike about ClickHouse?** Nothing yet, it has only made my work easy **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.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 16, 2022 At G2, we prefer fresh reviews and we like to follow up with reviewers. They may not have updated their review text, but have updated their review. **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 iterative, selective and extrapolative access to extended field formats such as complex structures. Finally, the materialized 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.) **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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 math, 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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through Google using a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through Google using a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** June 30, 2021 **What do you like best about ClickHouse?** Clickhouse is easy to use as compared 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 features still in development and lots of frequent updates that we have to keep an eye on. **Recommendations to others considering ClickHouse:** If anyone is looking for a 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 operations compared to HBase. Also, the number of machines Clickhouse requires is far less than HBase for the same amount of reading and fetch operations. ### 13. Blazing fast Clickhouse **Rating:** 4.0/5.0 stars **Reviewed by:** Aubry V. | Data Intelligence Manager, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) **Validated Reviewer:** Validated through Google using a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** July 08, 2021 **What do you like best about ClickHouse?** Searching and partitioning. Replications. **What do you dislike about ClickHouse?** It takes comparatively 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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through Google using a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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 reliability **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **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 feature 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-09-30+17%3A12%3A19+-0500&secure%5Bsession_id%5D=82ba1cc9-8348-4119-92c0-526899e527cd&secure%5Btoken%5D=11705ad7519c7ba0ce43794a9eeaf5f397ba86907ca4c4616246e9351b1f09df&format=llm_user) ## ClickHouse Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis - Data Synchronization - Real-Time Data - Data Storage Management **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 - Automatic Backup - Database Conversion **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 - Mobile Access **Security** - Access Control - Encryption - Authentication **Performance** - Integrated Cache **Connectors** - Faster ingestion - Built-in connectors **Additional Functionality** - Workflow Management - Third-Party Integrations - Data Extraction - Relational Database Management - SSL Security - API - Data Connectors - Search/Filter - Reporting & Statistics - Customizable Templates - AI Copilot - Full Text Search - Data Virtualization - Data Import/Export - Generative AI - Drag & Drop - Customizable Fields - Authentication - Data Visualization - Secure Data Storage - Activity Dashboard - Data Mapping - Multiple Programming Languages Supported - Data Capture and Transfer - User Management - NOSQL Database Management - Access Controls/Permissions - Calendar Management - Real-Time Monitoring - Document Storage - Audit Management - Charting **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,144 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,585 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (713 reviews)