Apache Pinot Docs
Search…
latest
DISTINCTCOUNT
This section contains reference documentation for the DISTINCTCOUNT function.
Returns the count of distinct row values in a group

Signature

DISTINCTCOUNT(colName)

Usage Examples

These examples are based on the Batch Quick Start.
1
select DISTINCTCOUNT(league) AS value
2
from baseballStats
Copied!
value
7
1
select DISTINCTCOUNT(teamID) AS value
2
from baseballStats
Copied!
value
149
Last modified 1mo ago
Copy link