Pinot provides support for aggregations using GROUP BY. You can use the following functions to get the aggregated value.
Function  Description  Example 
COUNT  Get the count of rows in a group 

MIN  Get the minimum value in a group 

MAX  Get the maximum value in a group 

SUM  Get the sum of values in a group 

AVG  Get the average of the values in a group 

MINMAXRANGE  Returns the min and max value in a group 

PERCENTILE[0100]  Returns the Nth percentile of the group where N is between 0100 

PERCENTILEEST[0100]  Returns the Nth percentile of the group using Quantile Digest algorithm 

PercentileTDigest[0100]  Returns the Nth percentile of the group using Tdigest algorithmâ€‹ 

DISTINCT  Returns the distinct row values in a group 

DISTINCTCOUNT  Returns the count of distinct row values in a group 

DISTINCTCOUNTHLL  Returns an approximate distinct count using HyperLogLog in a group 

DISTINCTCOUNTRAWHLL  Returns HLL response serialized as string. The serialized HLL can be converted back into an HLL and then aggregated with other HLLs. A common use case may be to merge HLL responses from different Pinot tables, or to allow aggregation after clientside batching.  â€‹ â€‹
â€‹ â€‹ 
FASTHLL (Deprecated)  WARN: will be deprecated soon. FASTHLL stores serialized HyperLogLog in String format, which performs worse than DISTINCTCOUNTHLL, which supports serialized HyperLogLog in BYTES (byte array) format 

DistinctCountThetaSketch  See Cardinality Estimationâ€‹  â€‹ 
DistinctCountRawThetaSketch  See Cardinality Estimationâ€‹  â€‹ 
â€‹
The following aggregation functions can be used for multivalue columns
Function  Description  Example 
COUNTMV  Get the count of rows in a group 

MINMV  Get the minimum value in a group 

MAXMV  Get the maximum value in a group 

SUMMV  Get the sum of values in a group 

AVGMV  Get the avg of values in a group 

MINMAXRANGEMV  Returns the min and max value in a group 

PERCENTILE[0100]MV  Returns the Nth percentile of the group where N is between 0100 

PERCENTILEEST[0100]MV  Returns the Nth percentile of the group using Quantile Digest algorithm 

PercentileTDigest[0100]MV  Returns the Nth percentile of the group using Tdigest algorithmâ€‹ 

DISTINCTCOUNTMV  Returns the count of distinct row values in a group 

DISTINCTCOUNTHLLMV  Returns an approximate distinct count using HyperLogLog in a group 

DISTINCTCOUNTRAWHLLMV  Returns HLL response serialized as string. The serialized HLL can be converted back into an HLL and then aggregated with other HLLs. A common use case may be to merge HLL responses from different Pinot tables, or to allow aggregation after clientside batching. 

FASTHLLMV (Deprecated)  stores serialized HyperLogLog in String format, which performs worse than DISTINCTCOUNTHLL, which supports serialized HyperLogLog in BYTES (byte array) format 

â€‹