summarise: Summarise method for Kusto tables

summarise.tbl_kusto_abstractR Documentation

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.