Apache Pinot Docs
latest
Search…
⌃K

DISTINCTAVG

This section contains reference documentation for the DISTINCTAVG function.
Returns the average of distinct row values in a group

Signature

DISTINCTAVG(colName) or avg(distinct col)

Usage Examples

These examples are based on the Batch Quick Start.
SELECT DISTINCTAVG(runs) AS VALUE
FROM baseballStats
VALUE
83.36526946107784
SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStats
VALUE
349.1158798283262