Apache Pinot is a real-time distributed OLAP datastore.
Installation
Required packages: pinotdb
Version requirement: The Pinot extra requires pinotdb[sqlalchemy]>=9.2.2,<10.0.0. Releases below 8.0.0 declare SQLAlchemy below 2 in their SQLAlchemy extra; releases below 9.2.1 compile TIMESTAMP columns as NUMERIC (startreedata/pinot-dbapi#224).
Connection String
pinot+http://{broker_host}:{broker_port}/query?controller=http://{controller_host}:{controller_port}/Connection Examples
With authentication
pinot://{username}:{password}@{broker_host}:{broker_port}/query/sql?controller=http://{controller_host}:{controller_port}/verify_ssl=true Engine Parameters
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 32/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Extended Aggregate Functions
The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.
MEDIANSTDDEV_SAMPVAR_SAMP