tree: 88067e944e9ef1b21d82156180a3a431e54b7d86 [path history] [tgz]
  1. .codecov.yml
  2. .codecov_bash
  3. .gitignore
  4. .travis.yml
  10. LICENSE-binary
  11. NOTICE
  12. NOTICE-binary
  14. config/
  15. contrib/
  16. docker/
  17. docs/
  18. kubernetes/
  19. licenses-binary/
  20. licenses/
  21. pinot-api/
  22. pinot-azure-filesystem/
  23. pinot-broker/
  24. pinot-common/
  25. pinot-connectors/
  26. pinot-controller/
  27. pinot-core/
  28. pinot-distribution/
  29. pinot-hadoop-filesystem/
  30. pinot-hadoop/
  31. pinot-integration-tests/
  32. pinot-minion/
  33. pinot-orc/
  34. pinot-parquet/
  35. pinot-perf/
  36. pinot-server/
  37. pinot-tools/
  38. pinot-transport/
  39. pom.xml
  40. rstheaderdefinition.xml
  41. thirdeye/

Apache Pinot (incubating)

Build Status Join the chat at license

Apache Pinot is a realtime distributed OLAP datastore, which is used to deliver scalable real time analytics with low latency. It can ingest data from offline data sources (such as Hadoop and flat files) as well as online sources (such as Kafka). Pinot is designed to scale horizontally.

These presentations on Pinot give an overview of Pinot:

Looking for the ThirdEye anomaly detection and root-cause analysis platform? Check out the Pinot/ThirdEye project

Key Features

  • A column-oriented database with various compression schemes such as Run Length, Fixed Bit Length
  • Pluggable indexing technologies - Sorted Index, Bitmap Index, Inverted Index, Star-Tree Index
  • Ability to optimize query/execution plan based on query and segment metadata
  • Near real time ingestion from Kafka and batch ingestion from Hadoop
  • SQL like language that supports selection, aggregation, filtering, group by, order by, distinct queries on fact data
  • Support for multivalued fields
  • Horizontally scalable and fault tolerant

Because of the design choices we made to achieve these goals, there are certain limitations present in Pinot:

  • Pinot is not a replacement for database i.e it cannot be used as source of truth store, cannot mutate data
  • Not a replacement for search engine i.e full text search, relevance not supported
  • Query cannot span across multiple tables

Pinot works very well for querying time series data with lots of Dimensions and Metrics. Example - Query (profile views, ad campaign performance, etc.) in an analytical fashion (who viewed this profile in the last weeks, how many ads were clicked per campaign).

Instructions to build Pinot

More detailed instructions can be found at Quick Demo section in the documentation.

# Clone a repo
$ git clone
$ cd incubator-pinot

# Build Pinot
$ mvn clean install -DskipTests -Pbin-dist

# Run Quck Demo
$ cd pinot-distribution/target/apache-pinot-incubating-<version>-SNAPSHOT-bin
$ bin/

Getting Involved


Check out Pinot documentation for a complete description of Pinot's features.


Apache Pinot is under Apache License, Version 2.0