Apache Pinot

Apache Pinot is a real-time distributed OLAP datastore designed to deliver scalable real-time analytics with low latency. It ingests data from batch and streaming sources and provides fast analytical queries for user-facing applications.

Apache Pinot publishes 5 APIs on the APIs.io network, including Cluster API, Queries API, Schemas API, and 2 more. Tagged areas include Analytics, Database, Low Latency, OLAP, and Real-Time.

The Apache Pinot catalog on APIs.io includes 1 JSON-LD context and 2 Spectral governance rulesets.

Apache Pinot’s developer surface includes documentation and 8 more developer resources.

🌐 Visit website 📡 Source on GitHub

40.0/100 thin ▼ -9.1 Agent 25/100 agent aware Full breakdown ↓
scored 2026-07-28 · rubric v0.6

AccessFreemium

5 APIs 7 Features 4 Use Cases

AnalyticsDatabaseLow LatencyOLAPReal-TimeApacheOpen Source

Kin Score

Kin Score How this is scored →
scored 2026-07-28 · rubric v0.6

Composite quality — 40.0/100 · thin

Contract Quality 10.9 / 25

Developer Ergonomics 1.7 / 20

Commercial Clarity 7.9 / 20

Operational Transparency 4.8 / 13

Governance 8.3 / 12

Discoverability 6.5 / 10

Agent readiness — 25/100 · agent aware

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

MCP Server 0 / 12

Machine-Readable Auth 0 / 10

Idempotency 0 / 9

Stable Error Semantics 0 / 8

Request/Response Examples 7 / 7

Rate-Limit Signaling 7 / 7

Typed Event Surface 0 / 6

Agent Skills 0 / 5

Well-Known Catalog 0 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. This rating is computed from github.com/api-evangelist/apache-pinot: open an issue to ask a question, or submit a pull request to add artifacts. Want it done for you? Prioritized profiling — $2,500 →

APIs 5

Individual APIs this provider publishes, each with its own machine-readable definition.

Apache Pinot Cluster API

The Cluster API from Apache Pinot — 2 operation(s) for cluster.

Apache Pinot Queries API

The Queries API from Apache Pinot — 1 operation(s) for queries.

Apache Pinot Schemas API

The Schemas API from Apache Pinot — 2 operation(s) for schemas.

Apache Pinot Segments API

The Segments API from Apache Pinot — 1 operation(s) for segments.

Apache Pinot Tables API

The Tables API from Apache Pinot — 2 operation(s) for tables.

Pricing Plans 1

Published pricing tiers and plan structures.

Apache Pinot Plans Pricing

3 plans

PLANS

Rate Limits 1

Documented rate limits and quota policies.

Apache Pinot Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Apache Pinot Finops

FINOPS

Features 7

Notable capabilities this provider offers.

Real-Time OLAP

Sub-second analytical queries over real-time and historical data

SQL Support

Standard SQL query interface with Pinot-specific extensions

Streaming Ingestion

Real-time data ingestion from Kafka, Kinesis, and Pulsar

Batch Ingestion

Offline data ingestion from HDFS, S3, GCS, and local files

Columnar Storage

Column-oriented storage with bitmap indexing for fast queries

Multi-Tenancy

Tenant isolation for broker and server resources

Star-Tree Index

Pre-aggregated star-tree index for metric rollup queries

Scroll for all 7

Semantic Vocabularies 1

JSON-LD contexts and semantic vocabularies used across these APIs.

Apache Pinot Context

12 classes · 34 properties

JSON-LD

Spectral Rules 2

Spectral governance rulesets for linting and validating these APIs.

Apache Pinot API Rules

5 rules · 3 warnings 2 info

SPECTRAL

Apache Pinot API Rules

11 rules · 5 errors 4 warnings 2 info

SPECTRAL

1 properties

JSON STRUCTURE

Scroll for all 12

Recommended x-agentic-access execution contracts for AI agents.

Apache Pinot Agentic Access

12 operations · 5 acting

AGENTIC

Use Cases 4

What developers build with this provider.

User-Facing Analytics

Power user-facing dashboards like LinkedIn Who Viewed Profile

Real-Time Dashboards

Business intelligence dashboards over streaming data

Anomaly Detection

Real-time anomaly detection over metric time series

A/B Testing

Real-time experiment analysis and statistical significance

Integrations 5

Pre-built integrations with other platforms and tools.

Apache Kafka

Real-time stream ingestion from Kafka topics

Apache Flink

Flink connector for streaming data into Pinot

Apache Superset

Visual analytics and dashboards via SQL

Presto/Trino

Federated query access to Pinot via Presto connector

Grafana

