๐Ÿ“˜ Alibaba : MaxCompute SQL

Play this article

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.

Did you find this article valuable?

Support Aditya Katira by becoming a sponsor. Any amount is appreciated!