New Features

MaxCompute - MaxCompute SQL Supports Functions and Enhanced Functions That Involve the ARRAY Data Type

Feb 08 2021

MaxCompute SQL supports the ARRAY_INTERSECT function and enhances the SORT_ARRAY function.

Target customers: developers, analysts, and users who want to process semi-structured data. Features released: ARRAY_INTERSECT is added to MaxCompute to calculate the intersection of two arrays. The built-in SORT_ARRAY function is enhanced. The isAsc parameter is added to enable you to determine whether to sort the specified array in ascending or descending order. By default, arrays are sorted in ascending order. MaxCompute will support more functions that involve the ARRAY data type, such as ARRAY_EXCEPT, ARRAY_DISTINCT, and SLICE. These functions make semi-structured data processing more convenient.

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.