Skip to main content
TrustRadius
ClickHouse

ClickHouse

Overview

What is ClickHouse?

ClickHouse is an open-source, column-oriented OLAP database system enabling real-time analytical reports using SQL queries. With linear scalability, it handles trillions of rows and petabytes of data. ClickHouse Cloud offers a scalable serverless solution for real-time analytics.

Read more
Recent Reviews

TrustRadius Insights

ClickHouse provides a powerful solution for businesses looking to handle and manage large amounts of data. Users have reported that …
Continue reading
Read all reviews
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is ClickHouse?

ClickHouse is an open-source, column-oriented OLAP database system enabling real-time analytical reports using SQL queries. With linear scalability, it handles trillions of rows and petabytes of data. ClickHouse Cloud offers a scalable serverless solution for real-time analytics.

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttps://clickhouse.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

9 people also want pricing

Alternatives Pricing

What is TeamDesk?

TeamDesk is a low-code development platform for online database creation. Business owners or managers can build a unique web database solution without any programming to facilitate working with data, organize routine work and create an accessible data source for teams.

What is Grist?

Grist combines the capabilities of spreadsheets, databases and app builders. Using a familiar spreadsheet interface, information can be organized as a relational database, and dashboards built using drag-and-drop. Solving spreadsheet problems Ensures data is well-structured and stored in one…

Return to navigation

Product Demos

Yandex DataProc demo: loading files from S3 to ClickHouse with Spark

YouTube

Opstrace Tracing demo e2e

YouTube

ApsaraDB | ClickHouse: Data Analysis Demo Using ApsaraDB

YouTube

ClickHouse is fast!

YouTube

MySQL CDC to Clickhouse using Decodable's Change Stream Capabilities

YouTube

Product Analytics Funnels - Clickhouse windowFunnel usage demo

YouTube
Return to navigation

Product Details

What is ClickHouse?

ClickHouse is an advanced open-source columnar database management system designed for high-performance analytical queries and large-scale data processing. Boasting a unique architecture and efficient data compression, ClickHouse enables users to run real-time queries on massive datasets, making it ideal for big data analytics, time-series data, and data warehousing solutions. It is also offered as a scalable serverless offering in the cloud. ClickHouse Cloud provides users real-time analytical processing.

Key Features and Benefits:

  1. High query performance: ClickHouse's columnar storage structure and advanced query optimization techniques drive fast processing of complex analytical queries.

  2. Scalability: ClickHouse is built to handle large volumes of data and can be scaled horizontally or vertically as needed, to ensure flexibility and reliability for growing data demands.

  3. Data compression: By storing data in columns and utilizing advanced compression algorithms, ClickHouse can reduce storage requirements to produce cost savings and improved query performance.

  4. Distributed processing: ClickHouse supports distributed data processing across multiple nodes, for efficient processing of vast datasets and to enhance query performance.

  5. Versatile use cases: ClickHouse is suited for various applications, including OLAP systems, data warehousing, time-series databases, and big data analytics.

The vendor states that ClickHouse offers advantages in terms of performance, cost savings, and adaptability so that companies leveraging ClickHouse can expect:

  • Faster decision-making through real-time analytics
  • Reduced infrastructure costs due to efficient data compression
  • Seamless scalability for future data growth


ClickHouse Features

  • Supported: Query performance: ClickHouse's columnar storage structure and advanced query optimization techniques support fast processing of complex analytical queries.
  • Supported: Scalability: ClickHouse is built to handle large volumes of data and can be scaled horizontally or vertically as needed.
  • Supported: Data compression: By storing data in columns and utilizing advanced compression algorithms, ClickHouse reduces storage requirements.
  • Supported: Distributed processing: ClickHouse supports distributed data processing across multiple nodes, for more efficient processing of vast datasets and enhanced query performance.
  • Supported: Use cases: ClickHouse is suited for various applications, including OLAP systems, data warehousing, time-series databases, and big data analytics.

ClickHouse Video

An Introduction to ClickHouse Cloud

ClickHouse Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, Mac
Mobile ApplicationNo
Supported CountriesGlobal
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(7)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

