Feedback Edit

binary_all_and() (aggregation function)

  • Article
  • 2 minutes to read

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

Producing 'cafe-food' using binary AND operations:

datatable(num:long)
[
  0xFFFFFFFF, 
  0xFFFFF00F,
  0xCFFFFFFD,
  0xFAFEFFFF,
]
| summarize result = toupper(tohex(binary_all_and(num)))
result
CAFEF00D