Key feature release notes
Major MaxCompute feature releases listed by date, with descriptions and reference links.
All major MaxCompute feature updates are tracked on the Product Updates page.
2025
July
Feature | Description | Release date | Regions | References |
MaxCompute supports automatic partitioned tables based on time calculation functions | You can partition a table by applying functions to time or date columns. MaxCompute uses the function results to generate partition values automatically. | 2025-07-31 | All regions | Automatic partitioned tables based on time calculation functions |
MaxCompute supports automatic partitioned tables based on data ingestion time | MaxCompute captures data write timestamps and applies TRUNC_TIME to generate partition column values automatically. | 2025-07-31 | All regions | |
MaxFrame now supports worker-level CPU and memory monitoring for jobs | MaxFrame lets you use Fuxi Sensor to view the actual CPU and memory consumption of a specific worker. | 2025-07-17 | All regions | |
New built-in large models for MaxFrame AI Function | MaxFrame AI Function now includes built-in Qwen 3 series models, ranging from Qwen3-0.6B to Qwen3-14B. | 2025-07-17 | All regions | |
MaxFrame now supports partial commit for jobs | In large-scale jobs, some Fuxi instances may run indefinitely due to data skew or infinite loops. Partial commit lets you ignore a small fraction of tasks and retrieve results from successful instances even if the overall job fails. | 2025-07-17 | All regions |
May
Feature | Description | Release date | Regions | References |
MaxCompute SQL engine enhancements | SQL V51 is now available and includes the following updates:
| 2025-05-30 | All regions |
April
Feature | Description | Release date | Regions | References |
Enhanced observability for MaxCompute data transmission service | This update optimizes metric collection and processing for improved data accuracy. You can now view resource usage at the project level with more options, providing greater observability for the data transmission service. | 2025-04-24 | China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Chengdu), China East 1 Finance, China (Hong Kong), Singapore, Japan (Tokyo), Malaysia (Kuala Lumpur), Indonesia (Jakarta), Germany (Frankfurt), UK (London), US (Silicon Valley), US (Virginia), and SAU (Riyadh - Partner Region) | |
MaxFrame AI Function is now available | MaxFrame AI Function provides a programming interface to call large models for offline processing of massive datasets in MaxCompute tables. | 2025-04-09 | China (Hangzhou), China (Shanghai), China (Beijing), China (Zhangjiakou), China (Ulanqab), China (Shenzhen), China (Chengdu), China (Hong Kong), Japan (Tokyo), Singapore, Malaysia (Kuala Lumpur), Indonesia (Jakarta), Germany (Frankfurt), UK (London), US (Silicon Valley), US (Virginia), UAE (Dubai), and SAU (Riyadh - Partner Region) |
March
Feature | Description | Release date | Regions | References |
Cost estimation for custom tiered storage policies is now available | You can now estimate storage cost changes for custom tiered storage policies (in addition to the default policy), helping you make informed decisions when configuring policy attributes. | 2025-03-24 | China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Chengdu), China (Zhangjiakou), China (Ulanqab), China (Hong Kong), Japan (Tokyo), Singapore, Malaysia (Kuala Lumpur), Indonesia (Jakarta), and Germany (Frankfurt) | |
Multi-zone storage is now available | MaxCompute now offers multi-zone storage (the previous default is renamed single-zone storage). Use multi-zone storage for production data to protect against zone-level failures, ensure uninterrupted read/write services, and prevent data loss. | 2025-03-24 | China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China East 2 Finance, China (Hong Kong), Singapore, and Indonesia (Jakarta) | |
Clustering optimization recommendations are now available | Clustering optimization analyzes recent read/write patterns of your tables and suggests clustering configurations to improve job performance and reduce CU consumption. Review estimated benefits, decide whether to apply, and track daily gains afterward. | 2025-03-17 | China (Hangzhou), China (Shanghai), China (Beijing), China (Zhangjiakou), China (Shenzhen), and China (Chengdu) |
February
Feature | Description | Release date | Regions | References |
Automatic materialized view (AutoMV) is now available | Automatically creates materialized views based on query patterns to improve computing efficiency and reduce redundant calculations. Ideal when multiple users unknowingly run similar, repetitive queries on MaxCompute tables. | 2025-02-20 | Public cloud regions in the Chinese mainland | |
Public beta for MaxCompute Query Accelerator (MaxQA) 2.0 | Built on a dedicated resource pool, MaxQA 2.0 optimizes the control plane, caching, and SQL engine to reduce query response time. Suitable for low-latency scenarios such as BI, interactive analytics, and near real-time data warehousing. | 2025-02-17 | All regions | |
MaxCompute SQL engine enhancements | SQL V50 is now available and includes the following updates:
| 2025-02-10 | All regions | |
Enhanced capabilities for near real-time scenarios | Adds Change Data Capture (CDC) for Delta Tables, new Stream object capabilities, periodic scheduling for MaxCompute tasks, and Flink-to-Delta-Table write support for incremental computing scenarios. | 2025-02-10 | All regions | |
Dynamic data masking is now available | Provides dynamic data masking with multiple policies (masking, hashing, character replacement, rounding for numbers and dates) to protect sensitive data such as PII in development, testing, data sharing, and O&M scenarios. | 2025-02-10 | China (Hangzhou), China (Shanghai), China (Beijing), China (Zhangjiakou), China (Ulanqab), China (Shenzhen), China (Chengdu), China (Hong Kong), Japan (Tokyo), Malaysia (Kuala Lumpur), Indonesia (Jakarta), and Germany (Frankfurt) | |
Row-level access control enhancements | This update enhances row-level access control to support more scenarios, such as Result Cache, materialized views, and Local Mode. You can also combine it with other optimization features to improve usability and performance. | 2025-02-10 | All regions | |
Lakehouse and external table enhancements |
| 2025-02-10 | All regions | |
Object Table is now available | The data warehouse SQL engine can now access metadata of unstructured data in data lake storage and process this data by using custom functions. | 2025-02-10 | All regions |
January
Feature | Description | Release date | Regions | References |
The overview page is now available in the console | The overview page is now available in the MaxCompute console. It provides a quick start guide, a list of resource instances, your favorite projects and quotas, alerts and risk warnings, and product updates to streamline your O&M tasks. | 2025-01-20 | All regions |
2024
November
Feature | Description | Release date | Regions | References |
LogView 2.0 support for MaxFrame | LogView 2.0 shows the execution records, runtimes, and other information for all DAGs submitted in MaxFrame sessions. | 2024-11-29 | China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Chengdu), China (Ulanqab), and China (Hong Kong) | |
Lakehouse enhancements | You can now write to Parquet external tables using ZSTD compression and use a RAM role for STS authentication when accessing OSS external tables. | 2024-11-26 | All regions | |
MaxCompute SQL engine enhancements (V49) | SQL V49 adds support for bitmap and bloom filter indexes, the | 2024-11-26 | All regions | |
Enhancements to materialized view recommendations and management | This update introduces metrics for estimated impact and actual benefits, helping you evaluate recommendations and manage existing materialized views. | 2024-11-26 | All regions | |
Intelligent job diagnostics now available | This feature diagnoses SQL jobs by using detailed execution information to help you quickly identify issues such as job errors or unexpected runtimes and get analysis and troubleshooting suggestions. | 2024-11-18 | All regions | |
Automated packaging service for MaxFrame | MaxFrame lets you declare external dependencies during job development, which simplifies managing third-party packages in Python. | 2024-11-01 | China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Chengdu), China (Ulanqab), and China (Hong Kong) |
October
Feature | Description | Release date | Regions | References |
Support for multiple subscription level-1 quotas in a single region | MaxCompute now allows an Alibaba Cloud account to purchase multiple subscription compute resources in the same region, which creates multiple, isolated level-1 quotas. | 2024-10-14 | All regions |
September
Feature | Description | Release date | Regions | References |
Storage cost optimization | The storage cost optimization feature recommends tiered storage configuration changes. Based on last access time, it suggests moving data inactive for 30 days to infrequent access (IA) storage and data inactive for 180 days to long-term storage, with estimated cost savings at the list price. | 2024-09-27 | China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Chengdu), China (Zhangjiakou), and China (Ulanqab) | |
Upgraded UI for subscription compute quota management | The UI for managing subscription compute quotas in the MaxCompute console has been upgraded. The management process is now split into two tabs:
| 2024-09-11 | All regions |
August
Feature | Description | Release date | Regions | References |
Storage resource observation now available | You can now view total storage usage and its breakdown by type in a selected region, monitor usage trends, and drill into specific tables or partitions. This helps identify sudden storage increases and optimize high-consumption projects. | 2024-08-16 | China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Chengdu), China (Zhangjiakou), and China (Ulanqab) | |
Enhancements to job performance observation | Adds a trend chart for data scanned per CU-hour and top-job lists by resource consumption and runtime. Use these metrics to identify resource-intensive or long-running jobs, pinpoint performance degradation periods, and diagnose root causes. | 2024-08-13 | All regions |
July
Feature | Description | Release date | Regions | References |
Job performance observation | Use job performance observation metrics to identify issues like abnormal spikes in job counts or resource usage. Comparing job execution durations over time helps you determine if slow-running jobs are degrading performance. | 2024-07-31 | All regions | |
The job O&M list and job analysis overview page now include start time, wait time, and execution duration parameters | These parameters help you quickly determine if long wait times for resources are slowing down your jobs. You can then use job analysis to identify the root cause, such as insufficient resource supply or resource contention among multiple jobs. You can then optimize job execution, adjust job priorities, or manage compute resources to meet your business needs. | 2024-07-04 | All regions | |
Computing cost optimization is now available in four additional regions | Generates optimal configuration plans for subscription level-1 quotas based on actual job volume and resource requirements. Also previews the impact of switching projects from pay-as-you-go to subscription compute resources to reduce costs and improve utilization. | 2024-07-01 | China (Hong Kong), Singapore, Indonesia (Jakarta), and Germany (Frankfurt) |
June
Feature | Description | Release date | Region | Reference |
Row-level access control | Row-level access control lets you define matching rules on a table so users and roles can view only the data they are permitted to access. | 2024-06-28 | All regions |
May
Feature | Description | Release date | Regions | References |
Custom image management is now available | Custom image management lets you use Docker images to build complete development environments for MaxCompute SQL and Python (PyODPS or MaxFrame), handling complex business logic, third-party dependencies, and sophisticated resource referencing. | 2024-05-16 | All regions | |
Job performance observation is now available | Use metrics such as job count, CU usage, and job runtime to monitor computing jobs for abnormal spikes in job numbers or resource consumption and to verify that performance meets expectations. | 2024-05-08 | All regions |
April
Feature | Description | Release date | Region | Reference |
Filter clause for window functions | Window functions now support a filter clause to filter out rows unnecessary for window calculations. | 2024-04-10 | All regions | |
Support for binary constants | MaxCompute now supports binary constants, which simplifies working with the BINARY data type. You can use the | 2024-04-10 | All regions | |
New built-in function: FROM_CHARSET | MaxCompute | 2024-04-10 | All regions | |
New data type: TIMESTAMP_NTZ | The new | 2024-04-10 | All regions |
March
Feature | Description | Release date | Regions | References |
Image management now available | Image management provides built-in, pre-warmed images for data analysis, scientific computing, and machine learning (Pandas, Numpy, Scikit-learn, Xgboost). Reference these images directly for SQL UDF and PyODPS development without manual packaging. | 2024-03-27 | All regions | |
MaxFrame, a distributed computing framework for MaxCompute, now available | MaxFrame is a distributed computing framework from Alibaba Cloud for MaxCompute with a Pandas-compatible Python API that automatically distributes computation. Together with MaxCompute Notebook and image management, it provides a complete Python development ecosystem. | 2024-03-27 | All regions | |
MaxCompute now available in China (Ulanqab) | MaxCompute, an enterprise-level, serverless, and intelligent data warehouse service, is now available in the China (Ulanqab) region. You can activate the service on demand in the console. | 2024-03-26 | China (Ulanqab) | - |
ECS Resource Reuse Edition now available | Convert idle ECS capacity reservations into MaxCompute compute resources for a specified period. MaxCompute uses a service account to acquire the reserved instances and deploy its service, making them ready-to-use compute resources. | 2024-03-21 | All regions | |
Store ActionTrail events in MaxCompute | To analyze operational events older than 90 days, you can create a trail in ActionTrail to deliver the events to MaxCompute for querying and analysis. | 2024-03-14 | All regions | |
SQL Analysis now available in the console | SQL Analysis lets you edit and run SQL commands with basic charting in the MaxCompute console. View metadata for tables, resources, and UDFs across all projects (including tenant-level Information Schema), and test with public datasets. | 2024-03-14 | All regions |
February
Feature | Description | Release date | Regions | References |
Cross-region disaster recovery (Invited Preview) | Cross-region disaster recovery backs up project data and metadata to a remote location (guaranteed >100 km from source). If a region-level failure occurs, you can switch to the backup cluster and resume operations. | 2024-02-29 | All regions |
January
Feature | Description | Release date | Regions | References |
Computing cost optimization | The computing cost optimization feature recommends resource configurations and previews the effect of switching pay-as-you-go projects to a subscription, helping you reduce computing costs and improve resource utilization. | 2024-01-25 | All regions | |
Customizable metric aggregation in resource observation | Resource observation displays a maximum of 60 data points and defaults to average aggregation when the time range exceeds one hour. You can now set the aggregation to 'maximum' for more comprehensive resource consumption analysis. | 2024-01-02 | All regions |
2023
December
Feature | Description | Release date | Regions | References |
Pay-as-you-go Spot Edition: Launched in new regions | MaxCompute now offers the Pay-as-you-go Spot Edition, a cost-effective compute resource for latency-insensitive scenarios. | 2023-12-28 | China (Hong Kong), Singapore, UK (London), Japan (Tokyo), Malaysia (Kuala Lumpur), Germany (Frankfurt), Indonesia (Jakarta), US (Virginia), and US (Silicon Valley) | |
MaxCompute Migration Assistant (MMA) now available in the console | The MaxCompute Migration Assistant (MMA) lets you visually configure migration tasks and migrate entire Hive databases or specific tables directly in the console. | 2023-12-26 | All regions | |
Manage public IP addresses in the console | The MaxCompute console now allows you to add or remove public IP addresses for a project. | 2023-12-20 | All regions |
November
Feature | Description | Release date | Regions | References |
Configure dirty data handling for Tablestore external tables | You can now configure dirty data handling when reading from a Tablestore external table. | 2023-11-22 | All regions | |
Paimon external table support | MaxCompute now supports Paimon external tables. | 2023-11-22 | All regions | |
Column-level encryption support | Column-level encryption now supports keysets, key rotation, and data encryption and decryption with Key Management Service (KMS) keys. | 2023-11-22 | All regions | |
Manage the Super Administrator role by using RAM permissions | A RAM user with the | 2023-11-21 | All regions |
September
Feature | Description | Release date | Regions | References |
SQL runtime execution mode for MapReduce | MaxCompute now supports running MapReduce jobs in SQL runtime execution mode. | 2023-09-25 | All regions | |
Job analytics | MaxCompute introduces job analytics to help developers identify and troubleshoot job resource issues. | 2023-09-21 | All regions |
August
Feature | Description | Release date | Regions | References |
Cost analysis now available in the console | The cost analysis feature in the MaxCompute console helps administrators quickly analyze and audit pay-as-you-go costs. | 2023-08-18 | All regions | |
Tenant-level Information Schema | The Tenant-level Information Schema provides metadata, such as project information and usage history. You can retrieve all metadata for a specific object type within a tenant in a single operation. | 2023-08-08 | All regions | |
Pay-as-you-go Spot Edition now available | Pay-as-you-go Spot Edition reduces computing costs for latency-insensitive scenarios, such as development and testing. | 2023-08-01 | China (Hangzhou), China (Shanghai), China (Beijing), China (Zhangjiakou), China (Shenzhen), and China (Chengdu) |
June
Feature | Description | Release date | Regions | References |
Support for the JSON data type | MaxCompute supports the JSON data type and automatically optimizes its storage on write, improving computing and analysis performance. | 2023-06-27 | All regions | |
Enhanced Z-ordering for data writing | MaxCompute enhances Z-ordering to support global sorting during data writing, reducing the amount of data scanned and improving computing performance. | 2023-06-27 | All regions | |
Support for clearing column data | You can clear data from specific columns in a table or partition to save storage space. | 2023-06-27 | All regions | |
New table type: Transaction Table 2.0 | Transaction Table 2.0 enables minute-level data ingestion, incremental queries, and queries on historical data versions. | 2023-06-27 | All regions | |
Eight new built-in functions for complex types | MaxCompute adds eight new built-in functions for complex types to simplify array operations and improve development efficiency. | 2023-06-27 | All regions | |
Compute resource optimization recommendations | MaxCompute provides recommendations for optimal compute resource configurations to reduce costs. | 2023-06-08 | All regions |
May
Feature | Description | Release date | Regions | References |
Manage scheduling policies for subscription level-2 quotas | MaxCompute now lets you view and set scheduling policies for subscription level-2 quotas to ensure rational resource allocation. | 2023-05-24 | All regions | |
Write data to Tablestore external tables using the | MaxCompute now supports writing data to Tablestore external tables using the | 2023-05-06 | All regions | |
Write data with a header to CSV files in OSS | MaxCompute now lets you specify the first row as the header when you write data to a CSV file in OSS. | 2023-05-06 | All regions | |
New built-in functions | MaxCompute adds four mathematical functions, three date and time functions, and one string function to simplify your SQL code. | 2023-05-06 | All regions | |
Scheduled data refresh for materialized views | You can schedule data refreshes for materialized views using various methods, ensuring the views contain the latest data. | 2023-05-06 | All regions | |
Built-in encryption and decryption functions | MaxCompute SQL provides built-in functions to manually encrypt or decrypt data in table columns. | 2023-05-06 | All regions | |
Filter the results of window functions using | MaxCompute now supports the | 2023-05-06 | All regions | |
Sample table data using | MaxCompute now supports the | 2023-05-06 | All regions |
April
Feature | Description | Release date | Regions | References |
Support for schema evolution | You can now modify a table schema by adding columns of complex types, deleting columns, changing column order, and changing column data types. | 2023-04-25 | All regions | |
Query acceleration with materialized views | MaxCompute now automatically recommends SQL scripts for creating materialized views. These recommendations help you quickly create materialized views, reduce redundant computations, and save compute resources. | 2023-04-23 | All regions | |
Special offer for new users | MaxCompute provides a special offer for new users in the Alibaba Cloud Free Trial Center. The offer includes free compute and storage quotas so that new users can experience the core features of MaxCompute. | 2023-04-11 | All regions | |
New Job O&M page | On the new Job O&M page, you can view all MaxCompute jobs, including their snapshots and current status. | 2023-04-06 | All regions |
March
Feature | Description | Release date | Regions | References |
Process unstructured data in external volumes using Spark and MapReduce tasks | You can use Spark and MapReduce jobs in MaxCompute to process unstructured data in OSS-based external volumes. | 2023-03-30 | All regions | |
Proxima CE is available | Proxima CE is a large-scale, offline vector retrieval engine that supports batch tasks, including basic vector retrieval, multi-category retrieval, and top-K retrieval from millions of vectors. | 2023-03-30 | All regions | |
Store unstructured data using external volumes | An external volume is a management object in the MaxCompute data warehouse that maps to an OSS path to provide a storage solution for large-scale unstructured data. | 2023-03-30 | All regions |
February
Feature | Description | Release date | Region | References |
Enhanced | The | 2023-02-25 | All regions | |
Support for cost allocation by tag | You can now add tags to each project and level-1 quota to enable cost allocation by tag. | 2023-02-01 | All regions |
January
Feature | Description | Release date | Region | Related documentation |
Direct storage read for Hologres external tables | MaxCompute now supports direct storage reads for Hologres external tables, reducing Hologres connections and improving read performance. | 2023-01-21 | All regions | |
New usage rules for quotas | You can now configure rules for a MaxCompute quota. Jobs that meet these rules are routed to the corresponding quota, providing more flexible control over quota usage. | 2023-01-12 | All regions |
2022
December
Feature | Description | Release date | Region | Reference |
Support for the | The | 2022-12-14 | All regions | |
Support for the | Use the | 2022-12-14 | All regions | |
Enhancements to built-in functions |
| 2022-12-14 | All regions |
November
Feature | Description | Release date | Regions | References |
Support for custom administrative roles | In addition to the built-in | 2022-11-15 | All regions | |
Elastic Reserved CU is now available | Elastic Reserved CU lets you scale your subscription CUs elastically. While subscription CUs require a minimum monthly commitment, Elastic Reserved CUs can be purchased for specific time slots within a day. You can use the new MaxCompute console to configure quota and time plans to improve reserved capacity coverage at a lower cost. | 2022-11-15 | All regions | |
The new console is now available | The new MaxCompute console features a redesigned user interface for project and quota management. It also integrates new features like Elastic Reserved CU and custom administrative roles. Key features include:
| 2022-11-15 | All regions | |
Compute Savings Plan and Storage Savings Plan are now available | Compute Savings Plan offsets usage charges for pay-as-you-go SQL, MapReduce, Spark, Mars, and queries on OSS and Tablestore external tables. Storage Savings Plan offsets usage charges for standard and backup storage. When you purchase a savings plan, the plan automatically offsets eligible pay-as-you-go usage. Larger plans and longer commitments provide greater discounts. | 2022-11-01 | All regions |
October
Feature | Description | Release date | Regions | References |
Adds support for upgrading the data structure from | MaxCompute now supports schemas to better organize objects like tables, resources, and functions within a project. This upgrades the data model from a two-level to a three-level structure. If your source data already uses a three-level hierarchy like | October 13, 2022 | All regions |
September
Feature | Description | Release date | Region | References |
Support for dual-signature authentication for Hologres external tables | The dual-signature mode is an authentication and authorization protocol co-developed by MaxCompute and Hologres. MaxCompute signs authentication data with your logon information and passes it to Hologres for authentication. If you use the same account for both services, you can access Hologres external tables without additional authentication. | 2022-09-24 | All regions | |
Create tables with the same structure as tables in an external data source by using the | As a MaxCompute lakehouse feature, you can use the | 2022-09-23 | All regions |
August
Feature | Description | Release date | Region | Reference |
Support for accessing OSS external tables | Spark on MaxCompute now supports accessing OSS external tables. Supported underlying file formats include PARQUET, TEXTFILE, ORC, AVRO, and SEQUENCEFILE. | 2022-08-31 | All regions | |
Automatic deletion of expired partitioned tables | You can configure MaxCompute to automatically delete a partitioned table once data from all of its partitions has been reclaimed according to its lifecycle policy. | 2022-08-27 | All regions | |
Three new aggregate functions | Three new aggregate functions are introduced: | 2022-08-27 | All regions | |
Create an internal table by copying the schema of an external table | You can use the | 2022-08-27 | All regions | |
New function to check the status of a materialized view | You can use a new function to check if the data in a materialized view or one of its partitions is consistent with the source table. It returns True for consistent data and False otherwise. | 2022-08-27 | All regions | |
Support for generating empty partitions in materialized views | When you refresh a partitioned materialized view, MaxCompute generates an empty partition if the refresh operation finds no data for that partition. This ensures partition continuity. | 2022-08-27 | All regions | |
The "Use Quota" feature for job-level assignment of computing resources | The "Use Quota" feature lets you assign a quota to a specific job, providing more flexible resource management. For example, you can use this feature to isolate computing resources for jobs with different timeliness requirements, such as low-priority backfills or high-priority algorithm jobs. This prevents them from impacting the project's overall performance and avoids the overhead of creating a new project and migrating jobs. | 2022-08-23 | All regions |
July
Feature | Description | Release date | Regions | References |
New regular expression function | MaxCompute adds the new regular expression function | 2022-07-14 | All regions | |
Customizable file name prefixes and suffixes for UNLOAD | The | 2022-07-14 | All regions | |
Set the | You can now set the | 2022-07-14 | All regions | |
New window functions and performance optimizations | MaxCompute now supports three new window functions: | 2022-07-14 | All regions | |
Six new aggregate functions | This release adds six new aggregate functions: | 2022-07-14 | All regions |
June
Feature | Description | Release date | Regions | References |
View metadata of external data sources in DataWorks | You can view metadata from external data sources in the public tables of DataWorks. This simplifies how developers using the lakehouse solution view table, column, and partition information. | 2022-06-28 | All regions | |
Query Acceleration (MCQA) supports subscriptions | You can configure interactive resources for query acceleration within your subscription. Query Acceleration (MCQA) delivers query results in seconds with elastic concurrency for petabyte-scale data warehouses. It complements MaxCompute's throughput-optimized processing by adding support for latency-sensitive scenarios, such as ETL, machine learning, ad-hoc queries, and report analysis. By automatically identifying and accelerating short queries, MCQA enhances overall SQL processing performance. | 2022-06-23 | All regions | Use Query Acceleration in subscription mode (invitation only) |
May
Feature | Description | Release date | Regions | References |
Independent billing for external table computations | MaxCompute now bills for computations on external tables separately by type. You can see the costs for OSS external tables and Tablestore external tables on your bill, making it easier to track costs from federated computations across different data sources. | 2022-05-17 | All regions |
March
Feature | Description | Release date | Regions | References |
DISTRIBUTED MAPJOIN support | In specific scenarios, you can use a | 2022-03-17 | All regions | |
Enhancements to OSS external tables | When you write data to an OSS external table, MaxCompute can automatically create a managed directory. You can also specify the cache capacity for reading files when you create an OSS external table. | 2022-03-17 | All regions | |
New parsing method for JSON data | You can now parse JSON keys that contain a period ( | 2022-03-17 | All regions | |
Enhancements to TRIM, LTRIM, and RTRIM functions | The | 2022-03-17 | All regions | |
Enhancements to automatic query rewrite for materialized views | Automatic query rewrite for materialized views now supports | 2022-03-17 | All regions | |
Skip headers and footers in compressed TEXTFILE files | You can now use the | 2022-03-01 | All regions | |
Compatibility with Apache Spark 3.1 | MaxCompute now supports Apache Spark 3.1, in addition to versions 1.6, 2.3, and 2.4. | 2022-03-01 | All regions |
February
Feature | Description | Release date | Regions | References |
Data security enhancements in MaxCompute Logview | You can now control the visibility of job execution results in Logview to enhance data security. | 2022-02-25 | All regions | |
Schema evolution in MaxCompute | Schema evolution now supports adding columns of complex data types, deleting columns, and reordering columns. | 2022-02-23 | All regions |
January
Feature | Description | Release date | Region | Reference |
View MaxCompute external project metadata in DataWorks Data Map | You can view metadata from MaxCompute external projects in DataWorks Data Map. | 2022-01-10 | China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Zhangjiakou), and Singapore |
2021
December
Feature | Description | Release date | Regions | References |
Wizard-driven setup for MaxCompute connections to Hadoop Hive in a VPC, Data Lake Formation (DLF), and Object Storage Service (OSS) | MaxCompute now provides a wizard-driven process to create a network connection to a VPC, a data source connection, and an external project for your lakehouse. This process replaces the previous ticket-based method, reducing setup time from days to minutes. Additionally, a new lakehouse page centralizes lakehouse creation, development, management, and governance. | 2021-12-30 | All regions | |
Progressive computing in MaxCompute | MaxCompute now supports progressive computing. This feature automatically saves intermediate results into time-based partitions at a specified time granularity. Subsequent job runs can reuse previously computed results from overlapping time periods. This conserves compute resources, shortens job scheduling time, lowers costs, and improves overall job efficiency. | 2021-12-03 | All regions | |
Materialized view enhancements in MaxCompute | You can now create partitions and clusters on materialized views. If a query requests data from a partition unavailable in the materialized view, you can configure the system to automatically fall back to the source table. The system then returns a combined result from the materialized view and the source table. | 2021-12-01 | All regions |
November
Feature | Description | Release date | Regions | References |
Manage VPC connections in the console | MaxCompute can access services in a VPC using features such as external tables, user-defined functions (UDFs), and lakehouse. To access these services, you must establish a network connection between MaxCompute and the target service, such as an ApsaraDB for HBase, ApsaraDB RDS, or a Hadoop cluster. Previously, setting up a VPC connection required submitting a form and waiting for approval. Now, you can add or delete network connections on the Network Resources page in the MaxCompute console. This self-service process improves development efficiency. Before you begin, ensure your account has the required permissions to manage Network Resources. | 2021-11-29 |
| |
Clear data from specified partitions in a partitioned table | You can now manually clear data from specific partitions in a partitioned table without deleting the table or its partition metadata. You can also use filter conditions to select the partitions to clear. | 2021-11-23 | All regions | |
MaxCompute integration with NetEase YouShu BI (GA) | MaxCompute now seamlessly integrates with the NetEase YouShu BI tool, enabling BI analysis in direct connection scenarios. You can also visually configure the data cache duration to improve query performance, reduce latency, and enhance the user experience. | 2021-11-18 | All regions |
October
Feature | Description | Release date | Region | References |
Support for ApsaraDB for HBase Performance-enhanced Edition and Lindorm via MaxCompute external tables | You can now create external tables in MaxCompute to read from and write to ApsaraDB for HBase Performance-enhanced Edition and Lindorm. This feature lets you perform data processing, analysis, and federated queries across these services. ApsaraDB for HBase Performance-enhanced Edition is a cloud-hosted database that is fully compatible with HBase and powered by the wide table engine of Lindorm. Lindorm is a cloud-native, multi-model database designed for scenarios such as IoT, the internet, and the Internet of Vehicles (IoV). It unifies access to and processing of various data types, including wide tables, time series, text, objects, streams, and spatial data. | 2021-10-29 | All regions | |
MaxCompute integration with GuanData BI tool (GA) | MaxCompute provides seamless integration with the GuanData BI tool. This integration accelerates queries for BI analytics when GuanData connects directly to MaxCompute, and enables full-table reads from MaxCompute in data extraction scenarios. | 2021-10-11 | All regions |
September
Feature | Description | Release date | Region | Related documents |
MaxCompute launches in the China (Shenzhen) Finance region | MaxCompute is now available in the China (Shenzhen) Finance region. | 2021-09-14 | China (Shenzhen) Finance | None |
Access Kerberos-enabled Hadoop clusters | Most enterprise production Hadoop clusters use Kerberos for authentication and authorization. MaxCompute can now access these clusters, which significantly expands its lakehouse integration with Hadoop. | 2021-09-01 |
| None |
Read Hudi and Delta Lake data from OSS with the lakehouse solution | Delta Lake and Hudi are storage mechanisms commonly used in data lake solutions for both stream and batch processing. MaxCompute provides a lakehouse architecture built on Alibaba Cloud DLF and OSS that supports these storage mechanisms. You can use MaxCompute to query real-time data for immediate insights into business data changes. | 2021-09-01 |
| Support for the Delta Lake and Hudi storage mechanisms based on DLF, RDS, or Flink, and OSS |
August
Feature | Description | Release date | Region | References |
MaxCompute SQL adds 16 new built-in functions | The new built-in functions in MaxCompute SQL include:
| 2021-08-31 | All regions | |
UPDATE, DELETE, and MERGE INTO in MaxCompute SQL are now generally available | The public preview for the UPDATE, DELETE, and MERGE INTO statements in MaxCompute SQL ended on August 10, 2021. These features are now generally available and subject to billing. Pay-as-you-go jobs that use these statements will now incur computing charges. If you previously hesitated to use these features due to stability concerns during the public preview, you can now use them with confidence. These features now have the same availability and stability guarantees as other MaxCompute SQL capabilities. | 2021-08-10 |
| |
MaxCompute Streaming Tunnel is now generally available | MaxCompute Streaming Tunnel provides streaming semantic APIs to simplify the development of distributed services. It supports concurrent partition creation and asynchronous data sorting using | 2021-08-09 | All regions | |
MaxCompute SQL supports materialized views | MaxCompute SQL introduces materialized views. A materialized view is a database object that stores the precomputed results of a query. MaxCompute accelerates subsequent queries by reusing results from time-consuming operations, such as joins and aggregations. Materialized views are ideal for the following scenarios:
After you create a materialized view, MaxCompute automatically rewrites incoming queries to use the optimal materialized view. It then reads data directly from the view, significantly improving query efficiency without requiring you to modify your existing queries. | 2021-08-06 | All regions |
July
Feature | Description | Release date | Regions | References |
Support for pre-sorted input to aggregate functions in MaxCompute SQL | For the | 2021-07-30 | All regions | |
Support for multi-column operations in SQL subqueries | MaxCompute SQL is now compatible with PostgreSQL subquery syntax, enabling multi-column operations in
| 2021-07-29 | All regions | |
Enhanced project deletion options | You can delete a MaxCompute project in the MaxCompute console using an Alibaba Cloud account or a RAM user with the Super_Administrator role for the project. Two deletion methods are available:
| 2021-07-29 |
|
April
Feature | Description | Release date | Region | References |
Dynamic filtering optimization | In distributed systems, joining large datasets is time-consuming and resource-intensive. To improve performance, MaxCompute introduces dynamic filtering, an optimization that generates runtime filters from a join's equi-join conditions. These filters accelerate queries by pruning data before the shuffle and join phases. This optimization is particularly effective for queries that join a dimension table with a fact table. You can enable dynamic filtering at the session level with a switch, trigger it manually with hints, or allow MaxCompute to apply it automatically. To further improve performance, use this feature with dynamic partition pruning. | 2021-04-07 |
|
March
Feature | Description | Release date | Region | Documentation |
Timeout monitoring and alerts for all jobs or all SQL jobs in a MaxCompute project | MaxCompute lets you use CloudMonitor to configure threshold-based alert rules to monitor job runtimes. When a job times out, the system sends an alert to the specified contacts. This helps you promptly identify abnormal jobs and improve O&M efficiency. | 2021-03-16 |
| |
MaxCompute external tables support SNAPPY and LZO compression formats | If your data is in TEXTFILE format, such as JSON, and stored in OSS, you can now use MaxCompute external tables to read and write SNAPPY and LZO compressed files. | 2021-03-16 | all regions | |
MaxCompute SQL supports | The | 2021-03-16 | all regions | |
MaxCompute SQL supports |
When your operation on a target table includes | 2021-03-16 | all regions |
February
Feature | Description | Release date | Region | References |
The MaxCompute lakehouse solution is now generally available | The MaxCompute lakehouse solution integrates a MaxCompute data warehouse with a data lake, such as OSS or Hadoop HDFS. You can build a lakehouse in two ways:
| 2021-02-26 |
| |
Support for ApsaraDB for HBase external tables (public preview) | MaxCompute can now connect to ApsaraDB for HBase over a VPC. After you establish the network connection and grant permissions, you can create ApsaraDB for HBase external tables to read from and write to tables in an ApsaraDB for HBase database by using the HBaseStorageHandler interface provided by Hive. This allows you to synchronize data from ApsaraDB for HBase to MaxCompute for extract, transform, and load (ETL) operations, perform federated computing, or export data from MaxCompute back to ApsaraDB for HBase. This public preview feature is available free of charge and without a Service Level Agreement (SLA). | 2021-02-08 |
| ApsaraDB for HBase external tables (Standard Edition or Performance-enhanced Edition) |
Disable header display in the MaxCompute command-line tool | When using a shell script to retrieve dynamic values from | 2021-02-08 | All regions | |
Enhanced data writing to OSS external tables | MaxCompute now uses the OSS multipart upload feature to more efficiently write data to OSS external tables during INSERT operations. Additionally, data that MaxCompute writes to an OSS external table is stored in a | 2021-02-08 | All regions | |
Support for custom SerDes in Hive-compatible external tables | MaxCompute is compatible with the Hive SerDe interface and provides built-in SerDe classes for common open source data formats. For special data formats, you can now specify a custom | 2021-02-08 | All regions | |
New and enhanced built-in functions | The following functions are added or enhanced:
| 2021-02-08 | All regions | |
New optimizer metadata collection tools: Freeride and Analyze | MaxCompute now provides two ways to collect table statistics for the optimizer:
| 2021-02-08 | All regions | |
Support for ApsaraDB RDS external tables (public preview) | MaxCompute can now connect to your ApsaraDB RDS instance over a VPC. After you establish the network connection and grant permissions, you can create ApsaraDB RDS external tables to read and write data. This allows you to synchronize data, such as dimension or business data, from ApsaraDB RDS to MaxCompute for ETL, perform federated computing, or export data from MaxCompute back to your ApsaraDB RDS database. This public preview feature is available free of charge and without an SLA. | 2021-02-08 | All regions | |
Read from and write to Hologres external tables by using JDBC (public preview) | MaxCompute external tables can now access Hologres data sources using a JDBC driver. You can create a Hologres external table in MaxCompute and use the PostgreSQL JDBC driver to query data in your Hologres instance. This method eliminates redundant storage and data import/export steps, accelerating query performance. This public preview feature is available free of charge and without an SLA. | 2021-02-08 | All regions | |
Export data to OSS by using the UNLOAD command | MaxCompute now supports the UNLOAD command to export data to OSS. This allows you to store structured data in OSS and use other computing engines to process and analyze the data. | 2021-02-08 | All regions | |
MaxCompute SQLML is now generally available | MaxCompute SQLML allows data engineers, analysts, and data scientists to use SQL to create, train, and apply machine learning models directly in MaxCompute. This enables SQL practitioners to leverage machine learning capabilities with their existing tools and skills, without migrating data. | 2021-02-01 | All regions |
January
Feature | Description | Release date | Region | References |
MaxCompute storage pricing adjustment | Effective January 10, 2021, the MaxCompute storage service switched from tiered pricing to a fixed rate. This change reduces storage costs for customers with small to medium-sized datasets. The previous tiered rates were CNY 0.0072/GB/day for up to 10 TB, CNY 0.006/GB/day for 10–100 TB, and CNY 0.004/GB/day for over 100 TB. The new fixed rate is CNY 0.12 per GB per month (equivalent to CNY 0.004 per GB per day). | 2021-01-10 | all regions |
2020
December
Feature | Description | Release date | Region | References |
Streaming Tunnel is now in public preview | MaxCompute Streaming Tunnel provides a high-QPS API for streaming data into MaxCompute. | 2020-12-28 | All regions | |
Information Schema is now enabled by default for new projects | Information Schema is now enabled by default in all new projects, eliminating the need for manual setup and allowing you to easily view metadata. | 2020-12-21 | All regions | |
Information_Schema.Tasks view for running job snapshots is now in private preview | The Information_Schema.Tasks view details currently running jobs, including the job list, CPU and memory usage, resource consumption ratio, and runtime. This view helps you quickly identify long-running or resource-intensive jobs for targeted optimization or resource capacity planning. | 2020-12-08 | None. | |
Daily spending limits are now available for pay-as-you-go SQL jobs | MaxCompute now supports daily spending limits for pay-as-you-go SQL jobs at the project level. If the sum of the daily cumulative cost of standard SQL jobs and the estimated cost of a new job exceeds the configured limit, MaxCompute rejects the new job with an error message. This feature helps prevent budget overruns. You should carefully evaluate your daily consumption before setting a limit to avoid disrupting business workflows. If a limit proves inappropriate, a project owner or an administrator with the | 2020-12-07 | All regions | |
Query acceleration is now supported in the MaxCompute query editor | The MaxCompute query editor now supports query acceleration, which reduces the execution time for queries on small to medium-sized datasets from minutes to seconds. When you submit a query, the editor first routes it to the query acceleration service. If the query meets the acceleration criteria, the service returns results in seconds. If not, the query automatically falls back to the standard offline execution mode. The query editor provides rich web-based analysis capabilities for querying data, analyzing results, and sharing insights in one place. Query acceleration is primarily available for pay-as-you-go resources and is not yet supported for projects that use subscription resources. | 2020-12-05 | All regions |
November
Feature | Description | Release date | Region | References |
Continuously import data from Message Queue for Apache Kafka using a sink connector | MaxCompute is tightly integrated with Message Queue for Apache Kafka. The sink connector lets you continuously import data from a specified topic into a MaxCompute table without needing third-party tools or custom code. This feature simplifies the data integration pipeline and reduces development and O&M costs. | 2020-11-27 | All regions | Import data to MaxCompute with Kafka (offline and real-time) |
Access MaxCompute using a RAM role | In addition to Alibaba Cloud accounts and RAM users, MaxCompute projects now support access through RAM roles. After an administrator adds a RAM role to a project and grants permissions, users can assume the role to access MaxCompute. This method uses temporary STS credentials for secure access without a long-term AccessKey. Because the MaxCompute console supports STS authentication, you can use a RAM role for data analysis and development. | 2020-11-24 | All regions |
October
Feature | Description | Release date | Release region | References |
SEMI JOIN supports MAPJOIN Hint | SEMI JOIN supports the MAPJOIN Hint to improve performance for LEFT SEMI or ANTI JOIN operations and address data skew. | 2020-10-30 | All regions | |
MaxCompute supports SORT BY without DISTRIBUTE BY | You can now use | 2020-10-30 | All regions | |
OSS external tables for CSV/TSV files support the GBK encoding format | In addition to UTF-8, UTF-16, and US-ASCII, the | 2020-10-30 | All regions | |
Conditional filtering for batch partition drops | You can now use a conditional expression to batch-delete partitions that match a specific rule. | 2020-10-30 | All regions | |
New WIDTH_BUCKET function and DATETIME support for date and time functions | The new | 2020-10-30 | All regions | |
Support for ZORDER BY in table writes | This feature physically co-locates rows with similar data to improve query filtering performance and reduce storage costs. | 2020-10-30 | All regions | |
MaxCompute Query Acceleration (MCQA) is now generally available | MaxCompute Query Acceleration (MCQA) provides second-scale query capabilities with elastic concurrency for exabyte-scale data warehouses. It complements MaxCompute's existing throughput-optimized processing by adding support for latency-sensitive scenarios. With query acceleration, MaxCompute can serve multiple use cases within a single service, including data preparation (ETL), data mining (machine learning), data exploration (ad hoc queries), and report analysis. MCQA enhances MaxCompute SQL performance for report analysis and ad hoc query scenarios by automatically identifying and accelerating short queries. | 2020-10-12 | All regions |
September
Feature | Description | Release date | Region | Documentation |
New MaxCompute console | MaxCompute introduces a new web console. Its new user interface and features simplify service activation, project creation, compute resource management and monitoring, and SQL query analysis. This streamlined interface lets you quickly create a data warehouse environment, manage and monitor compute resources and jobs, and perform data analysis and exploration. The new console includes the following key features:
| 2020-09-29 | All regions | |
Logview 2.0 enhancements | Logview 2.0 expands the monitoring metrics for MaxCompute jobs, provides a job replay feature, and adds Fuxi Sensor to display job memory and CPU usage. | 2020-09-10 | All regions | |
General availability of backup and restore | MaxCompute's backup and restore feature automatically saves historical data versions before modification or deletion and retains them for a specified period. You can restore data from any point within this period to prevent data loss from accidental operations. | 2020-09-01 | All regions |
August
Feature | Description | Release date | Release region | Related documents |
Mars is now generally available | Mars is a unified, tensor-based distributed computing framework. It uses parallel and distributed technologies to accelerate the Python data science stack, including NumPy, Pandas, and Scikit-learn. | 2020-08-31 | All regions | |
MaxCompute Query Acceleration (MCQA) is now in public preview | MCQA accelerates and optimizes small- and medium-sized query jobs, reducing execution time from minutes to seconds. This feature is fully compatible with existing query features. | 2020-08-31 | All regions |
July
Feature | Description | Release date | Regions | Related documentation |
New projects default to data type version 2.0 | When you create a MaxCompute project in the DataWorks console, the default data type version is 2.0 instead of 1.0. | 2020-07-29 | all regions | |
Python UDFs support more data types |
| 2020-07-24 | all regions | |
New aggregate functions | MaxCompute adds the aggregate functions | 2020-07-24 | all regions | |
Embedded UDFs | Embedded UDFs let you embed Java or Python code directly into an SQL script. This method simplifies UDF development by allowing you to place the SQL script and third-party code in the same source file. | 2020-07-24 | all regions | |
SQL functions | MaxCompute supports SQL functions, which let you define and use a UDF written in SQL directly within an SQL script. | 2020-07-24 | all regions | |
Job priority for projects with subscription compute resources | You can set the job priority for projects that use subscription compute resources. This ensures that high-priority jobs receive the required compute resources. When a high-priority job starts, it can preempt the resources of lower-priority jobs. | 2020-07-24 | all regions | |
Backup and recovery | MaxCompute offers data backup and recovery. The system automatically backs up previous versions of your data and retains them for a specified period. You can quickly restore data from any point within this retention period to recover from accidental data loss. | 2020-07-01 | all regions |
June
Feature | Description | Release date | Region | References |
Data type version selection for new projects | When you create a project in MaxCompute, you must specify a data type version. | 2020-06-30 | All regions |
May
Feature | Description | Release date | Region | References |
PyODPS 3 node support | MaxCompute supports Python 3. You can create PyODPS 3 nodes in DataWorks to enhance your data processing capabilities. | 2020-05-22 | All regions | |
Log audit | MaxCompute records all user operations and pushes user activity logs to ActionTrail in real time, allowing you to view and retrieve them. You can also deliver these logs to a Log Service project or a specified OSS bucket for auditing and troubleshooting. | 2020-05-12 | All regions | |
MMA migration tool upgraded to version 2.0 | Version 2.0 of the MMA migration tool brings major enhancements to its features and architecture. It supports a C/S architecture and includes intelligent queue scheduling, automatic retry, resumable transfer, data verification, and incremental updates. Compared to version 1.0, this upgrade improves usability, stability, and migration efficiency. | 2020-05-08 | All regions |
April
Feature | Description | Release date | Region | References |
policy authorization with the | MaxCompute supports policy authorization with the | 2020-04-23 | all regions | |
cost control for individual SQL statements | MaxCompute monitors individual SQL statements and estimates their cost before execution to prevent unexpected high charges. | 2020-04-14 | all regions |
March
Feature | Description | Release date | Region | References |
New LOAD command | The LOAD command imports data from external storage, such as OSS or OTS, into a table or table partition. | 2020-03-17 | all regions | |
Five new built-in functions | MaxCompute now supports five new built-in functions: | 2020-03-17 | all regions |
February
Feature | Description | Release date | Region | References |
Disable table lifecycles | You can use the | 2020-02-26 | All regions | |
New | The | 2020-02-26 | All regions | |
Upgrading | MaxCompute extends | 2020-02-26 | All regions | |
Fetch external table data over HTTPS | If you need to retrieve data via HTTPS, you can submit the command | 2020-02-26 | All regions | |
External tables support the | MaxCompute can automatically add partitions to an external table based on the file paths of its data in OSS. | 2020-02-26 | All regions | |
Suggested corrections for column names in SQL | When you run an SQL statement, the SQL engine suggests corrections for incorrect column names. | 2020-02-26 | All regions | |
Python 3 UDFs | MaxCompute now supports Python 3 UDFs, following the deprecation of Python 2. | 2020-02-26 | All regions | |
Tunnel adds the | This parameter determines whether to overwrite a table or partition when you upload data. | 2020-02-21 | All regions |
January
Feature | Description | Release date | Region | References |
Support for DATE and CHAR data types | You can enable data type version 2.0 to use the DATE and CHAR data types when you create or read tables in MaxCompute. | 2020-01-03 | All regions | |
Specify a quota group for a job | Use the | 2020-01-03 | All regions |
2019
December
Feature | Description | Release date | Region | Related documentation |
Support for open source geospatial UDFs | You can use open source geospatial UDFs to analyze spatial data. | 2019-12-25 | All regions | |
New subscription plan for non-reserved computing resources | This subscription plan does not reserve resources. When a job starts, the system allocates idle resources from a shared pool. If the pool has sufficient resources, the system may allocate up to the maximum CUs you purchased. If the pool is busy, you may receive 0 CUs. MaxCompute guarantees 50% of the daily computing power for your purchased resources (daily computing power = number of CUs × 24 hours). | 2019-12-20 | All regions |
November
Feature | Description | Release date | Region | Related documentation |
Dynamic data masking | MaxCompute uses dynamic data masking to protect personally identifiable information (PII) in SQL query results. | 2019-11-22 | All regions | |
Support for connecting to MaxCompute with Tableau | You can use the MaxCompute JDBC driver to connect Tableau to MaxCompute and perform visual analysis on your data. | 2019-11-18 | All regions | |
New MaxCompute JDBC driver | The MaxCompute JDBC driver is a Java Database Connectivity (JDBC) interface that allows you to run distributed queries on massive data. | 2019-11-18 | All regions |
October
Feature | Description | Release date | Region | Related documentation |
Support for adding or dropping multiple partitions at once | MaxCompute now supports adding or dropping multiple partitions in a single DDL operation, which simplifies batch partition management and improves data warehousing efficiency. | 2019-10-28 | All regions | |
Support for new operators | MaxCompute now supports the | 2019-10-28 | All regions | |
Support for NATURAL JOIN | MaxCompute now supports NATURAL JOIN to expand its SQL JOIN capabilities. | 2019-10-28 | All regions | |
Support for specifying default column values | You can specify default values for columns when you create a table. | 2019-10-28 | All regions | |
Support for LIMIT OFFSET | MaxCompute now supports LIMIT OFFSET to enhance its SQL engine capabilities. | 2019-10-28 | All regions | |
Support for odps.sql.orderby.position.alias and odps.sql.groupby.position.alias | MaxCompute now supports odps.sql.orderby.position.alias and odps.sql.groupby.position.alias. These parameters allow integer constants in ORDER BY and GROUP BY clauses to be treated as column sequence numbers in the SELECT list. | 2019-10-28 | All regions | |
New built-in functions: | The | 2019-10-28 | All regions | |
Support for specifying JOIN priority with parentheses | You can use parentheses to specify the priority of JOIN operations. | 2019-10-28 | All regions | |
Support for merging partitions | If you have a large number of partitions, you can use the partition merging feature to archive data. | 2019-10-28 | All regions | |
Support for IP whitelists | MaxCompute supports IP whitelists for VPC networks. | 2019-10-28 | All regions |
September
Feature | Description | Release date | Region | Related documentation |
Support for configuring monitoring and alerts for Tunnel | You can use CloudMonitor to monitor Tunnel upload and download usage and configure alerts. | 2019-09-30 | All regions | |
Support for configuring monitoring and alerts for pay-as-you-go job spending | You can use CloudMonitor to monitor spending on pay-as-you-go jobs and configure alerts. | 2019-09-30 | All regions | |
Support for Information Schema | MaxCompute's Information Schema provides information such as project metadata and usage history data. | 2019-09-06 | All regions | |
Storage price reduction | MaxCompute reduced its storage pricing on September 1, 2019. The previous five pricing tiers were adjusted to three, and the unit price for each tier was lowered. | 2019-09-01 | All regions | None. |
July
Feature | Description | Release date | Region | Related documentation |
Support for Spark service | Spark on MaxCompute is a service compatible with open source Spark. It runs a Spark computing framework on MaxCompute's unified resource and permission system. This allows you to run Spark jobs in a familiar environment to address diverse data processing needs. | 2019-07-23 | All regions | |
New region: China (Chengdu) | MaxCompute is now available in the China (Chengdu) region. | 2019-07-04 | China (Chengdu) | None. |
June
Feature | Description | Release date | Region | Related documentation |
Support for obtaining ExecutionContext objects in UDTs | UDTs can obtain an ExecutionContext object to access information about their runtime environment. | 2019-06-25 | All regions | |
Support for function overloading in UDTs | UDTs support generics, class inheritance, and variable-length parameters to provide flexible function definitions. | 2019-06-25 | All regions | |
Support for dynamic parameters in UDAFs and UDTFs | MaxCompute now supports dynamic parameters for UDAFs and UDTFs and extends the Resolve annotation syntax, making UDF development more flexible. | 2019-06-24 | All regions | |
Support for partition pruning in UDFs | UDFs support partition pruning to reduce computing costs. | 2019-06-24 | All regions | None. |
Parameterized views | Parameterized views support passing any table or other variables to customize the view. | 2019-06-24 | All regions | |
Support for generating CREATE TABLE DDL | You can use the | 2019-06-24 | All regions | |
Support for configuring monitoring and alerts for subscription job spending | You can use CloudMonitor to monitor spending on subscription jobs and configure alerts. | 2019-06-21 | All regions |
May
Feature | Description | Release date | Region | Related documentation |
Subscription plans that include computing and storage resources | MaxCompute now offers subscription plans that include both computing and storage resources. | 2019-05-07 | All regions |