--- 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-08-09' parent\_category: name: Database Software url: https://www.g2.com/categories/database-software --- # ClickHouse Reviews & Product Details Claimed ###### Profile Status This profile is currently managed by ClickHouse but has limited features. Are you part of the ClickHouse team? [Upgrade your plan](https://sell.g2.com) to enhance your branding and engage with visitors to your profile! 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. * * * Seller [ClickHouse](https://www.g2.com/sellers/clickhouse) Discussions [ClickHouse Community](https://www.g2.com/products/clickhouse/discuss) Languages Supported English Overview by Nick Peart Show More ## Pricing Pricing provided by ClickHouse. ### ClickHouse Pricing Starting at $1.00 Per Month [ View More Pricing Information ](https://www.g2.com/products/clickhouse/pricing) ## Top-Rated Alternatives [ ![Google Cloud BigQuery](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Google Cloud BigQuery") Google Cloud BigQuery 4.5/5(1,224) ](https://www.g2.com/products/google-cloud-bigquery/reviews) [ ![MySQL](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "MySQL") MySQL 4.4/5(1,682) ](https://www.g2.com/products/mysql/reviews) [ ![Snowflake](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Snowflake") Snowflake 4.6/5(764) ](https://www.g2.com/products/snowflake/reviews) [ View All Alternatives ](https://www.g2.com/products/clickhouse/competitors/alternatives) ## User Insights Average based on 23 real user reviews. Typical contract price $0k - $0k [Sign in to view](/login) Per Month [Log in to unlock pricing and user insights](/login) ## ClickHouse Integrations (2) What do users say about integrations? Integration information sourced from real user reviews. [ ![Product Avatar Image](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Product Avatar Image") Openlit ](https://www.g2.com/products/openlit/reviews)[ ![Product Avatar Image](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Product Avatar Image") Vector By Datadog ](https://www.g2.com/products/vector-by-datadog/reviews) Show More ![Sachin S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Sachin S.") SS Sachin S. Customer Success & Growth Head Financial Services Small-Business (50 or fewer emp.) 4/4/2026 "ClickHouse Delivers Blazing-Fast Performance for Real-Time Analytics" 5/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Pintraj K.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pintraj K.") PK Pintraj K. Devops engineering Small-Business (50 or fewer emp.) 3/30/2026 "Best Tool for Collecting Logs and Traces for My AI Data Warehouse" 5/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerIncentivizedSource: Organic ![Ragul J.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Ragul J.") RJ Ragul J. Software Engineer Small-Business (50 or fewer emp.) 4/20/2026 "Handles Large Data Volumes with Fast Fetch Speeds" 5/5 What do you like best about ClickHouse? It can handle the amount of data we need, and data fetch speed Review collected by and hosted on G2.com. What do you dislike about ClickHouse? Deduplication strategy and the blackbox tracking of dedups Review collected by and hosted on G2.com. What problems is ClickHouse solving and how is that benefiting you? Providing analytics on top of clickhouse via complex analytical queries Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Verified User in Computer Software](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Computer Software") UC Verified User in Computer Software Enterprise (\> 1000 emp.) 11/2/2025 "Clickhouse: The New Era DB" 5/5 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. Review collected by and hosted on G2.com. What do you dislike about ClickHouse? Some complex query optimizations require deeper expertise, which can be a bit challenging for new users. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Gaurav b.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Gaurav b.") GB Gaurav b. Web Maintenance Specialist Small-Business (50 or fewer emp.) 10/21/2024 "great to manage bigger logs" 5/5 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 Review collected by and hosted on G2.com. What do you dislike about ClickHouse? Nothing yes, it had made my work easy only Review collected by and hosted on G2.com. 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 Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic Review from User Profile ![Andy G.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Andy G.") AG Andy G. Consulting Software Engineer Small-Business (50 or fewer emp.) 11/16/2022 "If ClickHouse was a car it would be the Lightning McQueen of data." 5/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More 3/1/2024 Current UserValidated ReviewerIncentivizedSource: G2 invite ![Daksh P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Daksh P.") DP Daksh P. Sr. QA Engineer Mid-Market (51-1000 emp.) 3/10/2022 "Strongest and Powerful DB for large scale of data analysis" 4/5 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. Review collected by and hosted on G2.com. 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 Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![MAYANK B.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "MAYANK B.") MB MAYANK B. Head of Public Relations Mid-Market (51-1000 emp.) 7/14/2021 "A Column-oriented Database which is blazingly fast." 5/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Recommendations to others considering ClickHouse: If dealing with analytics, then this one is a must-try. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerIncentivizedSource: G2 invite ![Verified User in Automotive](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Automotive") UA Verified User in Automotive Small-Business (50 or fewer emp.) 7/14/2021 "The fastest and most powerful DB ever used" 4/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Recommendations to others considering ClickHouse: Make sure to spend a few hours in the docs first and especially learn about Arrays. Thank me later. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Verified User in Computer Software](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Computer Software") UC Verified User in Computer Software Small-Business (50 or fewer emp.) 11/25/2021 "Great data store solution for large data analytics" 4.5/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerIncentivizedSource: G2 invite ## Pricing Options Pricing provided by ClickHouse. ### ClickHouse Pricing Starting at $1.00 Per Month [ View More Pricing Information ](https://www.g2.com/products/clickhouse/pricing) ClickHouse Comparisons ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_0c1a5efe2186b27d1209cb6792600fda/navicat-premium.png "Product Avatar Image") Navicat Premium 4.5/5(60) [ Compare Now ](https://www.g2.com/compare/clickhouse-vs-navicat-premium) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_96b275379465d759df5bffd0099d849a/google-cloud-bigquery.png "Product Avatar Image") BigQuery 4.5/5(1,224) [ Compare Now ](https://www.g2.com/compare/clickhouse-vs-google-cloud-bigquery) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_131c279a0a8faf5615b1f91696037b66/cassandra.jpeg "Product Avatar Image") Cassandra 4.1/5(35) [ Compare Now ](https://www.g2.com/compare/cassandra-vs-clickhouse) ##### Categories on G2 [Relational Databases](https://www.g2.com/categories/relational-databases)[Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms)[Columnar Databases](https://www.g2.com/categories/columnar-databases) [Relational Databases](https://www.g2.com/categories/relational-databases)[Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms)[Columnar Databases](https://www.g2.com/categories/columnar-databases)[Real-time Analytic Database](https://www.g2.com/categories/real-time-analytic-database) [Show MoreShow Less](javascript:void(0);) ##### Explore More [Google Cloud Run reviews](https://www.g2.com/products/google-cloud-run/reviews)[Which purchasing solutions are most reliable based on real implementation success and user satisfaction?](https://www.g2.com/discussions/which-purchasing-solutions-are-most-reliable-based-on-real-implementation-success-and-user-satisfaction)[Top customer journey mapping solutions for CX professionals](https://www.g2.com/discussions/what-are-the-top-customer-journey-mapping-solutions-for-cx-professionals) [Best pricing management tools for my app business](https://www.g2.com/discussions/best-pricing-management-tools-for-my-app-business)[Highly rated voice recognition services for call centers](https://www.g2.com/discussions/highly-rated-voice-recognition-service-for-call-centers)[Pros and Cons Details](https://www.g2.com/products/clickhouse/reviews?qs=pros-and-cons) [Show MoreShow Less](javascript:void(0);)