DISTINCTCOUNT
This section contains reference documentation for the DISTINCTCOUNT function.
Was this helpful?
⌘Ctrlk
This section contains reference documentation for the DISTINCTCOUNT function.
Returns the count of distinct row values in a group.
DISTINCTCOUNTHLL()is faster than DISTINCTCOUNT()if data is pre-aggregated at ingestion or aggregated at a server with enough records. This performance improvement increases when comparing large datasets.
If very few records are pre-aggregated, DISTINCTCOUNT()is faster than DISTINCTCOUNTHLL()because the serialized HLL size is larger than sending individual values.
DISTINCTCOUNT(colName)
These examples are based on the Batch Quick Start.
select DISTINCTCOUNT(league) AS value
from baseballStats 7
select DISTINCTCOUNT(teamID) AS value
from baseballStats 149
Was this helpful?
Was this helpful?