Berserk Docs
Aggregate FunctionsPercentile & Sketch

hll_merge

Merges multiple HyperLogLog sketches.

Syntax

hll_merge(sketch)

Parameters

Prop

Type

Returns: dynamic

Examples

Example 1

datatable(warrior:string, region:string)[
  "Ragnar", "Kattegat",
  "Bjorn", "Uppsala",
  "Ragnar", "Kattegat"
]
| summarize sketch = hll(warrior) by region
| summarize hll_merge(sketch)
hll_merge_sketch (dynamic)
[[2,14],["-81600670940795597","7530398182789397426"],[]]

hll_if

Creates a HyperLogLog sketch for records where the predicate evaluates to true.

merge_tdigest

Merges multiple T-Digest sketches.

On this page

SyntaxParametersExamplesExample 1