DS_HLL_ESTIMATE
Estimates the cardinality from a DataSketches HLL sketch.
Analyze Syntax
func.ds_hll_estimate(get_column(table, 'hll_sketch'))
Analyze Examples
func.ds_hll_estimate(get_column(table, 'hll_sketch'))
┌──────┐
│ 9856 │
└──────┘
SQL Syntax
DS_HLL_ESTIMATE(<sketch>)
SQL Examples
SELECT DS_HLL_ESTIMATE(DS_HLL_ACCUMULATE(user_id)) FROM visits;
┌──────┐
│ 9856 │
└──────┘