3 ms·
It would be interesting to learn whether other options were considered. I would have definitely tried Presto (or AWS Athena) querying ORC data, which would amou
by marton78 6y ago
It would be interesting to learn whether other options were considered. I would have definitely tried Presto (or AWS Athena) querying ORC data, which would amount to a columnar storage with a sparse index, just like Click House.
- olavgg 6y agoI have evaluated these different options. And by far I prefer Clickhouse when were talking about less than a petabyte of data. It super simple to install and setup. And is a lot faster.
- FridgeSeal 6y agoI’ve used Presto and Athena and neither could really hold a candle to ClickHouse. Presto was handy, but I’d personally much rather go to the effort of getting things into a proper columnar database than put up with the quirks of the likes of Presto. If you want, there’s a detailed analysis of various db’s performance on various tasks here: https://tech.marksblogg.com/benchmarks.html https://tech.marksblogg.com/benchmarks.html It’s one of the top performing ones, even the single machine setup comfortably beats the likes of Presto, Athena, etc