MaxCompute:Basic operations

DDL operations

Delta tables support the following common DDL operations:

• Create and Drop Tables

• Partition operations

• Column operations

• CLONE TABLE

Data writes

Delta tables support full data import and near-real-time incremental data import from a wide range of data sources. MaxCompute seamlessly integrates with upstream and downstream ecosystem products, offering support for various data integration tools that have been deeply customized and optimized. For example, the Flink connector developed by MaxCompute and the Data Integration service of DataWorks enable high-concurrency, scalable, and efficient near-real-time incremental data import.

• Use SQL statements to batch write data into a Delta table

• Use SQL statements to batch update specific columns

• Use open source Flink to write data into a Delta table in near real time

• Use Alibaba Cloud Realtime Compute for Apache Flink to write data into a Delta table in near real time

• Use Flink CDC to write data into a Delta table in near real time

• Use DataWorks to synchronize data to a Delta table in real time

Data queries

• Basic queries

• Time travel queries

• Incremental queries

Data merging: COMPACTION

Local backup: Backup