HLL_RAW_AGG
Description
The HLL_RAW_AGG function is an aggregate function, which is mainly used to merge multiple HyperLogLog data structures.
Alias
- HLL_UNION
Syntax
HLL_RAW_AGG(<hll>)
Parameters
Parameters | Description |
---|---|
<hll> | The HyperLogLog type expression to be calculated |
Return Value
Returns the aggregated value of type HyperLogLog.
Example
select HLL_CARDINALITY(HLL_RAW_AGG(uv_set)) from test_uv;
+------------------------------------------+
| HLL_CARDINALITY(HLL_RAW_AGG(`uv_set`)) |
+------------------------------------------+
| 17721 |
+------------------------------------------+