summarise: Summarise method for Kusto tables

Description Usage Arguments See Also Examples

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

1
2
3
4
5
6
7
8
## 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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
## 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")) # shuffle summarise with shuffle keys

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

## End(Not run)

AzureKusto documentation built on April 28, 2020, 1:06 a.m.