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
December 2024
Learn what your peers think about ClickHouse. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 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: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user