HLL_UNION_AGG

Learn how to use the HLL_UNION_AGG aggregate function in PlaidCloud Lakehouse. Aggregates HLL values by computing the union - with syntax and examples.

Aggregates HLL values by computing the union.

Analyze Syntax

func.hll_union_agg(get_column(table, 'hll_col'))

Analyze Examples

func.hll_union_agg(get_column(table, 'hll_col'))

┌─────────────┐
│ (hll value) │
└─────────────┘

SQL Syntax

HLL_UNION_AGG(<hll_col>)

SQL Examples

SELECT HLL_CARDINALITY(HLL_UNION_AGG(hll_col)) FROM segments;

┌──────┐
│ 8000 │
└──────┘