4 ms·
Clickhouse has some weird quirks when you think of it as a SQL Database, but its astounding to use it. It's faster than one would think, it can do some really c
by lykr0n 8y ago
Clickhouse has some weird quirks when you think of it as a SQL Database, but its astounding to use it. It's faster than one would think, it can do some really cool data modeling, and provides a wealth of features for the average user out of the box.
The most important thing, and the thing that makes it attractive to me is that it is almost stupidly simple to setup and get running. It's quite simple (when you wrap your head around it) to do sharding or replication and scale up. The zookeeper stuff takes a bit more effort, but most of that is due to zookeeper and not ClickHouse.
- gary__ 8y agoA look through the below does highlight some of its differences with a standard sql database. https://www.slideshare.net/Altinity/migration-to-clickhouse-practical-guide-by-alexander-zaitsev https://www.slideshare.net/Altinity/migration-to-clickhouse-... Year on now, perhaps things have changed.
- tadkar 8y agoSecond the “stupidly simple to setup and get running”. My company works with billion row datasets on client sites where we get super locked down accounts. Clickhouse is a single binary that you can run with no actual “install” needed. Also echo the comments in the rest of the discussion about it being blazing fast. On our beefier machines we get querying in the 100s of millions of rows per second when the data is not in cache.