ClickHouse Reviews & Product Details

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.

Some complex query optimizations require deeper expertise, which can be a bit challenging for new users. Review collected by and hosted on G2.com.

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.

Nothing yes, it had made my work easy only Review collected by and hosted on G2.com.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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. Review collected by and hosted on G2.com.

Stability and predictability. Clickhouse despite it's huge advantages sometimes doesn't provide you with the stability and behaviour needed for a production system. Review collected by and hosted on G2.com.

Clickhouse is easy to use as compare to other distributed DBMS. It provides SQL-like functionality. Its multi-master architecture is also a plus point. Review collected by and hosted on G2.com.

There is no such point. The main point is there are some feature still in development and lots of frequent update thet we have to keep an eye on. Review collected by and hosted on G2.com.

Clickhouse is a super fast database system (insert and select data) and it's even free.

Github community is also very active. Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.