Grafana data source plugin for Pinot metrics

Resources

Documentation 1

Reference material describing how the API behaves

Documentation

Documentation

Agent Surfaces 2

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess

AgenticAccess

LlmsText

LlmsText

Design & Contract 3

Pagination, idempotency, versioning, errors, and events

SpectralRules

SpectralRules

Vocabulary

Vocabulary

JSONLD

JSONLD

Build 1

SDKs, sample code, and the tooling you integrate with

GitHubOrganization

GitHubOrganization

Access & Security 2

Authentication, authorization, and security posture

VulnerabilityDisclosure

VulnerabilityDisclosure

DomainSecurity

DomainSecurity

Source (apis.yml)

aid: apache-pinot
name: Apache Pinot
description: Apache Pinot is a real-time distributed OLAP datastore designed to deliver scalable real-time analytics with
  low latency. It ingests data from batch and streaming sources and provides fast analytical queries for user-facing applications.
type: Index
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  method: derived
position: Consumer
access: 3rd-Party
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/apache-pinot.png
tags:
- Analytics
- Database
- Low Latency
- OLAP
- Real-Time
- Apache
- Open Source
created: '2026-03-16'
modified: '2026-05-19'
url: https://raw.githubusercontent.com/api-evangelist/apache-pinot/refs/heads/main/apis.yml
specificationVersion: '0.19'
apis:
- aid: apache-pinot:apache-pinot-cluster-api
  name: Apache Pinot Cluster API
  description: The Cluster API from Apache Pinot — 2 operation(s) for cluster.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Cluster
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-cluster-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
- aid: apache-pinot:apache-pinot-queries-api
  name: Apache Pinot Queries API
  description: The Queries API from Apache Pinot — 1 operation(s) for queries.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Queries
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-queries-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
- aid: apache-pinot:apache-pinot-schemas-api
  name: Apache Pinot Schemas API
  description: The Schemas API from Apache Pinot — 2 operation(s) for schemas.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Schemas
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-schemas-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
- aid: apache-pinot:apache-pinot-segments-api
  name: Apache Pinot Segments API
  description: The Segments API from Apache Pinot — 1 operation(s) for segments.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Segments
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-segments-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
- aid: apache-pinot:apache-pinot-tables-api
  name: Apache Pinot Tables API
  description: The Tables API from Apache Pinot — 2 operation(s) for tables.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Tables
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-tables-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
maintainers:
- FN: Kin Lane
  email: info@apievangelist.com
common:
- type: AgenticAccess
  url: agentic-access/apache-pinot-agentic-access.yml
- type: VulnerabilityDisclosure
  url: security/apache-pinot-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/apache-pinot-domain-security.yml
- type: GitHubOrganization
  url: https://github.com/apache/pinot
- type: Documentation
  url: https://docs.pinot.apache.org/
- type: SpectralRules
  url: rules/apache-pinot-spectral-rules.yml
- type: Vocabulary
  url: vocabulary/apache-pinot-vocabulary.yaml
- type: JSONLD
  url: json-ld/apache-pinot-context.jsonld
- type: Features
  data:
  - name: Real-Time OLAP
    description: Sub-second analytical queries over real-time and historical data
  - name: SQL Support
    description: Standard SQL query interface with Pinot-specific extensions
  - name: Streaming Ingestion
    description: Real-time data ingestion from Kafka, Kinesis, and Pulsar
  - name: Batch Ingestion
    description: Offline data ingestion from HDFS, S3, GCS, and local files
  - name: Columnar Storage
    description: Column-oriented storage with bitmap indexing for fast queries
  - name: Multi-Tenancy
    description: Tenant isolation for broker and server resources
  - name: Star-Tree Index
    description: Pre-aggregated star-tree index for metric rollup queries
- type: UseCases
  data:
  - name: User-Facing Analytics
    description: Power user-facing dashboards like LinkedIn Who Viewed Profile
  - name: Real-Time Dashboards
    description: Business intelligence dashboards over streaming data
  - name: Anomaly Detection
    description: Real-time anomaly detection over metric time series
  - name: A/B Testing
    description: Real-time experiment analysis and statistical significance
- type: Integrations
  data:
  - name: Apache Kafka
    description: Real-time stream ingestion from Kafka topics
  - name: Apache Flink
    description: Flink connector for streaming data into Pinot
  - name: Apache Superset
    description: Visual analytics and dashboards via SQL
  - name: Presto/Trino
    description: Federated query access to Pinot via Presto connector
  - name: Grafana
    description: Grafana data source plugin for Pinot metrics
- type: LlmsText
  url: https://docs.pinot.apache.org/llms.txt