MaxCompute - Provides Built-in Aggregate Functions
Jul 24 2020
MaxComputeContent
Target customers: developers. Features released: MaxCompute provides built-in aggregate functions, such as APPROX_DISTINCT, ANY_VALUE, ARG_MAX, and ARG_MIN. APPROX_DISTINCT(value) returns the approximate number of distinct values. ANY_VALUE(value) returns a single non-deterministic value from the specified value range. ARG_MAX(valueToMaximize, valueToReturn) returns the value of the column specified by valueToReturn that corresponds to the row in which the maximum value of the column specified by valueToMaximize is located. ARG_MIN(valueToMinimize, valueToReturn) returns the value of the column specified by valueToReturn that corresponds to the row in which the minimum value of the column specified by valueToMinimize is located.