binary_all_or() (aggregation function)

  • Article
  • 2 minutes to read

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

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