Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

ClickHouse Cloud

ClickHouse | 1

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

19 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Gaurav b.

great to manage bigger logs

  • October 22, 2024
  • Review provided by G2

What do you like best about the product?
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
What do you dislike about the product?
Nothing yes, it had made my work easy only
What problems is the product solving and how is that benefiting you?
It has helped me query millions of rows in no time that is seconds


    Andy G.

If ClickHouse was a car it would be the Lightning McQueen of data.

  • November 16, 2022
  • Review verified by G2

What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
Querying billions of records on a $100 device and speed benefit me the most.


    Daksh P.

Strongest and Powerful DB for large scale of data analysis

  • March 10, 2022
  • Review provided by G2

What do you like best about the product?
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.
What do you dislike about the product?
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
What problems is the product 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.
Recommendations to others considering the product:
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.


    Computer Software

Great data store solution for large data analytics

  • November 25, 2021
  • Review verified by G2

What do you like best about the product?
Very fast when it comes to querying large amounts of data.
The count operation in specific is super quick.
What do you dislike about the product?
It is a lot of work if you want to edit any value that is already stored in the database.
What problems is the product 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.


    Wholesale

Clickhouse is a very good OLAP base system work more efficiently then any RDBMS like MYSQL.

  • July 27, 2021
  • Review provided by G2

What do you like best about the product?
The functionality of solving various problems is effortless, what is have found in the clickhouse most appealing
What do you dislike about the product?
As of now, Nothing I dislike about click house.
What problems is the product solving and how is that benefiting you?
Various problems I have solved like intent creation, high-speed calculations, and much more


    Telecommunications

Over 100 billion records in my hands

  • July 22, 2021
  • Review verified by G2

What do you like best about the product?
I like good data compression and fast query execution
What do you dislike about the product?
I dislike upgrade issues from v.19 to v.21
What problems is the product solving and how is that benefiting you?
Fast query results over billions of records, storage savings with data compression
Recommendations to others considering the product:
I would recommend clickhouse for big data analytics


    Aby K.

Clickhouse does a lot of things right and but it still not stable for production use.

  • July 16, 2021
  • Review verified by G2

What do you like best about the product?
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.
What do you dislike about the product?
Stability and predictability. Clickhouse despite it's huge advantages sometimes doesn't provide you with the stability and behaviour needed for a production system.
What problems is the product solving and how is that benefiting you?
Bulk data ingestion and Big data analysis
Recommendations to others considering the product:
The documents are sometimes outdated and there isn't a huge community support out there. For a production system that needs absolute reliance, I won't recomend.


    Verified User in Automotive

The fastest and most powerful DB ever used

  • July 14, 2021
  • Review provided by G2

What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product 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.
Recommendations to others considering the product:
Make sure to spend a few hours in the docs first and especially learn about Arrays. Thank me later.


    MAYANK B.

A Column-oriented Database which is blazingly fast.

  • July 14, 2021
  • Review verified by G2

What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product 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.
Recommendations to others considering the product:
If dealing with analytics, then this one is a must-try.


    Leisure, Travel & Tourism

Smooth Real TIme Analytics on TerraBytes of Data

  • July 12, 2021
  • Review provided by G2

What do you like best about the product?
The flexibility of choice of engines for your varying needs
broad coverage of tests
What do you dislike about the product?
Community support is at times lagging. however test cases are broad
What problems is the product solving and how is that benefiting you?
We were solving near realtime aggregation of bus routes for traffic analysis