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.
APPROX_ COUNT_ DISTINCT_ COMBINE
On this page
Merges two or more HyperLogLog states into a new state and returns a value of type VARBINARY(16384)
representing the new state.
Syntax
APPROX_COUNT_DISTINCT_COMBINE ( expr )
Arguments
expr
An expression evaluating to a scalar value of type VARBINARY(16384)
.
expr
is typically the name of a column.APPROX_
uses values in the column (which are HyperLogLog states) to create a new state.
Remarks
This function is used in conjunction with the APPROX_
and APPROX_
Distinct Count Estimation Functions
Last modified: February 24, 2023