ClickHouse provides a powerful solution for businesses looking to handle and manage large amounts of data. Users have reported that ClickHouse's ability to dump and query huge amounts of data quickly is essential for real-time aggregation, providing users with various analytics that can help solve business problems. It has been found to be faster than other OLAP solutions for analytical queries and requires fewer machines than HBase while still providing faster read operations.

ClickHouse's MySQL-like syntaxes are highly useful for reporting purposes, where large amounts of data need to be retrieved and transformed. Users have reported saving disk space thanks to its ability to compress and store data, making it an ideal solution for businesses that generate large log records used for reporting purposes. Furthermore, ClickHouse's support for different engines such as Mergetree and Collapsingtree enables easy interaction with other databases like MySQL.

Overall, ClickHouse is being used by businesses across different sectors to analyze data and leverage its analytical abilities for their data operations. With its processing speed, optimal read time, and ability to store vast amounts of data efficiently, ClickHouse provides businesses with the tools they need to perform real-time analysis on monumental data sets, thus enabling them to make better-informed decisions about their businesses.

Fast Query Performance: Reviewers have praised ClickHouse for its fast query performance when retrieving large amounts of data. Multiple users have stated that the software's column-oriented structure and use of vectors and merging algorithms make it a powerful tool for performing operations quickly and efficiently.

Easy to Use: Several reviewers have found ClickHouse to be an easy-to-use database management system due to its SQL-like syntax, flexible choice of engines, fault-tolerance, and multi-master architecture. Users have also appreciated the simple installation process and the software's rich functions for analytics on big datasets.

Great Functionality: Many users have praised ClickHouse's functionality in managing databases, giving very fast write and query performance compared to RDBMS. The software's compression algorithm is a standout feature, making it easier to dump and retrieve data from the database. Additionally, reviewers appreciate the broad coverage of tests, searching and partitioning, replications, as well as the availability of engines for almost all use cases.

Difficult Database Editing: Some users have found it challenging to edit values that are already stored in the ClickHouse database.

Upgrade Issues: Some users have reported issues when upgrading from v19 to v21, causing some instability and unpredictability.

Stability Concerns: Several users expressed concerns regarding stability and predictability when using ClickHouse for a production system, despite its many advantages.

Users frequently recommend Clickhouse for its ability to handle large amounts of data and deliver fast analytical results. They find it well-suited for big data analytics and consider it a must-try solution. Users appreciate how simple and easy to use Clickhouse is, as they are able to quickly grasp its functionality. Additionally, users suggest Clickhouse as an option for those in need of a SQL-like database with distributed capabilities. However, some caution that Clickhouse may not be the best choice for production systems that require absolute reliability, due to occasional outdated documentation and limited community support.

Reviews

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
ClickHouse is used to carry out analysis tasks that traditional databases are not capable of performing, either because they are too expensive or because the volume of data is so large that it is not feasible to analyze it with queries comfortably. The analysis of indicators on which aggregations are needed but not on the rest of the indicators that are stored together in the same traditional table is one of the biggest problems that ClickHouse solves, making the queries run very fast with hardware that is not as advanced as it would be for a traditional table.
  • Opensource
  • High performance
  • Multiple engines to adapt user cases
  • Easy configuration of data replication
  • Avro data manipulation
  • Kafka consistency
  • DDL operations errors (by replica configuration)
The most important thing when using ClickHouse is to be clear that the scenarios in which you want to use it really are the right ones. Many users think that when a database is very fast for a specific use case, it can be extrapolated to other contexts (most of the time different) in which a previous analysis has not been carried out.

ClickHouse is an analytical database, as such, it should be used for such purposes, where the information is stored correctly, the data volumes are really large and the queries to be performed are not the typical traditional queries on several columns with multiple aggregations. ClickHouse is not the solution for this.

On the other hand, if your case is not one of the above, it is quite possible that ClickHouse can help you. Where ClickHouse shines is when you are looking for aggregation over a particular column in large volumes of data.
  • Open source
  • High performance
  • Escalability
  • Multiples engines
  • Queries that used to take more than 2 minutes now take less than 1 second
  • Possibility to analyze use cases in real time (before was impossible)
  • The applications are more complete and the users decisions are better
ClickHouse was not compared to them as a competitor but as the ideal partner to complete an information analysis system, providing users with the most complete and efficient tools. Therefore, in this case it was considered that it would be the ideal candidate due to its characteristics compared to the other competitors.
Return to navigation