Skip to main content

Reserved Keywords

Dremio reserves ANSI keywords and additional keywords to perform SQL queries on datalake sources 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").

ABS
ACCESS
ACOS
AES_DECRYPT
AGGREGATE
ALL
ALLOCATE
ALLOW
ALTER
ANALYZE
AND
ANY
APPROX_COUNT_DISTINCT
APPROX_PERCENTILE
ARE
ARRAY_AVG
ARRAY_CAT
ARRAY_COMPACT
ARRAY_CONTAINS
ARRAY_GENERATE_RANGE
ARRAY_MAX_CARDINALITY
ARRAY_MAX
ARRAY_MIN
ARRAY_POSITION
ARRAY_REMOVE_AT
ARRAY_REMOVE
ARRAY_SIZE
ARRAY_SUM
ARRAY_TO_STRING
ARRAY
ARROW
AS
ASCII
ASENSITIVE
ASIN
ASSIGN
ASYMMETRIC
AT
ATAN
ATAN2
ATOMIC
AUTHORIZATION
AUTO
AVG
AVOID
BASE64
BATCH
BEGIN_FRAME
BEGIN_PARTITION
BEGIN
BETWEEN
BIGINT
BIN_PACK
BIN
BINARY_STRING
BINARY
BIT_AND
BIT_LENGTH
BIT_OR
BIT
BITWISE_AND
BITWISE_NOT
BITWISE_OR
BITWISE_XOR
BLOB
BOOL_AND
BOOL_OR
BOOLEAN
BOTH
BRANCH
BROUND
BTRIM
BY
CACHE
CALL
CALLED
CARDINALITY
CASCADED
CASE
CAST
CATALOG
CBRT
CEIL
CEILING
CHANGE
CHAR_LENGTH
CHAR
CHARACTER_LENGTH
CHARACTER
CHECK
CHR
CLASSIFIER
CLOB
CLOSE
CLOUD
COALESCE
COL_LIKE
COLLATE
COLLECT
COLUMN
COLUMNS
COMMIT
COMMITS_OLDER_THAN
COMPACT
COMPUTE
CONCAT_WS
CONCAT
CONDITION
CONNECT
CONSTRAINT
CONTAINS
CONVERT_FROM
CONVERT_REPLACEUTF8
CONVERT_TIMEZONE
CONVERT_TO
CONVERT
COPY
CORR
CORRESPONDING
COS
COSH
COT
COUNT
COVAR_POP
COVAR_SAMP
CRC32
CREATE
CROSS
CUBE
CUME_DIST
CURRENT_CATALOG
CURRENT_DATE_UTC
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
CURRENT
CURSOR
CYCLE
DATA
DATABASES
DATASETS
DATE_ADD
DATE_DIFF
DATE_FORMAT
DATE_PART
DATE_SUB
DATE_TRUNC
DATE
DATEDIFF
DATETYPE
DAY
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEALLOCATE
DEC
DECIMAL
DECLARE
DEDUPE_LOOKBACK_PERIOD
DEFAULT
DEFINE
DEGREES
DELETE
DENSE_RANK
DEREF
DESCRIBE
DETERMINISTIC
DIMENSIONS
DISALLOW
DISCONNECT
DISPLAY
DISTINCT
DOUBLE
DROP
DYNAMIC
E
EACH
ELEMENT
ELSE
EMPTY_AS_NULL
EMPTY
ENCODE
END_FRAME
END_PARTITION
END-EXEC
END
ENDS_WITH
ENGINE
EQUALS
ESCAPE_CHAR
ESCAPE
EVERY
EXCEPT
EXEC
EXECUTE
EXISTS
EXP
EXP
EXPIRE
EXPLAIN
EXTEND
EXTERNAL
EXTRACT
FACTORIAL
FALSE
FETCH
FIELD_DELIMITER
FIELD
FILE_FORMAT
FILES
FILTER
FIRST_VALUE
FLATTEN
FLOAT
FLOOR
FOLDER
FOR
FOREIGN
FRAME_ROW
FREE
FROM_HEX
FROM
FULL
FUNCTION
FUSION
GEO_BEYOND
GEO_DISTANCE
GEO_NEARBY
GET
GLOBAL
GRANT
GRANTS
GREATEST
GROUP
GROUPING
GROUPS
HASH
HASH64
HAVING
HEX
HISTORY
HOLD
HOUR
IDENTITY
IF
ILIKE
IMINDIR
IMPORT
IN
INCLUDE
INDICATOR
INITCAP
INITIAL
INNER
INOUT
INSENSITIVE
INSERT
INSTR
INT
INTEGER
INTERSECT
INTERSECTION
INTERVAL
INTO
IS [NOT] DISTINCT FROM
IS [NOT] FALSE
IS [NOT] NULL
IS [NOT] TRUE
IS_BIGINT
IS_INT
IS_MEMBER
IS_SUBSTR
IS_UTF8
IS_VARCHAR
IS
ISDATE
ISNUMERIC
JOB
JOIN
JSON_ARRAY
JSON_ARRAYAGG
JSON_EXISTS
JSON_OBJECT
JSON_OBJECTAGG
JSON_QUERY
JSON_VALUE
LAG
LANGUAGE
LARGE
LAST_DAY
LAST_QUERY_ID
LAST_VALUE
LATERAL
LAZY
LCASE
LEAD
LEADING
LEAST
LEFT
LENGTH
LEVENSHTEIN
LIKE_REGEX
LIKE
LIMIT
LISTAGG
LN
LOAD
LOCAL
LOCALSORT
LOCALTIME
LOCALTIMESTAMP
LOCATE
LOG
LOG10
LOGS
LOWER
LPAD
LSHIFT
LTRIM
MANIFESTS
MAP_KEYS
MAP_VALUES
MASK_FIRST_N
MASK_HASH
MASK_LAST_N
MASK_SHOW_FIRST_N
MASK_SHOW_LAST_N
MASK
MASKING
MATCH_NUMBER
MATCH_RECOGNIZE
MATCH
MATCHES
MAX_FILE_SIZE_MB
MAX
MAXDIR
MD5
MEASURES
MEDIAN
MEMBER
MERGE
METADATA
METHOD
MIN_FILE_SIZE_MB
MIN_INPUT_FILES
MIN
MINDIR
MINUS
MINUTE
MISSING
MOD
MODIFIES
MODULE
MONITOR
MONTH
MONTH
MONTHS_BETWEEN
MORE
MULTISET
NATIONAL
NATURAL
NCHAR
NCLOB
NDV
NEW
NEXT_DAY
NEXT
NO
NONE
NORMALIZE_STRING
NORMALIZE
NOT
NOTIFICATION_PROVIDER
NOTIFICATION_QUEUE_REFERENCE
NOW
NTH_VALUE
NTILE
NULL_IF
NULL
NULLIF
NUMERIC
NVL
OCCURRENCES_REGEX
OCTET_LENGTH
OF
OFFSET
OLD
OLDER_THAN
OMIT
ON
ONE
ONLY
OPEN
OPERATE
OPTIMIZE
OR
ORDER
ORPHAN
OUT
OUTER
OVER
OVERLAPS
OVERLAY
OWNERSHIP
PARAMETER
PARSE_URL
PARTITION
PARTITIONS
PATTERN
PER
PERCENT_RANK
PERCENT
PERCENTILE_CONT
PERCENTILE_DISC
PERIOD
PERMUTE
PI
PIPE
PIPES
PIVOT
PMOD
POLICY
PORTION
POSITION_REGEX
POSITION
POW
POWER
PRECEDES
PRECISION
PREPARE
PREV
PRIMARY
PROCEDURE
PROJECT
PROMOTION
QUALIFY
QUARTER
QUERY_USER
QUERY
QUOTE_CHAR
QUOTE
RADIANS
RANDOM
RANGE
RANK
RAW
READS
REAL
RECORD_DELIMITER
RECURSIVE
REF
REFERENCE
REFERENCES
REFERENCING
REFLECTION
REFLECTIONS
REFRESH
REGEX
REGEXP_COL_LIKE
REGEXP_EXTRACT
REGEXP_LIKE
REGEXP_MATCHES
REGEXP_REPLACE
REGEXP_SPLIT
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXY
REGR_SYY
RELEASE
REMOVE
RENAME
REPEAT
REPEATSTR
REPLACE
RESET
RESULT
RETAIN_LAST
RETAIN_LAST_COMMITS
RETAIN_LAST_SNAPSHOTS
RETURN
RETURNS
REVERSE
REVOKE
REWRITE
RIGHT
ROLE
ROLLBACK
ROLLUP
ROUND
ROUTE
ROW_NUMBER
ROW
ROWS
RPAD
RSHIFT
RTRIM
RUNNING
SAVEPOINT
SCHEMAS
SCOPE
SCROLL
SEARCH
SECOND
SEEK
SELECT
SENSITIVE
SESSION_USER
SET
SHA
SHA1
SHA256
SHA512
SHOW
SIGN
SIMILAR_TO
SIMILAR
SIN
SINH
SIZE
SKIP
SMALLINT
SNAPSHOT
SNAPSHOTS_OLDER_THAN
SNAPSHOTS
SOME
SOUNDEX
SPECIFIC
SPECIFICTYPE
SPLIT_PART
SQL
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQRT
SQRT
ST_FROMGEOHASH
ST_GEOHASH
START
STARTS_WITH
STATIC
STATISTICS
STDDEV_POP
STDDEV_SAMP
STDDEV
STREAM
STRING_BINARY
STRPOS
SUBMULTISET
SUBSET
SUBSTR
SUBSTRING_INDEX
SUBSTRING_REGEX
SUBSTRING
SUCCEEDS
SUM
SYMMETRIC
SYSTEM_TIME
SYSTEM_USER
SYSTEM
TABLE
TABLES
TABLESAMPLE
TAG
TAN
TANH
TARGET_FILE_SIZE_MB
TBLPROPERTIES
THEN
TIME_FORMAT
TIME
TIMESTAMP_FORMAT
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TIMESTAMPTYPE
TIMEZONE_HOUR
TIMEZONE_MINUTE
TINYINT
TO_CHAR
TO_DATE
TO_HEX
TO_NUMBER
TO_TIME
TO_TIMESTAMP
TO
TOASCII
TRAILING
TRANSACTION_TIMESTAMP
TRANSLATE_REGEX
TRANSLATE
TRANSLATION
TREAT
TRIGGER
TRIM_ARRAY
TRIM_SPACE
TRIM
TRUE
TRUNCATE
TYPEOF
UCASE
UESCAPE
UNBASE64
UNHEX
UNION
UNIQUE
UNIX_TIMESTAMP
UNKNOWN
UNNEST
UNPIVOT
UNSET
UPDATE
UPPER
UPSERT
USAGE
USE
USER
USING
VACUUM
VALUE_OF
VALUE
VALUES
VAR_POP
VAR_SAMP
VARBINARY
VARCHAR
VARYING
VERSIONING
VIEW
VIEWS
WEEK
WEEKOFYEAR
WHEN
WHENEVER
WHERE
WIDTH_BUCKET
WINDOW
WITH
WITHIN
WITHOUT
WRITE
XOR
YEAR