Contribute in GitHub:
Edit online
binary_all_and() (aggregation function)
Accumulates values using the binary AND operation per summarization group (or in total, if summarization is done without grouping).
- Can be used only in context of aggregation inside summarize
Syntax
binary_all_and (Expr)
Arguments
- Expr: long number.
Returns
Returns a value that is aggregated using the binary AND operation over records per summarization group (or in total, if summarization is done without grouping).
Example 1
Using binary AND operations:
events
| summarize result = binary_all_and(100)
| distinct result1
Results
| result_1 |
|---|
| 100 |
Example 2
print result_2 = binary_all_and(0x42000000)
Results
| result_2 |
|---|
| 1107296256 |