This page lists 5 functions in the spql.agg namespace generated from the default SPQL function catalog.
| Function | Kind | Summary |
|---|---|---|
spql.agg.count | aggregate function | Count non-null values. |
spql.agg.first | aggregate function | Return the first value. |
spql.agg.last | aggregate function | Return the last value. |
spql.agg.minmax | aggregate function | Return the minimum and maximum values. |
spql.agg.sum | aggregate function | Sum values. |
spql.agg.count
Kind: aggregate function
Count non-null values.
Signature
spql.agg.count(value)
Parameters
| Name | Required | Description |
|---|---|---|
value | yes | No parameter docs. |
Returns
The count over the aggregate input.
spql.agg.first
Kind: aggregate function
Return the first value.
Signature
spql.agg.first(value)
Parameters
| Name | Required | Description |
|---|---|---|
value | yes | No parameter docs. |
Returns
The first value in aggregate order.
spql.agg.last
Kind: aggregate function
Return the last value.
Signature
spql.agg.last(value)
Parameters
| Name | Required | Description |
|---|---|---|
value | yes | No parameter docs. |
Returns
The last value in aggregate order.
spql.agg.minmax
Kind: aggregate function
Return the minimum and maximum values.
Signature
spql.agg.minmax(value)
Parameters
| Name | Required | Description |
|---|---|---|
value | yes | No parameter docs. |
Returns
A struct containing the minimum and maximum values.
spql.agg.sum
Kind: aggregate function
Sum values.
Signature
spql.agg.sum(value)
Parameters
| Name | Required | Description |
|---|---|---|
value | yes | No parameter docs. |
Returns
The sum over the aggregate input.