# Query

![](https://1662808032-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtH6nl58DdnZnelPdTc%2F-MKaPf2qveUt5cg0dMbM%2F-MKaPmS1fuBs2CHnx9-Z%2Fpinot-ui-width-1000.gif?alt=media\&token=53e4c5a8-a9cd-4610-a338-d54ea036c090)

{% content-ref url="user-guide-query/querying-pinot" %}
[querying-pinot](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/querying-pinot)
{% endcontent-ref %}

{% content-ref url="user-guide-query/supported-transformations" %}
[supported-transformations](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/supported-transformations)
{% endcontent-ref %}

{% content-ref url="user-guide-query/supported-aggregations" %}
[supported-aggregations](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/supported-aggregations)
{% endcontent-ref %}

{% content-ref url="user-guide-query/scalar-functions" %}
[scalar-functions](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/scalar-functions)
{% endcontent-ref %}

{% content-ref url="user-guide-query/how-to-handle-unique-counting" %}
[how-to-handle-unique-counting](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/how-to-handle-unique-counting)
{% endcontent-ref %}

{% content-ref url="user-guide-query/lookup-udf-join" %}
[lookup-udf-join](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/lookup-udf-join)
{% endcontent-ref %}

{% content-ref url="user-guide-query/json-queries" %}
[json-queries](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/json-queries)
{% endcontent-ref %}

{% content-ref url="user-guide-query/explain-plan" %}
[explain-plan](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/explain-plan)
{% endcontent-ref %}

{% content-ref url="user-guide-query/grouping-algorithm" %}
[grouping-algorithm](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/grouping-algorithm)
{% endcontent-ref %}

{% content-ref url="user-guide-query/gap-fill-functions" %}
[gap-fill-functions](https://docs.pinot.apache.org/release-0.12.1/users/user-guide-query/gap-fill-functions)
{% endcontent-ref %}