What Apache Pinot 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, plus batch data from Hadoop, Spark, AWS S3, Azure ADLS, and Google Cloud Storage. Batch and streaming inputs can be combined in a single queryable table. SQL access is available through a query editor and REST API, with JDBC, Java, Python, and Golang clients for applications. The project advertises P90 query latencies in the tens of milliseconds on petabyte-scale data and capacity for hundreds of thousands of concurrent queries per second. Pinot includes logical namespaces for multitenancy, HTTP Basic Authentication and ACLs, TLS and mutual TLS, and row-level security filters in version 1.4.0 and later. Superset, Tableau, and Power BI are listed as BI connections. Deployment guidance covers Docker and Kubernetes with Helm. The software is free and self-hosted, listed as free. Support and discussion channels include Slack, mailing lists, GitHub Issues, and community meetups.
Who it suits
It suits teams building analytics or user-facing workloads that need SQL access to streaming and batch data. Self-hosting and deployment guidance make it relevant to teams managing their own data infrastructure.
Good to know, and what to watch
- Combines streaming and batch sources in one table
- Provides SQL editor and REST API
- Offers JDBC, Java, Python, and Golang clients
- Lists Docker and Kubernetes with Helm deployment
- Self-hosted deployment
- Row-level security filters require version 1.4.0 or later
Plans
Every plan and priceApache Pinot
Open source
The verdict
Apache Pinot brings ingestion, query access, and multitenancy controls to self-hosted real-time analytics. Teams should account for operating the deployment themselves and check version requirements for row-level security.
What the maker publishes
- Authentication and authorization
- Pinot supports HTTP Basic Authentication and ACLs for controller and broker access. source
- Batch ingestion
- Pinot supports batch ingestion from Hadoop, Spark, AWS S3, Azure ADLS, and Google Cloud Storage. source
- BI integrations
- The documentation lists Superset, Tableau, and Power BI as BI tools that can connect to Pinot. source
- Client libraries
- Pinot provides JDBC, Java, Python, and Golang clients for external applications. source
- Concurrency
- Pinot can serve hundreds of thousands of concurrent queries per second. source
- Deployment
- The official quick install supports Docker and Kubernetes with Helm. source
- Founded
- 2013 source
- Multitenancy
- Pinot provides isolated logical namespaces for cloud-friendly resource management and data security. source
- Open source
- Apache Pinot is an open-source distributed OLAP database. source
- Purpose
- Apache Pinot is a real-time distributed OLAP datastore for low-latency, high-throughput analytics and user-facing workloads. source
- Query interface
- Pinot provides a SQL query editor and a REST API. source
- Query latency
- Pinot advertises P90 query latencies in the tens of milliseconds on petabyte-scale data. source
- Row-level security
- Pinot 1.4.0 and later supports row-level security filters for per-user row visibility. source
- Streaming ingestion
- Pinot ingests real-time data from Apache Kafka, Apache Pulsar, and AWS Kinesis. source
- Support
- The project provides Slack, mailing lists, GitHub Issues, and community meetups for questions and discussion. source
- Transport security
- Pinot supports TLS and mutual TLS for encrypted and authenticated connections. source
- Unified tables
- Pinot can combine batch and streaming sources into a single queryable table. source
Checked against the maker's pages on 1 Oct 2026.