Reserved Words and Keywords - Amazon Kinesis Data Analytics
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

Reserved Words and Keywords

Reserved Words

The following is a list of reserved words in Amazon Kinesis Data Analytics applications as of version 5.0.1.

A
ABSALLALLOCATE
ALLOWALTERANALYZE
ANDANYAPPROXIMATE_ARRIVAL_TIME
AREARRAYAS
ASENSITIVEASYMMETRICAT
ATOMICAUTHORIZATIONAVG
B
BEGINBETWEENBIGINT
BINARYBITBLOB
BOOLEANBOTHBY
C
CALLCALLEDCARDINALITY
CASCADEDCASECAST
CEILCEILINGCHAR
CHARACTERCHARACTER_LENGTHCHAR_LENGTH
CHECKCHECKPOINTCLOB
CLOSECLUSTEREDCOALESCE
COLLATECOLLECTCOLUMN
COMMITCONDITIONCONNECT
CONSTRAINTCONVERTCORR
CORRESPONDINGCOUNTCOVAR_POP
COVAR_SAMPCREATECROSS
CUBECUME_DISTCURRENT
CURRENT_CATALOGCURRENT_DATECURRENT_DEFAULT_TRANSFORM_GROUP
CURRENT_PATHCURRENT_ROLECURRENT_SCHEMA
CURRENT_TIMECURRENT_TIMESTAMPCURRENT_TRANSFORM_GROUP_FOR_TYPE
CURRENT_USERCURSORCYCLE
D
DATEDAYDEALLOCATE
DECDECIMALDECLARE
DEFAULTDELETEDENSE_RANK
DEREFDESCRIBEDETERMINISTIC
DISALLOWDISCONNECTDISTINCT
DOUBLEDROPDYNAMIC
E
EACHELEMENTELSE
ENDEND-EXECESCAPE
EVERYEXCEPTEXEC
EXECUTEEXISTSEXP
EXPLAINEXP_AVGEXTERNAL
EXTRACT
F
FALSEFETCHFILTER
FIRST_VALUEFLOATFLOOR
FORFOREIGNFREE
FROMFULLFUNCTION
FUSION
G
GETGLOBALGRANT
GROUPGROUPING
H
HAVINGHOLDHOUR
I
IDENTITYIGNOREIMPORT
ININDICATORINITCAP
INNERINOUTINSENSITIVE
INSERTINTINTEGER
INTERSECTINTERSECTIONINTERVAL
INTOIS
J
JOIN
L
LANGUAGELARGELAST_VALUE
LATERALLEADINGLEFT
LIKELIMITLN
LOCALLOCALTIMELOCALTIMESTAMP
LOWER
M
MATCHMAXMEMBER
MERGEMETHODMIN
MINUTEMODMODIFIES
MODULEMONTHMULTISET
N
NATIONALNATURALNCHAR
NCLOBNEWNO
NODENONENORMALIZE
NOTNTH_VALUENULL
NULLIFNUMERIC
O
OCTET_LENGTHOFOLD
ONONLYOPEN
ORORDEROUT
OUTEROVEROVERLAPS
OVERLAY
P
PARAMETERPARTITIONPARTITION_ID
PARTITION_KEYPERCENTILE_CONTPERCENTILE_DISC
PERCENT_RANKPOSITIONPOWER
PRECISIONPREPAREPRIMARY
PROCEDURE
R
RANGERANKREADS
REALRECURSIVEREF
REFERENCESREFERENCINGREGR_AVGX
REGR_AVGYREGR_COUNTREGR_INTERCEPT
REGR_R2REGR_SLOPEREGR_SXX
REGR_SXYRELEASERESPECT
RESULTRETURNRETURNS
REVOKERIGHTROLLBACK
ROLLUPROWROWS
ROWTIMEROW_NUMBER
S
SAVEPOINTSCOPESCROLL
SEARCHSECONDSELECT
SENSITIVESEQUENCE_NUMBERSESSION_USER
SETSHARD_IDSIMILAR
SMALLINTSOMESORT
SPECIFICSQLSQLEXCEPTION
SQLSTATESQLWARNINGSQRT
STARTSTATICSTDDEV
STDDEV_POPSTDDEV_SAMPSTOP
STREAMSUBMULTISETSUBSTRING
SUMSYMMETRICSYSTEM
SYSTEM_USER
T
TABLETABLESAMPLETHEN
TIMETIMESTAMPTIMEZONE_HOUR
TIMEZONE_MINUTETINYINTTO
TRAILINGTRANSLATETRANSLATION
TREATTRIGGERTRIM
TRUETRUNCATE
U
UESCAPEUNIONUNIQUE
UNKNOWNUNNESTUPDATE
UPPERUSERUSING
V
VALUEVALUESVARBINARY
VARCHARVARYINGVAR_POP
VAR_SAMP
W
WHENWHENEVERWHERE
WIDTH_BUCKETWINDOWWITH
WITHINWITHOUT
Y
YEAR