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.