MaxCompute SQL shares many similarities with the standard SQL syntax, with its design falling within a subset of the standard ANSI SQL-92 syntax. It even extends the standard syntax in some aspects. Here, we'll cover the use cases, tools, and some key steps on using MaxCompute SQL.

💼 Use Cases

MaxCompute SQL excels in handling batch jobs that need to compute gigabytes, terabytes, or even exabytes of data. Queue scheduling may occur after submitting a MaxCompute SQL job, which could take anywhere from a few seconds to several minutes. It's ideal for large-scale data processing tasks, but it's not recommended to connect MaxCompute to a foreground business system that requires handling thousands to tens of thousands of transactions per second.

🛠️ How to Use MaxCompute SQL

Here's a breakdown of some important operations and references to help you get started:

Learning MaxCompute SQL

• Differences in the support for SQL statements: Provides insights into the syntax differences between MaxCompute SQL and mainstream databases.

• Reserved words and keywords: Offers information about reserved words and keywords in MaxCompute SQL statements.

• Data types: Discusses the data types supported by MaxCompute SQL, data type editions, and differences between the data type editions.

• Type conversions: Details the type conversions that are supported by MaxCompute SQL.

• Data type mappings: Explores the data type differences between MaxCompute SQL and mainstream databases.

• Escape character: Describes the escape characters in MaxCompute SQL.

• LIKE usage: Describes the characters supported by the LIKE operator for character matching in MaxCompute SQL.

• Regular expressions: Covers the regular expression rules supported by MaxCompute SQL.

• Operators: Explains the relational operators, arithmetic operators, bitwise operators, and logical operators in MaxCompute.

Using MaxCompute SQL

• Limits: Details the limitations of MaxCompute SQL to help you write scripts that meet specific rules.

• DDL statements: Covers the syntax of the DDL statements supported by MaxCompute SQL, such as the DDL statements used to manage tables, lifecycles, partitions, and columns.

• DML statements: Discusses the syntax of the DML statements supported by MaxCompute SQL, like INSERT INTO and INSERT OVERWRITE.

• DQL statements: Describes the syntax of the SELECT statements supported by MaxCompute SQL, used to query data.

• Enhanced SQL syntax: Provides the syntax of the statements that improve the readability and execution efficiency of MaxCompute SQL, such as LOAD and UNLOAD.

• MaxCompute UDF: Describes user-defined functions supported by MaxCompute, including user-defined scalar functions (UDFs), user-defined table-valued functions (UDTFs), and user-defined aggregate functions (UDAFs), with instructions on how to create these functions.

• MaxCompute UDT: Explains how to directly call the classes and methods of third-party programming languages in SQL, or how to directly use third-party objects to obtain data.

• MaxCompute UDJ: Outlines how to perform custom operations across tables or on multiple tables.

• Run MaxCompute SQL in script mode: Details how to compile SQL scripts in script mode.