Header banner
Revain logoHome Page
clickhouse logo

ClickHouse Review

4

·

Very good

Revainrating 5 out of 5  
Rating 
4.8
IT Management, Columnar Databases

View on AmazonView on ЯM

Description of ClickHouse

ClickHouse is a fast open-source OLAP database management system It is column-oriented and allows to generate analytical reports using SQL queries in real-time.

Reviews

Global ratings 4
  • 5
    3
  • 4
    1
  • 3
    0
  • 2
    0
  • 1
    0

Type of review

Revainrating 5 out of 5

Very fast analytical database system

I love how easy it makes data manipulation from different sources, like AWS Redshift or MySQL databases for example; its builtin caching mechanism allows to reduce queries execution times dramatically (I have about 3% of CPU usage just by running some complex aggregation query). It has nice support with Python scripting language which gives you more freedom in development process compared to Hadoop ecosystem - no need additional tools/libraries installed as dependencies into your project builds

Pros
  • Data is stored directly inside memory avoiding any expensive hard drive accesses
  • Ability store json objects straightly instead CSV files used before.
  • Easy integration between many types relational database systems via clickbine connector system,
  • Great performance under high concurrency loads due lack cache eviction policies implemented yet

Revainrating 5 out of 5

Easy to use SQL analytics with minimal setup time

The best part about clickhouse was that it helped me to do real time analytics without much of an overhead or setup cost, which really made sense given how I had very little data in my tables at first! Also being able to use SQL queries through JDBC connections allowed for easy integration with other systems we were using - another bonus side effect from this ease of accessability via sql statements. It's also quite simple to query when you're just starting out as well since there are so many…

Pros
  • Great flexibility
  • Easy accessibility by others including developers & business analysts.
  • Very fast processing times especially compared against Hive etc
  • Frequent updates/improvements over new releases
Cons
  • Almost never

Revainrating 5 out of 5

Great product for real time data processing

It's simple, reliable and easy to use from both administration as well as developer points of view. Support for distributed systems is great - you can easily create complex cluster setups with high availability options (HAProxy / Redis). Reliability could be improved though. I've used it in many projects at different stages of their life cycle and have never encountered any issues that would cause me to reconsider using this software so far. We needed an analytics tool which was able to process

Pros
  • The fact we didn't need huge amounts of RAM nor expensive GPUs when working with big datasets makes my work much more effective compared before! Great job guys ! :) You will save money here too because no separate database server license required either :D Keep up the excellent works : )!!!!!
Cons
  • It is hard to say

Revainrating 4 out of 5

A very powerful tool to have at your fingertips

I like how easy it was to bring in new data into my cluster, as well has updating existing tables with various changes easily without downtime or issues of stability/reliability (as long you are doing your homework ahead). It's also great when wanting an ETL tool for processing big loads from csv files coming through APIs etc.. Being able update our main table fairly quickly! Sometimes there can be some confusion about what needs syncing across servers vs just local copies which could cause…

Pros
  • Simplified
  • Easy SQL
  • like syntax.
  • Flexible schema design capabilities / JSON config file support is nice too since yaml format isn';e always ideal but sometimes hard work gets done faster then expected ;)
  • Data access speed &amp convenience compared even directly accessing Cassandra via java driver instead.
  • No special setup needed beyond installing package(i believe)
Cons
  • I don't remember