Review on ClickHouse by Marco Roberson

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 when developing locally using Docker containers etc.; good documentation both written form developers point view but also available online through official site's wiki section at https://clickhouseconsultants.github.io/. Some parts can be improved such us UI design that looks outdated if compareed against other modern products out there today i.e., PowerBI Dashboards vs Excel reports designed especially made for this productClickHouse offers powerful features without sacrificing user friendliness compared eithr others solutions we've tried previously within our organization so far. We're solving problems mostly related around BI reporting capabilities including dashboard creation along dimensions analysis across all historical timeframes supported up until very recent past few years already! The most useful features are columnar storage format, ability to work with JSON documents as data source and its wide range of connectors for external databases. It's very good at handling large volumes of data by using horizontal sharding and compression algorithm (Snappy). There are no downsides in my opinion. We use it at our workplace mainly for reporting purposes when we need to quickly analyze lots of information from different sources like web logs or even from third party APIs.