- Home
- Streaming Analytics Software
- Apache Pinot
Apache Pinot
Apache Pinot · Wilmington, Delaware, United States · founded 2013
What it is
Apache Pinot is an open-source distributed OLAP datastore for real-time analytics and user-facing workloads. It ingests streaming data from Apache Kafka, Apache Pulsar, and AWS Kinesis, and batch data from Hadoop, Spark, Amazon S3, Azure ADLS, and Google Cloud Storage. Batch and streaming sources can be combined in one queryable table. SQL access is available through a query editor and REST API, with JDBC, Java, Python, and Golang clients for external applications. Pinot advertises P90 query latencies in the tens of milliseconds on petabyte-scale data and capacity for hundreds of thousands of concurrent queries per second. It provides logical namespaces for multitenancy, and supports HTTP Basic Authentication, ACLs, TLS, and mutual TLS. Row-level security filters are supported in version 1.4.0 and later. BI tools listed for connection include Superset, Tableau, and Power BI. Deployment guidance covers Docker and Kubernetes with Helm. The self-hosted software is free, listed as free.
For and against
For
- Combines streaming and batch sources in one table.
- Provides SQL through a query editor and REST API.
- Supports multiple client libraries and BI tools.
- Free, open-source self-hosted deployment.
Against
- Row-level security filters require version 1.4.0 or later.
- Deployment guidance covers Docker and Kubernetes with Helm.
The verdict
Apache Pinot brings streaming and batch data into queryable tables and provides SQL access through several interfaces. Its free deployment is self-hosted, with deployment guidance centered on Docker and Kubernetes.
Who it suits
Pinot suits teams building real-time analytics or user-facing workloads that combine batch and streaming data. Its BI connections and client libraries may suit teams connecting dashboards or external applications.
Plans and prices
Apache Pinot
Open-source distributed OLAP datastore · self-hosted deployment
Read 1 Oct 2026 · pinot.apache.org
On the record
- Authentication and authorization
- Pinot supports HTTP Basic Authentication and ACLs for controller and broker access.docs.pinot.apache.org · read 1 Oct 2026
- Batch ingestion
- Pinot supports batch ingestion from Hadoop, Spark, AWS S3, Azure ADLS, and Google Cloud Storage.docs.pinot.apache.org · read 1 Oct 2026
- BI integrations
- The documentation lists Superset, Tableau, and Power BI as BI tools that can connect to Pinot.docs.pinot.apache.org · read 1 Oct 2026
- Client libraries
- Pinot provides JDBC, Java, Python, and Golang clients for external applications.docs.pinot.apache.org · read 1 Oct 2026
- Concurrency
- Pinot can serve hundreds of thousands of concurrent queries per second.pinot.apache.org · read 1 Oct 2026
- Deployment
- The official quick install supports Docker and Kubernetes with Helm.pinot.apache.org · read 1 Oct 2026
- Multitenancy
- Pinot provides isolated logical namespaces for cloud-friendly resource management and data security.pinot.apache.org · read 1 Oct 2026
- Open source
- Apache Pinot is an open-source distributed OLAP database.pinot.apache.org · read 1 Oct 2026
- Purpose
- Apache Pinot is a real-time distributed OLAP datastore for low-latency, high-throughput analytics and user-facing workloads.docs.pinot.apache.org · read 1 Oct 2026
- Query interface
- Pinot provides a SQL query editor and a REST API.pinot.apache.org · read 1 Oct 2026
- Query latency
- Pinot advertises P90 query latencies in the tens of milliseconds on petabyte-scale data.pinot.apache.org · read 1 Oct 2026
- Row-level security
- Pinot 1.4.0 and later supports row-level security filters for per-user row visibility.docs.pinot.apache.org · read 1 Oct 2026
- Streaming ingestion
- Pinot ingests real-time data from Apache Kafka, Apache Pulsar, and AWS Kinesis.pinot.apache.org · read 1 Oct 2026
- Support
- The project provides Slack, mailing lists, GitHub Issues, and community meetups for questions and discussion.docs.pinot.apache.org · read 1 Oct 2026
- Transport security
- Pinot supports TLS and mutual TLS for encrypted and authenticated connections.docs.pinot.apache.org · read 1 Oct 2026
- Unified tables
- Pinot can combine batch and streaming sources into a single queryable table.pinot.apache.org · read 1 Oct 2026
