This topic describes the limits on the use of MaxCompute Lightning.

Limits on DDL and DML statements

MaxCompute Lightning supports only the SELECT statement on MaxCompute tables. It does not support the UPDATE, CREATE, DELETE, or INSERT statements on MaxCompute tables. These statements will be supported in later versions.

Limits on queries

  • MaxCompute Lightning allows you to scan a maximum of 1,024 partitions from a partitioned table.
  • MaxCompute Lightning does not allow you to create or use views.
  • MaxCompute Lightning does not support the following data types: MAP, ARRAY, TINYINT, BINARY, TIMESTAMP, or DECIMAL with specified precision.
  • MaxCompute Lightning allows you to scan a maximum of 1 TB data from a table in a single query.
  • The size of a query statement that you commit cannot exceed 100 KB.
  • The lifecycle of a query is one hour.
  • The size of data scanned by a query statement cannot exceed 100 GB.
  • The total number of the JOIN and GROUP BY clauses in a query statement cannot exceed 5.
  • The number of data records in the result of a single query cannot exceed 10,000. If the number exceeds this limit, the query result is truncated.
  • MaxCompute Lightning is compatible with PostgreSQL. However, PostgreSQL does not support the DATETIME data type. If your data is of the DATETIME type, it is mapped to the TIMESTAMP type in PostgreSQL.

Limits on UDFs

  • You cannot use MaxCompute user-defined functions (UDFs) in MaxCompute Lightning.
  • You cannot create or use PostgreSQL UDFs in MaxCompute Lightning. However, you can use the built-in functions of PostgreSQL in MaxCompute Lightning.
  • You cannot use the built-in functions of MaxCompute in MaxCompute Lightning.

Limits on query concurrency

In a MaxCompute project, the number of parallel MaxCompute Lightning queries cannot exceed 20.