binary_all_or() (aggregation function)

Accumulates values using the binary OR operation per summarization group (or in total, if summarization is done without grouping).

  • Can be used only in context of aggregation inside summarize

Syntax

summarize binary_all_or(Expr)

Arguments

  • Expr: long number.

Returns

Returns a value that is aggregated using the binary OR operation over records per summarization group (or in total, if summarization is done without grouping).

Example

Producing 'cafe-food' using binary OR operations:

datatable(num:long)
[
  0x88888008,
  0x42000000,
  0x00767000,
  0x00000005, 
]
| summarize result = toupper(tohex(binary_all_or(num)))
result
CAFEF00D