New Features

MaxCompute - Supports Using GROUPING SET to Aggregate and Analyze Multi-dimensional Data

Mar 26 2019

MaxCompute
MaxCompute SQL supports using the GROUPING SET clause to aggregate and analyze multi-dimensional data.
Content

Target customers: big data developers and analysts. Features released: the GROUPING SET clause provided by MaxCompute is an extension to the GROUP BY clause in the SELECT statement. You can group results in many ways instead of using multiple SELECT statements. For example, when aggregating and analyzing multi-dimensional data, you need to aggregate column a, column b, and the combination of columns a and b. By using GROUPING SET, you do not need to use multiple UNION ALL clauses.

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.