Apache Pinot Docs
Search…
latest
For Users
For Developers
For Operators
Configuration Reference
SEGMENTPARTITIONEDDISTINCTCOUNT
This section contains reference documentation for the SEGMENTPARTITIONEDDISTINCTCOUNT function.
Returns the count of distinct values of a column when the column is pre-partitioned for each segment, where there is no common value within different segments. This function calculates the exact count of distinct values within the segment, then simply sums up the results from different segments to get the final result.
This function relies on the expression values being partitioned for each segment, where there are no common values within different segments.
Signature
SEGMENTPARTITIONEDDISTINCTCOUNT(colName)
Usage Examples
1
select SEGMENTPARTITIONEDDISTINCTCOUNT(teamID) AS value
2
from baseballStats
Copied!
value
149
Last modified 1mo ago
Copy link