This document shows all reserved words in MaxCompute SQL.

Notice
  • These cannot be used to name a table, column, or partition; otherwise an error occurs.
  • Reserved words are not case sensitive.
    % & && ( ) * +
                - . / ; < <= <>
        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 DATA DATABASE DATABASES DATE DATETIME DBPROPERTIES
    DEFERRED DELETE DELIMITED DESC DESCRIBE DIRECTORY DISABLE
    DISTINCT DISTRIBUTE DOUBLE DROP ELSE ENABLE END
    ESCAPED EXCLUSIVE EXISTS EXPLAIN EXPORT EXTENDED EXTERNAL
    FALSE FETCH FIELDS FILEFORMAT FIRST FLOAT FOLLOWING
    FORMAT FORMATTED FROM FULL FUNCTION FUNCTIONS 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 MAP MAPJOIN MATERIALIZED
    MINUS MSCK NOT NO_DROP NULL OF OFFLINE
    ON OPTION OR ORDER OUT OUTER OUTPUTDRIVER
    OUTPUTFORMAT OVER OVERWRITE 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 STORED
    STREAMTABLE STRING STRUCT TABLE TABLES TABLESAMPLE TBLPROPERTIES
    TEMPORARY TERMINATED TEXTFILE THEN TIMESTAMP TINYINT TO
    TOUCH TRANSFORM TRIGGER TRUE UNARCHIVE UNBOUNDED UNDO
    UNION UNIONTYPE UNIQUEJOIN UNLOCK UNSIGNED UPDATE USE
    USING UTC UTC_TMESTAMP VIEW WHEN WHERE WHILE DIV