MaxCompute - Supports Using GROUPING SET to Aggregate and Analyze Multi-dimensional Data
Mar 26 2019MaxCompute
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.