Skip to main content

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

ParametersDescription
<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 |
+------------------------------------------+