op functions (Aggregate Functions for Building groupBy Parameters)
The following functions are aggregate functions for building parameters used by the prototype.groupBy method.
11 functions
| Function name | Description |
|---|---|
| op:array-aggregate | This function constructs an array whose items are the result of evaluating the column for each row in the group or row set. |
| op:avg | This function averages the non-null values of the column for the rows in the group or row set. |
| op:count | This function counts the rows where the specified input column has a value. |
| op:group-concat | This function concatenates the non-null values of the column for the rows in the group or row set. |
| op:has-group-key | This aggregate function adds a flag to a grouped row specifying whether a column acted as a grouping key for the row. |
| op:max | This function gets the largest non-null value of the column for the rows in the group or row set. |
| op:min | This function gets the smallest non-null value of the column for the rows in the group or row set. |
| op:sample | This function randomly selects one non-null value of the column from the rows in the group or row set. |
| op:sequence-aggregate | This call constructs a sequence whose items are the values of a column for each row in the group or row set. |
| op:sum | This function adds the non-null values of the column for the rows in the group or row set. |
| op:uda | This function processes the values of column for each row in the group or row set with the specified user-defined aggregate as implemented by an aggregate user-defined function (UDF) plugin. |