kql_build.op_mutate: dplyr's mutate verb can include aggregations, but Kusto's...

In AzureKusto: Interface to 'Kusto'/'Azure Data Explorer'

dplyr's mutate verb can include aggregations, but Kusto's extend verb cannot. If the mutate contains no aggregations, then it can emit an extend clause. If the mutate contains an aggregation and the tbl is ungrouped, then it must emit a summarize clause grouped by all variables. If the mutate contains an aggregation and the tbl is grouped, then it must join to a subquery containing the summarize clause.

Description

dplyr's mutate verb can include aggregations, but Kusto's extend verb cannot. If the mutate contains no aggregations, then it can emit an extend clause. If the mutate contains an aggregation and the tbl is ungrouped, then it must emit a summarize clause grouped by all variables. If the mutate contains an aggregation and the tbl is grouped, then it must join to a subquery containing the summarize clause.

Usage

## S3 method for class 'op_mutate'
kql_build(op, ...)

Arguments

op	A nested sequence of query operations, i.e. tbl_kusto$ops
...	Needed for agreement with generic. Not otherwise used.

AzureKusto documentation built on Oct. 12, 2023, 5:11 p.m.