New Features

MaxCompute - Supports Syntax of Multi-column Operations in MaxCompute SQL Subqueries

MaxCompute SQL allows you to use the syntax of multi-column operations in an IN subquery or scalar subquery.
Content

Target customers: developers and analysts. Features released: MaxCompute SQL is compatible with the syntax of PostgreSQL subqueries. You can use the syntax of multi-column operations in an IN subquery or scalar subquery. IN subquery: The value of the IN expression in the WHERE clause can be multiple columns of SELECT statements or multiple constants. The value can also contain aggregate functions. Scalar subquery: The following multi-column scenarios are supported: 1. The SELECT statement contains multiple columns of scalar subqueries, which must be equivalent expressions. 2. The SELECT statement contains multiple columns of Boolean expressions for equivalent comparison. 3. The WHERE clause contains multiple columns of equivalent expressions.

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.