ClickHouse

ClickHouse is a column-oriented analytical database that stores each column separately in append-only parts, so an aggregation reads only the columns it actually needs. It answers the typical OLAP question, grouping and filtering billions of rows in seconds, using a SQL dialect close to PostgreSQL along with materialized views and background merges.

Teams point it at product analytics, click and ad streams, application logs, and IoT readings to feed dashboards, funnels, and internal reporting.

It can run on hardware you control, keeping large fact tables on premises and avoiding metered pricing from hosted analytics services.