Query

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

Querying PinotQuery OptionsThis document contains all the available query options

Explore query syntax:

Querying JSON dataAggregation FunctionsAggregate functions return a single result for a group of rows.

Cardinality EstimationExplain PlanFiltering with IdSetLearn how to write fast queries for looking up IDs in a list of values.

GapFill Function For Time-Series DatasetGrouping AlgorithmJOINsPinot supports JOINs, including left, right, full, semi, anti, lateral, and equi JOINs. Use JOINs to connect two table to generate a unified view, based on a related column between the tables.

Lookup UDF JoinTransformation FunctionsUser-Defined Functions (UDFs)Window FunctionsUse window functions to compute averages, sort, rank, or count items, calculate sums, and find minimum or maximum values across windows.