minimum (Aggregate Function)
Returns the minimum value of the input parameters.
Syntax
<INT|LONG|DOUBLE|FLOAT> minimum(<INT|LONG|DOUBLE|FLOAT> arg, <INT|LONG|DOUBLE|FLOAT> ...)
Query Parameters
| Name | Description | Default Value | Possible Data Types | Optional | Dynamic |
|---|---|---|---|---|---|
| arg | This function accepts one or more parameters. They can belong to any one of the available types. All the specified parameters should be of the same type. | INT LONG DOUBLE FLOAT | No | Yes |
Example
@info(name = 'query1')
FROM inputStream
INSERT INTO outputStream
SELECT minimum(price1, price2, price3) AS min;
This query, named 'query1', calculates the minimum value among price1, price2, and price3 fields in each record from the inputStream using the minimum(price1, price2, price3) function. The resulting minimum value is then inserted into the outputStream as the min field.
Essentially, this query processes records in the inputStream, calculates the minimum value among the three price fields, and then creates new records in the outputStream with the calculated min value.