Apache Pinot Docs
latest
Ask or search…
K
Comment on page

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.
select DISTINCTCOUNT(league) AS value
from baseballStats
value
7
select DISTINCTCOUNT(teamID) AS value
from baseballStats
value
149