APPROX_ COUNT_ DISTINCT_ ESTIMATE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Returns an estimate of the number of distinct values for one or more HyperLogLog states.
Syntax
APPROX_COUNT_DISTINCT_ESTIMATE ( expr )
Arguments
expr
An expression evaluating to a scalar value of type VARBINARY(16384)
.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.
Remarks
This function is used in conjunction with APPROX_
and APPROX_
.
Last modified: February 24, 2023