Reserved Words and Keywords - Amazon Kinesis Data Analytics SQL Reference

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