DS_HLL_ACCUMULATE

Accumulates values into a DataSketches HLL sketch for approximate distinct counting.

Analyze Syntax

func.ds_hll_accumulate(get_column(table, 'user_id'))

Analyze Examples

func.ds_hll_accumulate(get_column(table, 'user_id'))

┌──────────────┐
 (hll sketch) 
└──────────────┘

SQL Syntax

DS_HLL_ACCUMULATE(<expr>)

SQL Examples

SELECT DS_HLL_ESTIMATE(DS_HLL_ACCUMULATE(user_id)) FROM visits;

┌──────┐
 9856 
└──────┘