HLL_CARDINALITY

Learn how to use the HLL_CARDINALITY scalar function in PlaidCloud Lakehouse. Returns the cardinality estimate from an HLL value - with syntax and examples.

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  │
└───────┘