Categories:: Aggregate functions (Cardinality Estimation) , Window functions (Cardinality Estimation)

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¶

Aggregate function

HLL_IMPORT( <obj> )

Copy

Window function

HLL_IMPORT( <obj> ) OVER ( [ PARTITION BY <expr> ] )

Copy

For details about the OVER clause, see Window function syntax and usage.

Arguments¶

obj: An expression that evaluates to a HyperLogLog state in OBJECT format.

Usage notes¶

This function can be used as an aggregate function or a window function.

Examples¶

See examples for HLL_EXPORT.