HLL_CARDINALITY (Lakehouse v2)

Returns the cardinality estimate from an HLL value.

Analyze Syntax

func.hll_cardinality(<hll>)

Analyze Examples

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

┌───────┐
│ 10000  │
└───────┘

SQL Syntax

HLL_CARDINALITY(<hll>)

SQL Examples

SELECT HLL_CARDINALITY(hll_col) FROM sketches;

┌───────┐
│ 10000  │
└───────┘