Aggregate FunctionsPercentile & Sketch
hll
Creates a HyperLogLog sketch.
Syntax
hll(expr)Parameters
Prop
Type
Returns: dynamic
Syntax
hll(expr, accuracy)Parameters
Prop
Type
Returns: dynamic
Syntax
hll(expr, accuracy)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1 — HyperLogLog sketch of warriors per region
datatable(warrior:string, region:string)[
"Ragnar", "Kattegat",
"Bjorn", "Uppsala",
"Ragnar", "Kattegat",
"Harald", "Vestfold"
]
| summarize hll(warrior) by region| region (string) | hll_warrior (dynamic) |
|---|---|
| Kattegat | [[1,14],["-81600670940795597"],[]] |
| Uppsala | [[1,14],["7530398182789397426"],[]] |
| Vestfold | [[1,14],["5968294527843184544"],[]] |
Example 2 — With explicit accuracy parameter
datatable(warrior:string, region:string)[
"Ragnar", "Kattegat",
"Bjorn", "Uppsala",
"Ragnar", "Kattegat",
"Harald", "Vestfold"
]
| summarize hll(warrior, 1) by region| region (string) | hll_warrior (dynamic) |
|---|---|
| Kattegat | [[1,14],["-81600670940795597"],[]] |
| Uppsala | [[1,14],["7530398182789397426"],[]] |
| Vestfold | [[1,14],["5968294527843184544"],[]] |