user-guide-query

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

Query

{% content-ref url="querying-pinot.md" %} querying-pinot.md {% endcontent-ref %}

{% content-ref url="query-options.md" %} query-options.md {% endcontent-ref %}

Explore query syntax:

{% content-ref url="json-queries.md" %} json-queries.md {% endcontent-ref %}

{% content-ref url="supported-aggregations.md" %} supported-aggregations.md {% endcontent-ref %}

{% content-ref url="how-to-handle-unique-counting.md" %} how-to-handle-unique-counting.md {% endcontent-ref %}

{% content-ref url="explain-plan.md" %} explain-plan.md {% endcontent-ref %}

{% content-ref url="query-syntax/filtering-with-idset.md" %} filtering-with-idset.md {% endcontent-ref %}

{% content-ref url="gap-fill-functions.md" %} gap-fill-functions.md {% endcontent-ref %}

{% content-ref url="grouping-algorithm.md" %} grouping-algorithm.md {% endcontent-ref %}

{% content-ref url="query-syntax/joins.md" %} joins.md {% endcontent-ref %}

{% content-ref url="query-syntax/joins.md" %} joins.md {% endcontent-ref %}

{% content-ref url="query-syntax/lookup-udf-join.md" %} lookup-udf-join.md {% endcontent-ref %}

{% content-ref url="supported-transformations.md" %} supported-transformations.md {% endcontent-ref %}

{% content-ref url="scalar-functions.md" %} scalar-functions.md {% endcontent-ref %}

{% content-ref url="query-syntax/windows-functions.md" %} windows-functions.md {% endcontent-ref %}

{% content-ref url="query-syntax/windows-functions.md" %} windows-functions.md {% endcontent-ref %}