The MaxCompute SQL syntax is similar to the SQL syntax. The MaxCompute SQL syntax is a subset of the standard ANSI SQL-92 syntax and extends the standard syntax. This topic describes the scenarios of MaxCompute SQL and the tools that are supported by MaxCompute SQL. This topic also provides instructions on how to use MaxCompute SQL.
MaxCompute SQL is suitable for scenarios in which batch jobs are run to compute gigabytes, terabytes, or exabytes of data. After you submit a MaxCompute SQL job, queue scheduling may occur and lasts for tens of seconds to several minutes. In this scenario, you can submit a batch job to process large amounts of data at the same time. We recommend that you do not connect MaxCompute to a foreground business system that needs to handle thousands to tens of thousands of transactions per second.
Learn MaxCompute SQL
Describes the syntax differences between MaxCompute SQL and mainstream databases.
Describes reserved words and keywords in MaxCompute SQL statements.
Describes the data types that are supported by MaxCompute SQL, data type editions, and differences between the data type editions.
Describes the type conversions that are supported by MaxCompute SQL.
Describes the data type differences between MaxCompute SQL and mainstream databases.
Describes the characters that are supported by the LIKE operator for character matching in MaxCompute SQL.
Describes the regular expression rules that are supported by MaxCompute SQL.
Describes the relational operators, arithmetic operators, bitwise operators, and logical operators in MaxCompute.
Use MaxCompute SQL
Describes the limits of MaxCompute SQL to help you write scripts that meet specific rules.
Describes the syntax of the DDL statements that are supported by MaxCompute SQL, such as the DDL statements that are used to manage tables, lifecycles, partitions, and columns.
Describes the syntax of the DML statements that are supported by MaxCompute SQL, such as
Describes the syntax of the
Describes the syntax of the statements that can be used to improve the readability and execution efficiency of MaxCompute SQL, such as
Describes user-defined functions that are supported by MaxCompute, including user-defined scalar functions (UDFs), user-defined table-valued functions (UDTFs), and user-defined aggregate functions (UDAFs), and provides instructions on how to create these functions.
Describes 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.
Describes how to perform custom operations across tables or on multiple tables.
Describes how to compile SQL scripts in script mode.
You can develop MaxCompute SQL jobs by using related tools based on the complexity of the jobs.