tuple_sketch_estimate_integer function

Applies to: Databricks Runtime 18.1 and above

Returns the estimated number of unique keys from a TupleSketch with integer summaries.

Syntax

tuple_sketch_estimate_integer ( sketch )

Arguments

• sketch: A TupleSketch in binary format with integer summaries.

Returns

A DOUBLE value representing the estimated distinct count of keys.

Error messages

• TUPLE_INVALID_INPUT_SKETCH_BUFFER

Examples

> SELECT tuple_sketch_estimate_integer(tuple_sketch_agg_integer(key, summary)) FROM VALUES (1, 1), (1, 2), (2, 3) tab(key, summary);
2.0

Related

• tuple_sketch_estimate_double function
• tuple_sketch_summary_integer function