min()

The reducer function min() aggregates all values corresponding to the same ID and returns the minimum value.

Syntax

REDUCE( min (arg) )

Accepted parameter types

This function only accepts parameters that can be interpreted as a numeric type.

Return value

INT, UINT, FLOAT, DOUBLE: minimum of all arg values cumulatively received

Example

If we have the following data in a CSV file of the different scores of test takers, and we want to load the lowest score to an attribute of the vertex:

name	score
Tommy	95
Tommy	93
Tommy	92
Amy	85
Amy	94
Amy	99

We can use write the following load statement to use the min() reduce function to load the minimum of the scores matching each vertex ID.

LOAD f TO VERTEX Person
  VALUES ($"name", REDUCE(min($"score"))

After loading, Tommy has a score attribute of 92 and Amy has a score attribute of 85.