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

Updates in December 2019

Release date Feature Category Description Documentation
2019-12-25 Open source geospatial UDFs New feature Open source geospatial UDFs are added. You can register open source geospatial UDFs with MaxCompute and use them as open source Hive UDFs. Open source geospatial UDFs

Updates in November 2019

Release date Feature Category Description Documentation
2019-11-06 Description of whether MaxCompute functions support partition pruning New description The description of whether MaxCompute functions support partition pruning is added. Mappings between built-in functions of MaxCompute and built-in functions of Hive, MySQL, and Oracle

Updates in October 2019

Release date Feature Category Description Documentation
2019-10-09 New SQL syntax New feature
  • The syntax to merge partitions is added.
  • The syntax that uses a pair of parentheses () to specify the priorities of operations in JOIN and SETOP statements is added.
  • The built-in function JSON_TUPLE is added.
  • The date function EXTRACT is added.
  • Two flags are added.
  • ORDER BY LIMIT can be used with OFFSET.
  • Default values can be specified for the columns in a table.
  • The NATURAL JOIN statement is supported.
  • New operators are supported.
  • The syntax to delete partitions is added.

Updates in July 2019

Release date Feature Category Description Documentation
2019-07-12 odps-sql-reshuffle-dynamicpt added to the SET command New command odps-sql-reshuffle-dynamicpt is added to configure dynamic partitions. This prevents the excessive generation of small files when dynamic partitions are split. SET operations

Updates in June 2019

Release date Feature Category Description Documentation
2019-06-17 Description of the VALUES statement New description The description of how to create data for simple business testing is added. VALUES