New Features

MaxCompute - Supports Input Presorting for Some Aggregate Functions in MaxCompute SQL

Jul 30 2021

MaxCompute SQL allows you to presort the input of WM_CONCAT, COLLECT_LIST, and UDAFs.

Target customers: developers and analysts. Features released: In MaxCompute SQL, when you use the aggregate function WM_CONCAT or COLLECT_LIST or a UDAF that is sensitive to the input order, you can use the WITHIN GROUP (ORDER BY col1[, col2...]) clause to specify the columns by which you want to sort input. In this case, the input of the aggregate function is sorted.

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.