Realtime distributed OLAP datastore, designed to answer OLAP queries with low latency. Pinot is designed to answer OLAP queries with low latency on immutable data and mutable data(Upsert Support) Pluggable indexing technologies - Sorted Index, Bitmap Index, Inverted Index, StarTree Index, Bloom Filter, Range Index, Text Search Index(Lucence/FST), Json Index, Geospatial Index. Near Realtime ingestion with Apache Kafka, Apache Pulsar, Kinesissupports JSON, Avro, ProtoBuf, Thrift formats. Apache Pinot supports dimension lookup joins currently. Full SQL join support in Apache Pinot is coming soon. In the interim, full SQL joins can be performed by querying Pinot via the Trino or PrestoDB connector. Apache Pinot provides SQL interface for querying interactively, as well as programmatically via rest-api.
Features
- Horizontally scalable
- JOINS in Pinot
- SQL Query Interface
- Blazing Fast
- Pluggable indexing
- Near Real time ingestion