Dremio Cloud
Dremio Software
 
On this page

    Reserved Keywords

    Dremio reserves ANSI keywords and additional keywords to perform SQL queries on spaces, data lakes, and relational databases. These reserved keywords are part of the grammar of the SQL language that is used by Dremio to parse and understand SQL statements.

    However, you can use these reserved keywords as an object name by enclosing a keyword in double quotes (for example, "boolean").
    ALL ALLOCATE ALLOW ALTER
    ANALYZE ANY ARE ARRAY
    ARRAY_MAX_CARDINALITY AS ASENSITIVE ASYMMETRIC
    AT ATOMIC AUTHORIZATION BEGIN
    BEGIN_FRAME BEGIN_PARTITION BETWEEN BIGINT
    BINARY BIT BLOB BOOLEAN
    BOTH BY CALL CALLED
    CARDINALITY CASCADED CASE CAST
    CEILING CHAR CHARACTER CHECK
    CLASSIFIER CLOB CLOSE COALESCE
    COLLATE COLLECT COMMIT COMPACT
    COMPUTE CONDITION CONNECT CONSTRAINT
    CONVERT CORRESPONDING CREATE CROSS
    CUBE CUME_DIST CURRENT CURRENT_CATALOG
    CURRENT_DEFAULT_TRANSFORM_GROUP CURRENT_PATH CURRENT_ROLE CURRENT_ROW
    CURRENT_TRANSFORM_GROUP_FOR_TYPE CURRENT_USER CURSOR CYCLE
    DATABASES DATE DAY DEALLOCATE
    DEC DECIMAL DECLARE DEFAULT
    DEFINE DELETE DENSE_RANK DEREF
    DESCRIBE DETERMINISTIC DISALLOW DISCONNECT
    DISTINCT DOUBLE DROP DYNAMIC
    EACH ELEMENT ELSE EMPTY
    END END-EXEC END_FRAME END_PARTITION
    EQUALS ESCAPE EXCEPT EXEC
    EXECUTE EXISTS EXPLAIN EXTEND
    EXTERNAL EXTRACT FALSE FETCH
    FILES FILTER FIRST_VALUE FLOAT
    FOR FOREIGN FRAME_ROW FREE
    FROM FULL FUNCTION FUSION
    GET GLOBAL GRANT GROUP
    GROUPING GROUPS HAVING HOLD
    HOUR IDENTITY IF IMPORT
    IN INCLUDE INDICATOR INITIAL
    INNER INOUT INSENSITIVE INSERT
    INT INTEGER INTERSECT INTERSECTION
    INTERVAL INTO IS JOIN
    LAG LANGUAGE LARGE LAST_VALUE
    LATERAL LEAD LEADING LIKE_REGEX
    LIMIT LN LOAD LOCAL
    MATCH MATCHES MATCH_NUMBER MATCH_RECOGNIZE
    MEMBER MERGE METADATA METHOD
    MINUS MINUTE MODIFIES MODULE
    MONTH MULTISET NATIONAL NATURAL
    NCHAR NCLOB NEW NEXT
    NO NONE NORMALIZE NTH_VALUE
    NTILE NULL NULLIF NUMERIC
    OCCURRENCES_REGEX OF OFFSET OLD
    OMIT ON ONE ONLY
    OPEN ORDER OUT OUTER
    OVER OVERLAPS OVERLAY PARAMETER
    PARTITION PARTITIONS PATTERN PER
    PERCENT PERCENTILE_CONT PERCENTILE_DISC PERCENT_RANK
    PERIOD PERMUTE PIVOT PORTION
    POSITION_REGEX PRECEDES PRECISION PREPARE
    PREV PRIMARY PROCEDURE RANGE
    RANK READS REAL RECURSIVE
    REF REFERENCES REFERENCING REFRESH
    REGR_AVGX REGR_AVGY REGR_COUNT REGR_INTERCEPT
    REGR_R2 REGR_SLOPE REGR_SXX REGR_SXY
    REGR_SYY RELEASE RESET RESULT
    RETURN RETURNS REVOKE ROLLBACK
    ROLLUP ROW ROWS ROW_NUMBER
    RUNNING SAVEPOINT SCHEMAS SCOPE
    SCROLL SEARCH SECOND SEEK
    SELECT SENSITIVE SET SHOW
    SKIP SMALLINT SOME SPECIFIC
    SPECIFICTYPE SQL SQLEXCEPTION SQLSTATE
    SQLWARNING START STATIC STATISTICS
    STREAM SUBMULTISET SUBSET SUBSTRING_REGEX
    SUCCEEDS SYMMETRIC SYSTEM SYSTEM_TIME
    TABLE TABLES TABLESAMPLE THEN
    TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE
    TINYINT TO TRAILING TRANSLATE
    TRANSLATE_REGEX TRANSLATION TREAT TRIGGER
    TRIM TRIM_ARRAY TRUE UESCAPE
    UNION UNIQUE UNKNOWN UNNEST
    UNPIVOT UNSET UPDATE UPSERT
    USE USING VALUE VALUES
    VALUE_OF VARBINARY VARCHAR VARYING
    VERSIONING WHEN WHENEVER WHERE
    WIDTH_BUCKET WINDOW WITH WITHIN
    WITHOUT YEAR