3 ms·
ClickHouse is an extremely fast SQL data warehouse that supports vectorized query execution, column storage, and efficient compression. It's also Apache 2.0 lic
by hodgesrm 5y ago
ClickHouse is an extremely fast SQL data warehouse that supports vectorized query execution, column storage, and efficient compression. It's also Apache 2.0 licensed and sets up on a dev laptop in about 60 seconds. The SQL is somewhat ideosyncratic (in a good way, I believe). It takes some experience to use it to its full capabilities.
Not all projects move there but if you want fast analytic queries on a few billion rows up to a few petabytes, it's really hard to beat.
Disclaimer: I work for Altinity, which supports ClickHouse.
- mekster 5y agoClickHouse is not good for updates and deletion, so if you want general storage of data, stick to RDBMS. Analytics are typically append only, so ClickHouse works order of magnitude faster than RDBMS.