COUNT_ DISTINCT_ ESTIMATE
On this page
Returns an estimate of the number of distinct values for one or more HyperLogLog states.
APPROX_COUNT_DISTINCT_ESTIMATE ( expr )
An expression evaluating to a scalar value of type
APPROX_ returns the number of distinct values.
expr may be the name of a column.
APPROX_ combines values in the column (which are HyperLogLog states) and returns the number of distinct values in the combined state.
This function is used in conjunction with
Last modified: February 24, 2023