Query

Learn how to query Apache Pinot using SQL or explore data using the web-based Pinot query console.

Querying PinotQuery OptionsQuery Quotas

Explore query syntax:

Querying JSON data

Aggregation Functions

Cardinality Estimation

Explain Plan (Single-Stage)

Filtering with IdSet

GapFill Function For Time-Series Dataset

Grouping Algorithm

JOINs

JOINs

Lookup UDF Join

Transformation Functions

User-Defined Functions (UDFs)

Window Functions

Window Functions