Skip to main content

​
Apache Pinot

Apache Pinot is a real-time distributed OLAP datastore purpose-built for low-latency, high-throughput analytics, and perfect for user-facing analytical workloads. StarTree is a fully-managed platform for Pinot.

​
Prerequisites

  • The hostname for the Pinot broker
  • The port for the Pinot broker
Note that the following features should be enabled in your Pinot cluster:

​
Setup

Currently, Apache Pinot is not shown in the list of available data sources in the UI. However, you can still configure it using environment variables.

​
Manual

Add the following to a .env file in your Cube project: 
CUBEJS_DB_TYPE=pinot
CUBEJS_DB_HOST=http[s]://pinot.broker.host
CUBEJS_DB_PORT=8099
CUBEJS_DB_USER=pinot_user
CUBEJS_DB_PASS=**********

​
Environment Variables

Environment VariableDescriptionPossible ValuesRequired
CUBEJS_DB_HOSTThe host URL for your Pinot brokerA valid host URL✅
CUBEJS_DB_PORTThe port for the database connectionA valid port number✅
CUBEJS_DB_USERThe username used to connect to the brokerA valid username❌
CUBEJS_DB_PASSThe password used to connect to the brokerA valid password❌
CUBEJS_DB_NAMEThe database name for StarTreeA valid name❌
CUBEJS_DB_PINOT_NULL_HANDLINGIf true, enables null handling. Default is falsetrue, false❌
CUBEJS_DB_PINOT_AUTH_TOKENThe authentication token for StarTreeA valid token❌
CUBEJS_CONCURRENCYThe number of concurrent queries to the data sourceA valid number❌

​
Pre-Aggregation Feature Support

​
count_distinct_approx

Measures of type count_distinct_approx can be used in pre-aggregations when using Pinot as a source database. To learn more about Pinot support for approximate aggregate functions, click here.

​
Pre-aggregation build strategies

To learn more about pre-aggregation build strategies, [head here][ref-caching-using-preaggs-build-strats].
FeatureWorks with read-only mode?Is default?
Simple✅✅
Batching--
Export bucket--
By default, Pinot uses a simple strategy to build pre-aggregations.

​
Simple

No extra configuration is required to configure simple pre-aggregation builds for Pinot.

​
Batching

Pinot does not support batching.

​
Export bucket

Pinot does not support export buckets.

​
SSL

Cube does not require any additional configuration to enable SSL as Pinot connections are made over HTTPS.