Pivot – Real-time analytics on Iceberg, faster than ClickHouse on benchmarks

Pivot is a high-performance analytics engine that runs on open data formats. It delivers low-latency queries and high concurrency without replicating data into a dedicated real-time analytics database such as ClickHouse / Druid.

• Fast - Written in Rust and built on state-of-the-art columnar execution techniques, including morsel-driven parallelism, SIMD, NUMA-aware execution, and cache-conscious aggregation and joins, in addition to a few novel additions.
• Scalable - With object storage as its backing store, Pivot can be scaled up, down, or to zero almost instantly.
• Portable - Pivot can run both as a server serving backends and clients, or as a local engine where users and agents query the source of truth directly—allowing local ad-hoc and agentic analytics to share the same engine and architecture as traditional dashboards and in-app analytics
• Open - Pivot is open source and built on open data formats (Delta Lake and Iceberg). This means you can use Pivot with data already stored in your data warehouse, while data ingested by Pivot remains accessible to other query engines.

curl https://pivotlake.io | sh

See the Quickstart for Docker, the Debian package and a first query.

Note

Pivot is in early development and not yet production ready. Expect breaking changes between releases.

Contributions are welcome! See CONTRIBUTING.md, and ask questions in Discussions.

Licensed under either of the Apache License, Version 2.0 or the MIT license, at your option.