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:

JSON FunctionsAggregation FunctionsUnique Count and cardinality Estimation FunctionsExplain Plan (Single-Stage)Filtering with IdSetGapFill Function For Time-Series DatasetGrouping AlgorithmJOINsJOINsLookup UDF JoinTransformation FunctionsUser-Defined Functions (UDFs)Window FunctionsWindow Functions