4 ms·
I recently discovered ClickHouse[1], Yandex's recently open sourced BigQuery equivalent (someone on HN pointed me to it!). If you're looking for a OLAP databas
by lima 9y ago
I recently discovered ClickHouse[1], Yandex's recently open sourced BigQuery equivalent (someone on HN pointed me to it!).
If you're looking for a OLAP database running on your own infrastructure, make sure to give it a try.
[1]: https://clickhouse.yandex/ https://clickhouse.yandex/
- tzury 9y agoThanks for the link. Seems interesting. BQ is a serverless though.
- lima 9y agoServerless is just another word for "third party service".
- vgt 9y agoI respectfully disagree. While what "serverless" truly means varies depending on who you ask, in this context I think it's: - Multi-tenant architecture. - Pay-per-job/query. - Complete abstraction away of underlying resources. - High availability out of the box. - Automatic seamless scaling on-demand. So services like BigQuery qualify, and Redshift don't. (work at G)
- nemothekid 9y agoAnything you run on your own infrastrucutre I wouldn't really call a BigQuery equivalent. As far as performance goes, if you attacked the problem with the same amount of CPU cores, I think you could get similar performance with Presto/Dremel on top of any fast data store. What I think is different about BigQuery is just the on-demand parallelism. This means you pay per query instead of per instance which is confusing at first, but then a lot of the operational knobs simply go away (for better or for worse).