summarise: Summarise method for Kusto tables

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

Summarise method for Kusto tables

Description

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.

Usage

## 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.

See Also

dplyr::summarise

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)

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