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
|2022-06-01||String functions||Updated description||The
Updates in April 2022
|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
|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:
||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.
|2022-03-15||SHOW commands||New description||A topic is added to describe all SHOW commands that are supported in MaxCompute.
|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
|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
|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|