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 merged = hll_merge(sketch)
| project warriors = dcount_hll(merged)| warriors (long) |
|---|
| 2 |