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	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