rel:: [[Databases MOC|Databases MOC]] # Apache Pinot - <https://dbdb.io/db/pinot> - columnar store - [[Databases MOC#^bae0d4|OLAP]] - limited support for joins (use [[trino]] [connector](https://trino.io/docs/current/connector/pinot.html) or Presto) - > For queries that require a large amount of data shuffling, require spill-to-disk, or are hitting any other limitations of the [multi-stage engine](https://docs.pinot.apache.org/developers/advanced/v2-multi-stage-query-engine), we still recommend using Presto. For more information, see - extensible on intake and query with [[Groovy]] - https://startree.ai/blog/a-tale-of-three-real-time-olap-databases ## [Schema](https://docs.pinot.apache.org/basics/components/schema) - Three basic column types - Dimension - type: STRING, BOOLEAN, INT, LONG, DOUBLE, FLOAT, BYTES - Metric - type: INT, LONG, DOUBLE, FLOAT, BYTES (for specialized representations such as HLL, TDigest) - DateTime - type: STRING, INT, LONG - format: `timeSize:timeUnit:timeFormat` - `1:NANOSECOND:EPOCH` ## [Indexing](https://docs.pinot.apache.org/basics/indexing) - Bloom filter - Forward index - Dictionary-encoded forward index with bit compression - Raw value forward index - Sorted forward index with run-length encoding - Geospatial - Inverted index - Bitmap inverted index - Sorted inverted index - JSON index - Range index - Star-tree index - Text Index - Native text index - Text search support - Timestamp index