summarise function

Summarise method for Kusto tables

This method is the same as other summarise methods, with the exception of the .strategy, .shufflekeys and .num_partitions optional arguments. They provide hints to the Kusto engine on how to execute the summarisation, and can sometimes be useful to speed up a query. See the Kusto documentation for more details.

## S3 method for class 'tbl_kusto_abstract'
summarise(
  .data,
  ...,
  .strategy = NULL,
  .shufflekeys = NULL,
  .num_partitions = NULL
)

Arguments

• .data: A Kusto tbl.
• ...: Summarise expressions.
• .strategy: A summarise strategy to pass to Kusto. Currently the only value supported is "shuffle".
• .shufflekeys: A character vector of column names to use as shuffle keys.
• .num_partitions: The number of partitions for a shuffle query.

Examples

## Not run:

tbl1 <- tbl_kusto(db, "table1")

## standard dplyr syntax:
summarise(tbl1, mx = mean(x))

## Kusto extensions:
summarise(tbl1, mx = mean(x), .strategy = "broadcast") # a broadcast summarise

summarise(tbl1, mx = mean(x), .shufflekeys = c("var1", "var2")) # a shuffle summarise with keys

summarise(tbl1, mx = mean(x), .num_partitions = 5) # no. of partitions for a shuffle summarise
## End(Not run)

See Also

dplyr::summarise