binary_all_xor()（聚合函数）binary_all_xor() (aggregation function)

• 10/29/2020
• • o
  • v

使用每个汇总组的二进制 XOR 操作累计值（如果没有分组就完成了汇总，则返回总计值）。Accumulates values using the binary XOR operation per summarization group (or in total, if summarization is done without grouping).

• 只能在 summarize 内的聚合上下文中使用Can be used only in context of aggregation inside summarize

语法Syntax

summarize binary_all_xor(Expr)summarize binary_all_xor(Expr)

参数Arguments

• Expr ：长整型数字。Expr : long number.

返回Returns

返回使用二进制 XOR 操作对每个汇总组的记录进行聚合所得的值（如果没有分组就完成了汇总，则返回总计值）。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

使用二进制 XOR 操作生成“cafe-food”：Producing 'cafe-food' using binary XOR operations:

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