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.