This topic describes the latest updates to MaxCompute documentation in 2022. These updates allow you to understand the new features, new syntax, and permission updates in MaxCompute and help you improve project development efficiency.

Updates in June 2022

Release date Feature Category Description References
2022-06-01 String functions Updated description The KEYVALUE_TUPLE function is added. String functions

Updates in April 2022

Release date Feature Category Description References
2022-04-14 Support for the EXCEPT and REPLACE clauses Updated description When a SELECT statement is used to query data, the EXCEPT or REPLACE clause can be added to the SELECT statement to exclude some columns or modify data in some columns. SELECT syntax
2022-04-14 Optimization of the content of OSS external tables Updated description The structure of the document content that is related to OSS external tables is optimized to present useful information. Set up a Spark on MaxCompute development environment
2022-04-07 Python UDF examples New example Examples on how to use Python user-defined functions (UDFs) to process data of complex data types and reference tables or resources are added.

Updates in March 2022

Release date Feature Category Description References
2022-03-24 Best practices for transposing rows to columns or columns to rows New description The best practices for transposing rows to columns or columns to rows are added.

Examples are provided to demonstrate how to use SQL statements to transpose rows to columns or columns to rows.

Transpose rows to columns or columns to rows
2022-03-18 Data in open source formats Updated description The following properties are added for data in the Parquet format:
  • parquet.file.cache.size
  • parquet.io.buffer.size
Create an OSS external table
2022-03-18 Complex type functions Updated description Examples on using the GET_JSON_OBJECT and JSON_TUPLE functions are added. Complex type functions
2022-03-18 String functions Updated description Descriptions of the TRIM, LTRIM, and RTRIM functions are updated. String functions
2022-03-18 DISTRIBUTED MAPJOIN New description A topic is added to describe DISTRIBUTED MAPJOIN.

DISTRIBUTED MAPJOIN is an optimized version of MAPJOIN. DISTRIBUTED MAPJOIN is suitable for scenarios in which small tables need to be joined with large tables.

DISTRIBUTED MAPJOIN
2022-03-15 SHOW commands New description A topic is added to describe all SHOW commands that are supported in MaxCompute.

SHOW commands
2022-03-09 FAQ Updated description
  • Issues that are related to sandboxes and third-party packages are added.
  • A common issue about running SQL jobs in Java business code is added.
  • MaxCompute FAQ is provided.
2022-03-01 Permission management Updated description The document content that is related to permissions is modified. Permission overview
2022-03-01 Compatibility with Apache Spark 3.1 Updated description MaxCompute is compatible with Apache Spark 3.1 in addition to the following Apache Spark versions: 1.6, 2.3, and 2.4. Set up a Spark on MaxCompute development environment

Updates in February 2022

Release date Feature Category Description References
2022-02-28 Management of external projects based on SQL statements Updated description The document content that is related to external project management based on SQL statements is modified. Use SQL statements to manage an external project
2022-02-23 Addition or deletion of columns and column order change New description The syntax and examples for adding or deleting columns are added. The descriptions that are related to the column order change are added. Partition and column operations
2022-02-14 Common errors for built-in functions New description A topic is added to describe common errors for built-in functions. Common errors for built-in functions
2022-02-11 Graph operations Updated description Descriptions about how to write a Graph job by using the single source shortest path (SSSP) algorithm are optimized. Write a Graph job

Updates in January 2022

Release date Feature Category Description References
2022-01-30 FAQ Updated description FAQ is categorized based on the issue type. This helps you quickly find the solution to a specific issue. FAQ
2022-01-30 External projects Updated description The data lakehouse solution can be implemented in MaxCompute by using external projects. Project
2022-01-24 Best practice for permission management New practice The best practice for policy-based permission management for users who are assigned built-in roles is added. Policy-based permission management for users assigned built-in roles
2022-01-21 Typical use cases of built-in functions New description Descriptions related to the implementation of the GROUP_CONCAT function and the precision issue of the ROUND function are added.
2022-01-05 Change of complex type functions Updated description The mapDupKeyPolicy parameter is added to the following functions: MAP_CONCAT, MAP_FROM_ARRAYS, MAP_FROM_ENTRIES, MAP, and STR_TO_MAP. The odps.sql.map.key.dedup.policy parameter can be configured at the session level to take the same effect as the mapDupKeyPolicy parameter. Complex type functions