statsby

Type of operation: Aggregate

Description

Calculate statistics of columns with aggregate functions, based on (optional) grouping columns. If you want a accelerable version, consider timestats or timechart.

If groupby is not specified, the default grouping will be used. The default grouping for statsby is the set of primary key columns.

Usage

statsby [ groupby ] ..., groupOrAggregateFunction ...

Argument

Type

Required

Multiple

groupby

fieldref

Optional

Can be multiple

groupOrAggregateFunction

expression

Required

Can be multiple

Accelerable

statsby is never accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

statsby Count:count(1), group_by(server_name)

Group input data by server name, calculating a count of rows per server name, returning a dataset with the two columns server_name and Count.