Skip to main content
Version: current [24.2.x]

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

ABSALLALLOCATEALLOW
ALTERANDANYARE
ARRAYARRAY_MAX_CARDINALITYASASENSITIVE
ASYMMETRICATATOMICAUTHORIZATION
AVGBEGINBEGIN_FRAMEBEGIN_PARTITION
BETWEENBIGINTBINARYBIT
BLOBBOOLEANBOTHBY
CALLCALLEDCARDINALITYCASCADED
CASECASTCEILCEILING
CHARCHAR_LENGTHCHARACTERCHARACTER_LENGTH
CHECKCLASSIFIERCLOBCLOSE
COALESCECOLLATECOLLECTCOLUMN
COMMITCONDITIONCONNECTCONSTRAINT
CONTAINSCONVERTCORRCORRESPONDING
COUNTCOVAR_POPCOVAR_SAMPCREATE
CROSSCUBECUME_DISTCURRENT
CURRENT_CATALOGCURRENT_DATECURRENT_DEFAULT_TRANSFORM_GROUPCURRENT_PATH
CURRENT_ROLECURRENT_ROWCURRENT_SCHEMACURRENT_TIME
CURRENT_TIMESTAMPCURRENT_TRANSFORM_GROUP_FOR_TYPECURRENT_USERCURSOR
CYCLEDATEDAYDEALLOCATE
DECDECIMALDECLAREDEFAULT
DEFINEDELETEDENSE_RANKDEREF
DESCRIBEDETERMINISTICDISALLOWDISCONNECT
DISTINCTDOUBLEDROPDYNAMIC
EACHELEMENTELSEEMPTY
ENDEND-EXECEND_FRAMEEND_PARTITION
EQUALSESCAPEEVERYEXCEPT
EXECEXECUTEEXISTSEXP
EXPLAINEXTENDEXTERNALEXTRACT
FALSEFETCHFILESFILTER
FIRST_VALUEFLOATFLOORFOR
FOREIGNFRAME_ROWFREEFROM
FULLFUNCTIONFUSIONGET
GLOBALGRANTGROUPGROUPING
GROUPSHAVINGHOLDHOUR
IDENTITYIMPORTININDICATOR
INITIALINNERINOUTINSENSITIVE
INSERTINTINTEGERINTERSECT
INTERSECTIONINTERVALINTOIS
JOINLAGLANGUAGELARGE
LAST_VALUELATERALLEADLEADING
LEFTLIKELIKE_REGEXLIMIT
LNLOCALLOCALTIMELOCALTIMESTAMP
LOWERMATCHMATCHESMATCH_NUMBER
MATCH_RECOGNIZEMAXMEASURESMEMBER
MERGEMETHODMINMINUTE
MODMODIFIESMODULEMONTH
MOREMULTISETNATIONALNATURAL
NCHARNCLOBNEWNEXT
NONONENORMALIZENOT
NTH_VALUENTILENULLNULLIF
NUMERICOCCURRENCES_REGEXOCTET_LENGTHOF
OFFSETOLDOMITON
ONEONLYOPENOR
ORDEROUTOUTEROVER
OVERLAPSOVERLAYPARAMETERPARTITION
PATTERNPERPERCENTPERCENTILE_CONT
PERCENTILE_DISCPERCENT_RANKPERIODPERMUTE
PORTIONPOSITIONPOSITION_REGEXPOWER
PRECEDESPRECISIONPREPAREPREV
PRIMARYPROCEDURERANGERANK
READSREALRECURSIVEREF
REFERENCESREFERENCINGREGR_AVGXREGR_AVGY
REGR_COUNTREGR_INTERCEPTREGR_R2REGR_SLOPE
REGR_SXXREGR_SXYREGR_SYYRELEASE
RESETRESULTRETURNRETURNS
REVOKERIGHTROLLBACKROLLUP
ROWROW_NUMBERROWSRUNNING
SAVEPOINTSCOPESCROLLSEARCH
SECONDSEEKSELECTSENSITIVE
SESSION_USERSETMINUSSHOW
SIMILARSKIPSMALLINTSOME
SPECIFICSPECIFICTYPESQLSQLEXCEPTION
SQLSTATESQLWARNINGSQRTSTART
STATICSTDDEV_POPSTDDEV_SAMPSTREAM
SUBMULTISETSUBSETSUBSTRINGSUBSTRING_REGEX
SUCCEEDSSUMSYMMETRICSYSTEM
SYSTEM_TIMESYSTEM_USERTABLETABLES
TABLESAMPLETHENTIMETIMESTAMP
TIMEZONE_HOURTIMEZONE_MINUTETINYINTTO
TRAILINGTRANSLATETRANSLATE_REGEXTRANSLATION
TREATTRIGGERTRIMTRIM_ARRAY
TRUETRUNCATEUESCAPEUNION
UNIQUEUNKNOWNUNNESTUPDATE
UPPERUPSERTUSERUSING
VALUEVALUESVALUE_OFVAR_POP
VAR_SAMPVARBINARYVARCHARVARYING
VERSIONINGWHENWHENEVERWHERE
WIDTH_BUCKETWINDOWWITHWITHIN
WITHOUTYEAR