Categories:

Aggregate Functions (Cardinality Estimation) , Window Functions

HLL_IMPORT¶

Converts input in OBJECT format to BINARY format.

The HyperLogLog states operated on by HLL_ACCUMULATE, HLL_COMBINE, and HLL_ESTIMATE are in a proprietary binary format that may change in future versions of Snowflake. For long-term storage of HyperLogLog states, and for integration with external tools, Snowflake supports using HLL_IMPORT to convert states from an OBJECT format to BINARY, and vice versa.

See also:

HLL , HLL_ACCUMULATE , HLL_ESTIMATE , HLL_EXPORT

Syntax¶

HLL_IMPORT(obj)
Copy

Examples¶

See examples for HLL_EXPORT.