New Features

MaxCompute - Supports Adding Only Column IDs After the GROUP BY and ORDER BY Clauses in New Flags

Oct 28 2019

MaxCompute
MaxCompute allows you to add only column IDs after the GROUP BY and ORDER BY clauses in new flags. This delivers richer syntax to write SQL statements.
Content

Target customers: Alibaba Cloud MaxCompute users. Feature Released: 1. In the set flagset hive.groupby.position.alias=true; statement, the integer constant in GROUP BY is processed as a column ID in the SELECT clause. Example: set hive.groupby.position.alias=true; select region, sum(total_price) from sale_detail group by 1; (Constant 1 indicates the first column in the SELECT clause, which is region.) 2. In the set flagset hive.orderby.position.alias=true; statement, the integer constant in ORDER BY is processed as a column ID in the SELECT clause. For example, if two BIGINT type columns that are named key and value are created in the src table, the SELECT * FROM src ORDER BY 2 limit 100; statement is equivalent to the SELECT * FROM src ORDER BY value limit 100 statement.

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.