Aggregation Functions
This page lists the aggregation functions available in the GSQL query language. These functions take a single SET
, BAG,
SetAccum
, BagAccum
, or ListAccum
as the parameter and return an aggregated value from all members of the set or bag.
The DISTINCT
keyword can be used to include repeated values only once when aggregating.
avg()
Syntax
avg( [DISTINCT] setExp )
Description
Returns the average of all elements in a set or bag. The function can only take set/bag expressions whose members are numeric types.
Return type
A numeric type. If all members of the set/bag expression are integers, the return value will also be rounded down to be an integer.
Parameters
Parameter | Description | Data type |
| An expression that evaluates to a |
|
Example
count()
Syntax
count( [DISTINCT] setExp )
Description
Returns the size of the set or bag.
Return type
INT
Parameters
Parameter | Description | Data type |
| An expression that evaluates to a |
|
max()
Syntax
max( [DISTINCT] setExp )
Description
Returns the member with the maximum value in a set or bag. The function can only take set/bag expressions whose members are numeric types.
Return type
A numeric type.
Parameters
Parameter | Description | Data type |
| An expression that evaluates to a |
|
min()
Syntax
min( [DISTINCT] setExp )
Description
Returns the member with the minimum value in a set or bag. The function can only take set/bag expressions whose members are numeric types.
Return type
A numberic type.
Parameters
Parameter | Description | Data type |
| An expression that evaluates to a |
|
sum()
Syntax
sum( [DISTINCT] setExp )
Description
Returns the sum of all members in a set or bag. The function can only take set/bag expressions whose members are numeric types.
Return type
A numeric type.
Parameters
Parameter | Description | Data type |
| An expression that evaluates to a |
|
Last updated