Reserved Words

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").

Dremio Reserved Words

ABS	ALL	ALLOCATE	ALLOW
ALTER	AND	ANY	ARE
ARRAY	ARRAY_MAX_CARDINALITY	AS	ASENSITIVE
ASYMMETRIC	AT	ATOMIC	AUTHORIZATION
AVG	BEGIN	BEGIN_FRAME	BEGIN_PARTITION
BETWEEN	BIGINT	BINARY	BIT
BLOB	BOOLEAN	BOTH	BY
CALL	CALLED	CARDINALITY	CASCADED
CASE	CAST	CEIL	CEILING
CHAR	CHAR_LENGTH	CHARACTER	CHARACTER_LENGTH
CHECK	CLASSIFIER	CLOB	CLOSE
COALESCE	COLLATE	COLLECT	COLUMN
COMMIT	CONDITION	CONNECT	CONSTRAINT
CONTAINS	CONVERT	CORR	CORRESPONDING
COUNT	COVAR_POP	COVAR_SAMP	CREATE
CROSS	CUBE	CUME_DIST	CURRENT
CURRENT_CATALOG	CURRENT_DATE	CURRENT_DEFAULT_TRANSFORM_GROUP	CURRENT_PATH
CURRENT_ROLE	CURRENT_ROW	CURRENT_SCHEMA	CURRENT_TIME
CURRENT_TIMESTAMP	CURRENT_TRANSFORM_GROUP_FOR_TYPE	CURRENT_USER	CURSOR
CYCLE	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	EVERY	EXCEPT
EXEC	EXECUTE	EXISTS	EXP
EXPLAIN	EXTEND	EXTERNAL	EXTRACT
FALSE	FETCH	FILES	FILTER
FIRST_VALUE	FLOAT	FLOOR	FOR
FOREIGN	FRAME_ROW	FREE	FROM
FULL	FUNCTION	FUSION	GET
GLOBAL	GRANT	GROUP	GROUPING
GROUPS	HAVING	HOLD	HOUR
IDENTITY	IMPORT	IN	INDICATOR
INITIAL	INNER	INOUT	INSENSITIVE
INSERT	INT	INTEGER	INTERSECT
INTERSECTION	INTERVAL	INTO	IS
JOIN	LAG	LANGUAGE	LARGE
LAST_VALUE	LATERAL	LEAD	LEADING
LEFT	LIKE	LIKE_REGEX	LIMIT
LN	LOCAL	LOCALTIME	LOCALTIMESTAMP
LOWER	MATCH	MATCHES	MATCH_NUMBER
MATCH_RECOGNIZE	MAX	MEASURES	MEMBER
MERGE	METHOD	MIN	MINUTE
MOD	MODIFIES	MODULE	MONTH
MORE	MULTISET	NATIONAL	NATURAL
NCHAR	NCLOB	NEW	NEXT
NO	NONE	NORMALIZE	NOT
NTH_VALUE	NTILE	NULL	NULLIF
NUMERIC	OCCURRENCES_REGEX	OCTET_LENGTH	OF
OFFSET	OLD	OMIT	ON
ONE	ONLY	OPEN	OR
ORDER	OUT	OUTER	OVER
OVERLAPS	OVERLAY	PARAMETER	PARTITION
PATTERN	PER	PERCENT	PERCENTILE_CONT
PERCENTILE_DISC	PERCENT_RANK	PERIOD	PERMUTE
PORTION	POSITION	POSITION_REGEX	POWER
PRECEDES	PRECISION	PREPARE	PREV
PRIMARY	PROCEDURE	RANGE	RANK
READS	REAL	RECURSIVE	REF
REFERENCES	REFERENCING	REGR_AVGX	REGR_AVGY
REGR_COUNT	REGR_INTERCEPT	REGR_R2	REGR_SLOPE
REGR_SXX	REGR_SXY	REGR_SYY	RELEASE
RESET	RESULT	RETURN	RETURNS
REVOKE	RIGHT	ROLLBACK	ROLLUP
ROW	ROW_NUMBER	ROWS	RUNNING
SAVEPOINT	SCOPE	SCROLL	SEARCH
SECOND	SEEK	SELECT	SENSITIVE
SESSION_USER	SET	MINUS	SHOW
SIMILAR	SKIP	SMALLINT	SOME
SPECIFIC	SPECIFICTYPE	SQL	SQLEXCEPTION
SQLSTATE	SQLWARNING	SQRT	START
STATIC	STDDEV_POP	STDDEV_SAMP	STREAM
SUBMULTISET	SUBSET	SUBSTRING	SUBSTRING_REGEX
SUCCEEDS	SUM	SYMMETRIC	SYSTEM
SYSTEM_TIME	SYSTEM_USER	TABLE	TABLES
TABLESAMPLE	THEN	TIME	TIMESTAMP
TIMEZONE_HOUR	TIMEZONE_MINUTE	TINYINT	TO
TRAILING	TRANSLATE	TRANSLATE_REGEX	TRANSLATION
TREAT	TRIGGER	TRIM	TRIM_ARRAY
TRUE	TRUNCATE	UESCAPE	UNION
UNIQUE	UNKNOWN	UNNEST	UPDATE
UPPER	UPSERT	USER	USING
VALUE	VALUES	VALUE_OF	VAR_POP
VAR_SAMP	VARBINARY	VARCHAR	VARYING
VERSIONING	WHEN	WHENEVER	WHERE
WIDTH_BUCKET	WINDOW	WITH	WITHIN
WITHOUT	YEAR