On this page

    Reserved Keywords

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

    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