Try our new research platform with insights from 80,000+ expert users
ClickHouse DBA at a computer software company with 51-200 employees
Real User
A flexible solution with good documentation and integration
Pros and Cons
  • "The tool's most valuable feature is a database. It supports portal APIs and offers good flexibility."
  • "If you join our team, it should be easy for you to use ClickHouse, especially if you are a developer. However, you need to read the documentation and understand the problems you are trying to solve."

What is our primary use case?

I do not use the tool myself. Our developers and data analysts use it. 

What is most valuable?

The tool's most valuable feature is a database. It supports portal APIs and offers good flexibility. While it may not be the best on the market, it is the best open-source solution we have tried. It has a development community and good documentation, though not all is published. 

The tool's integration with other tools is not complex. We use it alongside Kafka and Tableau. 

For how long have I used the solution?

I have been using the product for four years. 

What do I think about the scalability of the solution?

Every customer I've worked with over the past few years uses ClickHouse, including many Russian companies and those related to Russia.

Buyer's Guide
ClickHouse
August 2025
Learn what your peers think about ClickHouse. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,384 professionals have used our research since 2012.

How are customer service and support?

I have some experience talking with the tech support team. It was an open-source project at one point, so I used community resources for help. The best way to communicate with them was through their program channel, which had support available in both English and Russian.

How was the initial setup?

Regarding the initial installation, setup, and deployment, I can say it's easy for someone with my engineering skills. I prefer managing the installation myself rather than relying on out-of-the-box solutions.

What other advice do I have?

ClickHouse is good for analytics. Using ClickHouse is beneficial if you understand its specific purpose and advantages. Many engineers and developers mistakenly think it is an alternative to AWS databases like Postgres or MySQL, but it's not. ClickHouse has a different architecture and purpose, primarily excelling at analytical queries rather than traditional CRUD operations.

If you join our team, it should be easy for you to use ClickHouse, especially if you are a developer. However, you need to read the documentation and understand the problems you are trying to solve. As an infrastructure engineer, it shouldn't be hard either.

I rate the overall solution an eight out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Spyros Almpanis - PeerSpot reviewer
Backend Software Engineer at a tech vendor with 51-200 employees
Real User
Top 20
A column-based and infinitely scalable solution that is suitable for big data
Pros and Cons
  • "The tool is column-based and infinitely scalable."
  • "There are some areas where ClickHouse could improve. Specifically, we encountered incompatibilities with its SQL syntax when migrating queries from MySQL or SQL to ClickHouse. This difference in details made it challenging to figure out the exact issues. Additionally, we faced difficulties due to the lack of a proper Django driver for ClickHouse, unlike MySQL, which Django supports out of the box."

What is our primary use case?

We use ClickHouse for a passive monitoring system in telecommunications. It is used to record primary data from the mobile network technology.

What is most valuable?

The tool is column-based and infinitely scalable. 

What needs improvement?

There are some areas where ClickHouse could improve. Specifically, we encountered incompatibilities with its SQL syntax when migrating queries from MySQL or SQL to ClickHouse. This difference in details made it challenging to figure out the exact issues. Additionally, we faced difficulties due to the lack of a proper Django driver for ClickHouse, unlike MySQL, which Django supports out of the box.

For how long have I used the solution?

I have been working with the product for one and a half years. 

What do I think about the scalability of the solution?

My company has ten product users. 

Which solution did I use previously and why did I switch?

The company decided to use ClickHouse because mobile networks produce enormous amounts of data—millions of timestamped vectors, each representing a measurement, which total billions of rows per month. Initially, they used MySQL, but as the data volume grew, MySQL couldn't handle the load. Therefore, they switched to ClickHouse.

What other advice do I have?

If you're considering using ClickHouse for the first time, my advice would depend on how much data you need to handle. For most scenarios where big data isn't involved, I don't think it's a good idea to use ClickHouse. SQL Server, MySQL, or PostgreSQL are well-documented and supported. The software you need to access these databases will be readily available. So, I don't see any reason to use ClickHouse for small to medium-scale scenarios.

I don't think you'll find it any more difficult than other databases, apart from the SQL syntax, which is a bit different. The most challenging part with ClickHouse is dealing with the large amounts of data it handles without overloading your server. I don't think the database itself is difficult to use. However, I was primarily accessing data from it and don't have much experience with setting it up or feeding it data. 

I rate the overall solution a nine out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
ClickHouse
August 2025
Learn what your peers think about ClickHouse. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,384 professionals have used our research since 2012.
Andrei Kochemirovskii - PeerSpot reviewer
Lead Data Engineer at Omni Verse
Real User
Top 20
User-friendly and can be used for analytics and various other use-cases
Pros and Cons
  • "ClickHouse is a user-friendly solution that tries to be compatible with SQL standards."
  • "I would like ClickHouse to work more on integration with third-party tools."

What is our primary use case?

During my experience Clickhouse was used primary for companies analytics. At the same time I had a chance to apply it for various other use-case, such as log and storage metrics, Clickhouse as an ETL engine, monitorin, alerting and many more

How has it helped my organization?


What is most valuable?

ClickHouse is a user-friendly solution that tries to be compatible with SQL standards. It also tries to provide command-line tools, very nice formatting, libraries. And of course blazing speed it is main selling point of this technology

What needs improvement?

I would like ClickHouse to work more on integration with third-party tools. The solution has a lot of integrations, but most of them are not completed or production-ready.

The solution's setup requires some work and understanding. People at the company do not fully understand how to use ClickHouse. They try to use it like any relational database, which causes a lot of problems.

For how long have I used the solution?

I have been using ClickHouse since 2018

What do I think about the stability of the solution?

We have experienced small bugs many times with the solution. Five years ago, the tool wasn't so stable. Now, it's better, but bugs still happen.

I rate the solution a seven out of ten for stability.

What do I think about the scalability of the solution?

ClickHouse is a very scalable solution because it is designed to be scalable out of the box. There are some issues with scalability because, by design, ClickHouse does not support data rebalancing. I work at a start-up where around ten users use the solution.

I rate the solution’s scalability a nine out of ten.

How are customer service and support?

I have never interacted with the solution's technical support because I usually use the open-source version of ClickHouse. You can post your issue on GitHub at any time, and you will usually get a response.

How would you rate customer service and support?

Positive

What's my experience with pricing, setup cost, and licensing?

Currently, ClickHouse provides a cloud-based solution that you can use in the cloud. ClickHouse has an open-source version, which is free to use and has almost all the features.

What other advice do I have?

ClickHouse provides the best real-time query performance in the market if it is used properly. Generally, ClickHouse is not so easy to use because it's designed in such a way that you should be aware of the infrastructure. The solution is complicated, but it is easy for someone with experience and knowledge. I would recommend the solution to other users.

ClickHouse is a magnificent solution, but users should first read a few articles about it to understand how to use it properly and how not to use it. Users should take a learning course to be aware of its architecture and to use it properly.

Overall, I rate the solution ten out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user