| Excerpt | ||
|---|---|---|
| ||
Siddhi Inbuilt Aggregate Functions in wiki format |
...
| Syntax | <int|long|double|float> max(<int|long|double|float> arg) |
|---|---|
| Extension Type | Aggregate Function |
| Description | Returns the maximum value for all the events. |
| Parameter | arg: The value that needs to be compared to find the maximum value. |
| Return Type | Returns the maximum value in the same data type as the input. |
| Example | max(temp) returns the maximum temp value recorded for all the events based on their arrival and expiry. |
Minimum
| Anchor | ||||
|---|---|---|---|---|
|
| Syntax | <int|long|double|float> min(<int|long|double|float> arg) |
|---|---|
| Extension Type | Aggregate Function |
| Description | Returns the minimum value for all the events. |
| Parameter | arg: The value that needs to be compared to find the minimum value. |
| Return Type | Returns the minimum value in the same type as the input. |
| Example | min(temp) returns the minimum temp value recorded for all the events based on their arrival and expiry. |
...
| Syntax | <long> distinctcount(<int|long|double|float|string> arg) |
|---|---|
| Extension Type | Aggregate Function |
| Description | Returns the count of distinct occurrences for a given arg. |
| Parameter | arg: The value that should be counted. |
| Return Type | Returns the count of distinct occurances for a given arg. |
| Example |
|
...
| Syntax | <int|long|double|float> maxForever (<int|long|double|float> arg) |
|---|---|
| Extension Type | Aggregate Function |
| Description | This is the attribute aggregator to store the maximum value for a given attribute throughout the lifetime of the query regardless of any windows in-front. |
| Parameter | arg: The value that needs to be compared to find the maximum value. |
| Return Type | Returns the maximum value in the same data type as the input. |
| Example | maxForever(temp) returns the maximum temp value recorded for all the events throughout the lifetime of the query. |
Forever Minimum
| Anchor | ||||
|---|---|---|---|---|
|
| Syntax | <int|long|double|float> minForever (<int|long|double|float> arg) |
|---|---|
| Extension Type | Aggregate Function |
| Description | This is the attribute aggregator to store the minimum value for a given attribute throughout the lifetime of the query regardless of any windows in-front. |
| Parameter | arg: The value that needs to be compared to find the minimum value. |
| Return Type | Returns the minimum value in the same data type as the input. |
| Example | minForever(temp) returns the minimum temp value recorded for all the events throughout the lifetime of the query. |
| Excerpt | ||
|---|---|---|
| ||
averageTodo add other aggregate functions |
...