Apache Pinot Docs
Search…
latest
Configuration Reference
DISTINCT
This section contains reference documentation for the DISTINCT function.
Returns the distinct row values in a group

Signature

DISTINCT(colName)

Usage Examples

These examples are based on the Batch Quick Start.
1
select DISTINCT league AS value
2
from baseballStats
Copied!
value
NL
UA
AL
NA
PL
AA
FL
1
select DISTINCT(league) AS value
2
from baseballStats
Copied!
value
NL
UA
AL
NA
PL
AA
FL
Copy link