Reserved words and keywords in MaxCompute SQL - MaxCompute

MaxCompute SQL reserves certain words for its parser and query engine. If you use these words as table, column, or partition names, SQL execution will fail or return an error. This page lists all reserved words and keywords, and explains how to escape keywords when needed.

Notice

When you name a table, a column, or a partition, do not use reserved words or keywords. Otherwise, an error may occur.
Reserved words and keywords are not case-sensitive.
If you use keywords to name a table, a column, or a partition, you must escape the keywords by using double quotation marks ("). Otherwise, an error is returned.

Reserved words and keywords reference

The following symbols and words are reserved or have special meaning in MaxCompute SQL. Avoid using them as table, column, or partition names. If you must use a keyword as an identifier, escape it with double quotation marks.

Symbols

%    &    &&    (    )    *    +
-    .    /    ;    <    <=    <>
=    >    >=    ?

A–C

ADD    AFTER    ALL    ALTER    ANALYZE    AND    ARCHIVE    ARRAY    AS    ASC
BEFORE    BETWEEN    BIGINT    BINARY    BLOB    BOOLEAN    BOTH    DECIMAL
BUCKET    BUCKETS    BY    CASCADE    CASE    CAST    CFILE
CHANGE    CLUSTER    CLUSTERED    CLUSTERSTATUS    COLLECTION    COLUMN    COLUMNS
COMMENT    COMPUTE    CONCATENATE    CONTINUE    CREATE    CROSS    CURRENT
CURSOR

D–F

DATA    DATABASE    DATABASES    DATE    DATETIME    DBPROPERTIES
DEFERRED    DELETE    DELIMITED    DESC    DESCRIBE    DIRECTORY    DISABLE
DISTINCT    DISTRIBUTE    DIV    DOUBLE    DROP
ELSE    ENABLE    END    EXCEPT
ESCAPED    EXCLUSIVE    EXISTS    EXPLAIN    EXPORT    EXTENDED    EXTERNAL
FALSE    FETCH    FIELDS    FILEFORMAT    FIRST    FLOAT    FOLLOWING
FORMAT    FORMATTED    FROM    FULL    FUNCTION    FUNCTIONS

G–L

GRANT    GROUP    HAVING    HOLD_DDLTIME
IDXPROPERTIES    IF    IMPORT    IN    INDEX    INDEXES    INPATH
INPUTDRIVER    INPUTFORMAT    INSERT    INT    INTERSECT    INTO    IS    ITEMS
JOIN    KEYS    LATERAL    LEFT    LIFECYCLE    LIKE    LIMIT    LINES    LOAD
LOCAL    LOCATION    LOCK    LOCKS    LONG

M–O

MAP    MAPJOIN    MATERIALIZED    MINUS    MSCK
NO_DROP    NOT    NULL    OF    OFFLINE    OFFSET
ON    OPTION    OR    ORDER    OUT    OUTER    OUTPUTDRIVER    OUTPUTFORMAT
OVER    OVERWRITE

P–R

PARTITION    PARTITIONED    PARTITIONPROPERTIES    PARTITIONS
PERCENT    PLUS    PRECEDING    PRESERVE    PROCEDURE    PURGE
RANGE    RCFILE    READ    READONLY    READS    REBUILD    RECORDREADER
RECORDWRITER    REDUCE    REGEXP    RENAME    REPAIR    REPLACE    RESTRICT
REVOKE    RIGHT    RLIKE    ROW    ROWS

SCHEMA    SCHEMAS    SELECT    SEMI    SEQUENCEFILE    SERDE    SERDEPROPERTIES
SET    SHARED    SHOW    SHOW_DATABASE    SMALLINT    SORT    SORTED    SSL
STATISTICS    STATUS    STORED    STREAMTABLE    STRING    STRUCT

T–Z

TABLE    TABLES    TABLESAMPLE    TBLPROPERTIES    TEMPORARY    TERMINATED
TEXTFILE    THEN    TIMESTAMP    TINYINT    TO    TOUCH    TRANSFORM
TRIGGER    TRUE    TYPE
UNARCHIVE    UNBOUNDED    UNDO    UNION    UNIONTYPE    UNIQUEJOIN
UNLOCK    UNSIGNED    UPDATE    USE    USING    UTC    UTC_TMESTAMP
VIEW    WHEN    WHERE    WHILE