binary_all_xor() (aggregation function)

  • Article
  • 2 minutes to read

Accumulates values using the binary XOR 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_xor (Expr)

Arguments

  • Expr: long number.

Returns

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

Example

Producing 'cafe-food' using binary XOR operations:

datatable(num:long)
[
  0x44404440,
  0x1E1E1E1E,
  0x90ABBA09,
  0x000B105A,
]
| summarize result = toupper(tohex(binary_all_xor(num)))
result
CAFEF00D