The output column's name and the expression that computes it, as "Out = expression".
ReadonlytypeStaticAggStaticAggCreates an Approximate Percentile aggregation using T-Digest.
the percentile to calculate, must be in the range [0.0, 1.0]
Optionalcompression: number
T-Digest compression factor, which must be ≥ 1. Values above 1000 are not recommended. If
null, the server chooses a default.
Optionalcolumns: readonly (string | Column)[]
the columns to aggregate, which can be renaming expressions such as "Out = In". Defaults
to null, which is valid only in aggAllBy where it will be ignored.
an aggregation
StaticAggStaticAggStaticAggCreates a Count Distinct aggregation, counting the number of distinct values in each group.
an aggregation
StaticAggCreates a CountWhere aggregation, counting rows that match the given filter(s) in each group. Not supported in aggAllBy.
the output column name to hold the counts
the filter expression(s) to apply before counting
an aggregation
StaticAggCreates a Distinct aggregation, collecting the distinct values within each group as arrays.
OptionalincludeNulls: boolean
whether null values should be included in the distinct output values. Defaults to
false.
Optionalcolumns: readonly (string | Column)[]
the columns to aggregate, which can be renaming expressions such as "Out = In". Defaults
to null, which is valid only in aggAllBy where it will be ignored.
an aggregation
StaticAggCreates a First aggregation, returning the first value in each group.
an aggregation
StaticAggCreates a FirstRowKey aggregation, returning the row key of the first row in each group. Not supported in aggAllBy.
the output column name to hold the first row key
an aggregation
StaticAggCreates a Formula aggregation, computing one output column per group from a formula such as
"MaxW = max(W)". See Formula for what the column names in the expression stand for.
the output column's name and the expression that computes it, as "Out = expression"
an aggregation
StaticAggCreates a Freeze aggregation, which keeps the first value seen and ignores subsequent changes.
an aggregation
StaticAggStaticAggCreates a Last aggregation, returning the last value in each group.
an aggregation
StaticAggCreates a LastRowKey aggregation, returning the row key of the last row in each group. Not supported in aggAllBy.
the output column name to hold the last row key
an aggregation
StaticAggStaticAggCreates a Median aggregation.
OptionalaverageEvenlyDivided: boolean
when the group size is even, whether to average the two middle values. When
true, averages the two middle values. When false, uses the larger value. Only int,
long, float and double columns are averaged. Defaults to true.
Optionalcolumns: readonly (string | Column)[]
the columns to aggregate, which can be renaming expressions such as "Out = In". Defaults
to null, which is valid only in aggAllBy where it will be ignored.
an aggregation
StaticAggStaticAggCreates a Partition aggregation, splitting the table into sub-tables, one per group. Not supported in aggAllBy.
the output column name to hold the sub-tables
OptionalincludeGroupByColumns: boolean
whether to include the group-by columns in each sub-table. Defaults to true
an aggregation
StaticAggCreates a Percentile aggregation.
the percentile to calculate, must be in the range [0.0, 1.0]
OptionalaverageEvenlyDivided: boolean
whether to average the two boundary values when the percentile falls evenly between
them. Only int, long, float and double columns are averaged. Defaults to
false if not specified
Optionalcolumns: readonly (string | Column)[]
the columns to aggregate, which can be renaming expressions such as "Out = In". Defaults
to null, which is valid only in aggAllBy where it will be ignored.
an aggregation
StaticAggCreates a SortedFirst aggregation, returning the first value when each group is sorted by the given columns.
the columns to sort by when determining the "first" row
Optionalcolumns: readonly (string | Column)[]
the columns to aggregate, which can be renaming expressions such as "Out = In". Defaults
to null, which is valid only in aggAllBy where it will be ignored.
an aggregation
StaticAggCreates a SortedLast aggregation, returning the last value when each group is sorted by the given columns.
the columns to sort by when determining the "last" row
Optionalcolumns: readonly (string | Column)[]
the columns to aggregate, which can be renaming expressions such as "Out = In". Defaults
to null, which is valid only in aggAllBy where it will be ignored.
an aggregation
StaticAggCreates a Std (sample standard deviation) aggregation, computed using Bessel's correction.
an aggregation
StaticAggStaticAggCreates a T-Digest aggregation, storing the T-Digest data structure for later percentile calculations.
Optionalcompression: number
T-Digest compression factor, which must be ≥ 1. If null, the server chooses a
default.
Optionalcolumns: readonly (string | Column)[]
the columns to aggregate, which can be renaming expressions such as "Out = In". Defaults
to null, which is valid only in aggAllBy where it will be ignored.
an aggregation
StaticAggCreates a Unique aggregation, returning the single unique value within each group. If there is more than one
distinct value, the result is nonUniqueSentinel.
Optionalcolumns: readonly (string | Column)[]
the columns to aggregate, which can be renaming expressions such as "Out = In". Defaults
to null, which is valid only in aggAllBy where it will be ignored.
OptionalincludeNulls: boolean
whether null is treated as a value for determining uniqueness. Defaults to false.
OptionalnonUniqueSentinel: NonUniqueSentinelUnion
the value for a group with more than one distinct value. Defaults to null.
an aggregation
StaticAggCreates a Var (sample variance) aggregation, computed using Bessel's correction.
an aggregation
StaticAggStaticAgg
An aggregation that computes one output column per group from a formula written as
"Out = expression". Within the expression, each input column stands for that column's values in the group, as a vector, so the expression applies functions that reduce them, as in"MaxW = max(W)"or"Spread = max(W) - min(W)".