kll_sketch_to_string_bigint function

Applies to: Databricks Runtime 18.0 and later

Returns a human-readable string representation of an integer KLL sketch for debugging.

Syntax

kll_sketch_to_string_bigint ( sketch )

Arguments

• sketch: A BINARY expression containing a serialized integer KLL sketch.

Returns

A STRING containing debug information including: sketch parameters, item count, min/max values, and internal structure.

Notes

• Primarily intended for debugging and troubleshooting.
• Output format may change between versions.

Examples

SQL

> WITH sketch_data AS (
    SELECT kll_sketch_agg_bigint(value) AS sketch
    FROM VALUES (1), (2), (3), (4), (5) AS T(value)
  )
  SELECT kll_sketch_to_string_bigint(sketch) FROM sketch_data
  ### KLL sketch summary:
     k            : 200
     n            : 5
     ...

Related functions

• kll_sketch_agg_bigint aggregate function
• kll_sketch_to_string_float function
• kll_sketch_to_string_double function