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

ALLALLOCATEALLOWALTER
ANALYZEANYAREARRAY
ARRAY_MAX_CARDINALITYASASENSITIVEASYMMETRIC
ATATOMICAUTHORIZATIONBEGIN
BEGIN_FRAMEBEGIN_PARTITIONBETWEENBIGINT
BINARYBITBLOBBOOLEAN
BOTHBYCALLCALLED
CARDINALITYCASCADEDCASECAST
CEILINGCHARCHARACTERCHECK
CLASSIFIERCLOBCLOSECOALESCE
COLLATECOLLECTCOMMITCOMPACT
COMPUTECONDITIONCONNECTCONSTRAINT
CONVERTCORRESPONDINGCREATECROSS
CUBECUME_DISTCURRENTCURRENT_CATALOG
CURRENT_DEFAULT_TRANSFORM_GROUPCURRENT_PATHCURRENT_ROLECURRENT_ROW
CURRENT_TRANSFORM_GROUP_FOR_TYPECURRENT_USERCURSORCYCLE
DATABASESDATEDAYDEALLOCATE
DECDECIMALDECLAREDEFAULT
DEFINEDELETEDENSE_RANKDEREF
DESCRIBEDETERMINISTICDISALLOWDISCONNECT
DISTINCTDOUBLEDROPDYNAMIC
EACHELEMENTELSEEMPTY
ENDEND-EXECEND_FRAMEEND_PARTITION
EQUALSESCAPEEXCEPTEXEC
EXECUTEEXISTSEXPLAINEXTEND
EXTERNALEXTRACTFALSEFETCH
FILESFILTERFIRST_VALUEFLOAT
FORFOREIGNFRAME_ROWFREE
FROMFULLFUNCTIONFUSION
GETGLOBALGRANTGROUP
GROUPINGGROUPSHAVINGHOLD
HOURIDENTITYIFIMPORT
ININCLUDEINDICATORINITIAL
INNERINOUTINSENSITIVEINSERT
INTINTEGERINTERSECTINTERSECTION
INTERVALINTOISJOIN
LAGLANGUAGELARGELAST_VALUE
LATERALLEADLEADINGLIKE_REGEX
LIMITLNLOADLOCAL
MATCHMATCHESMATCH_NUMBERMATCH_RECOGNIZE
MEMBERMERGEMETADATAMETHOD
MINUSMINUTEMODIFIESMODULE
MONTHMULTISETNATIONALNATURAL
NCHARNCLOBNEWNEXT
NONONENORMALIZENTH_VALUE
NTILENULLNULLIFNUMERIC
OCCURRENCES_REGEXOFOFFSETOLD
OMITONONEONLY
OPENORDEROUTOUTER
OVEROVERLAPSOVERLAYPARAMETER
PARTITIONPARTITIONSPATTERNPER
PERCENTPERCENTILE_CONTPERCENTILE_DISCPERCENT_RANK
PERIODPERMUTEPIVOTPORTION
POSITION_REGEXPRECEDESPRECISIONPREPARE
PREVPRIMARYPROCEDURERANGE
RANKREADSREALRECURSIVE
REFREFERENCESREFERENCINGREFRESH
REGR_AVGXREGR_AVGYREGR_COUNTREGR_INTERCEPT
REGR_R2REGR_SLOPEREGR_SXXREGR_SXY
REGR_SYYRELEASERESETRESULT
RETURNRETURNSREVOKEROLLBACK
ROLLUPROWROWSROW_NUMBER
RUNNINGSAVEPOINTSCHEMASSCOPE
SCROLLSEARCHSECONDSEEK
SELECTSENSITIVESETSHOW
SKIPSMALLINTSOMESPECIFIC
SPECIFICTYPESQLSQLEXCEPTIONSQLSTATE
SQLWARNINGSTARTSTATICSTATISTICS
STREAMSUBMULTISETSUBSETSUBSTRING_REGEX
SUCCEEDSSYMMETRICSYSTEMSYSTEM_TIME
TABLETABLESTABLESAMPLETHEN
TIMETIMESTAMPTIMEZONE_HOURTIMEZONE_MINUTE
TINYINTTOTRAILINGTRANSLATE
TRANSLATE_REGEXTRANSLATIONTREATTRIGGER
TRIMTRIM_ARRAYTRUEUESCAPE
UNIONUNIQUEUNKNOWNUNNEST
UNPIVOTUNSETUPDATEUPSERT
USEUSINGVALUEVALUES
VALUE_OFVARBINARYVARCHARVARYING
VERSIONINGWHENWHENEVERWHERE
WIDTH_BUCKETWINDOWWITHWITHIN
WITHOUTYEAR