Scalar Functions

This section provides reference information for the HLL (HyperLogLog) scalar functions in PlaidCloud Lakehouse.

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.

HLL_EMPTY

Learn how to use the HLL_EMPTY scalar function in PlaidCloud Lakehouse. Returns an empty HLL value - see syntax, examples, and output.

HLL_HASH

Learn how to use the HLL_HASH scalar function in PlaidCloud Lakehouse. Computes an HLL hash of a value - see syntax, examples, and output.