New Features

MaxCompute - Provides Built-in Aggregate Functions

Jul 24 2020

MaxCompute
MaxCompute provides built-in aggregate functions, such as APPROX_DISTINCT, ANY_VALUE, ARG_MAX, and ARG_MIN.
Content

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.

7th Gen ECS Is Now Available

Increase instance computing power by up to 40% and Fully equipped with TPM chips.
Powered by Third-generation Intel® Xeon® Scalable processors (Ice Lake).

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.