max()

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

Syntax

REDUCE( max (arg) )

Accepted parameter types

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

Return value

INT, UINT, FLOAT, DOUBLE: maximum 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 highest 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 max() reduce function to load the maximum of the scores matching their vertex ID.

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

After loading, Tommy has a score attribute of 95 and Amy has a score attribute of 99.