# 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
ABS	ALL	ALLOCATE
ALLOW	ALTER	ANALYZE
AND	ANY	APPROXIMATE\_ARRIVAL\_TIME
ARE	ARRAY	AS
ASENSITIVE	ASYMMETRIC	AT
ATOMIC	AUTHORIZATION	AVG
B
BEGIN	BETWEEN	BIGINT
BINARY	BIT	BLOB
BOOLEAN	BOTH	BY
C
CALL	CALLED	CARDINALITY
CASCADED	CASE	CAST
CEIL	CEILING	CHAR
CHARACTER	CHARACTER\_LENGTH	CHAR\_LENGTH
CHECK	CHECKPOINT	CLOB
CLOSE	CLUSTERED	COALESCE
COLLATE	COLLECT	COLUMN
COMMIT	CONDITION	CONNECT
CONSTRAINT	CONVERT	CORR
CORRESPONDING	COUNT	COVAR\_POP
COVAR\_SAMP	CREATE	CROSS
CUBE	CUME\_DIST	CURRENT
CURRENT\_CATALOG	CURRENT\_DATE	CURRENT\_DEFAULT\_TRANSFORM\_GROUP
CURRENT\_PATH	CURRENT\_ROLE	CURRENT\_SCHEMA
CURRENT\_TIME	CURRENT\_TIMESTAMP	CURRENT\_TRANSFORM\_GROUP\_FOR\_TYPE
CURRENT\_USER	CURSOR	CYCLE
D
DATE	DAY	DEALLOCATE
DEC	DECIMAL	DECLARE
DEFAULT	DELETE	DENSE\_RANK
DEREF	DESCRIBE	DETERMINISTIC
DISALLOW	DISCONNECT	DISTINCT
DOUBLE	DROP	DYNAMIC
E
EACH	ELEMENT	ELSE
END	END-EXEC	ESCAPE
EVERY	EXCEPT	EXEC
EXECUTE	EXISTS	EXP
EXPLAIN	EXP\_AVG	EXTERNAL
EXTRACT
F
FALSE	FETCH	FILTER
FIRST\_VALUE	FLOAT	FLOOR
FOR	FOREIGN	FREE
FROM	FULL	FUNCTION
FUSION
G
GET	GLOBAL	GRANT
GROUP	GROUPING
H
HAVING	HOLD	HOUR
I
IDENTITY	IGNORE	IMPORT
IN	INDICATOR	INITCAP
INNER	INOUT	INSENSITIVE
INSERT	INT	INTEGER
INTERSECT	INTERSECTION	INTERVAL
INTO	IS
J
JOIN
L
LANGUAGE	LARGE	LAST\_VALUE
LATERAL	LEADING	LEFT
LIKE	LIMIT	LN
LOCAL	LOCALTIME	LOCALTIMESTAMP
LOWER
M
MATCH	MAX	MEMBER
MERGE	METHOD	MIN
MINUTE	MOD	MODIFIES
MODULE	MONTH	MULTISET
N
NATIONAL	NATURAL	NCHAR
NCLOB	NEW	NO
NODE	NONE	NORMALIZE
NOT	NTH\_VALUE	NULL
NULLIF	NUMERIC
O
OCTET\_LENGTH	OF	OLD
ON	ONLY	OPEN
OR	ORDER	OUT
OUTER	OVER	OVERLAPS
OVERLAY
P
PARAMETER	PARTITION	PARTITION\_ID
PARTITION\_KEY	PERCENTILE\_CONT	PERCENTILE\_DISC
PERCENT\_RANK	POSITION	POWER
PRECISION	PREPARE	PRIMARY
PROCEDURE
R
RANGE	RANK	READS
REAL	RECURSIVE	REF
REFERENCES	REFERENCING	REGR\_AVGX
REGR\_AVGY	REGR\_COUNT	REGR\_INTERCEPT
REGR\_R2	REGR\_SLOPE	REGR\_SXX
REGR\_SXY	RELEASE	RESPECT
RESULT	RETURN	RETURNS
REVOKE	RIGHT	ROLLBACK
ROLLUP	ROW	ROWS
ROWTIME	ROW\_NUMBER
S
SAVEPOINT	SCOPE	SCROLL
SEARCH	SECOND	SELECT
SENSITIVE	SEQUENCE\_NUMBER	SESSION\_USER
SET	SHARD\_ID	SIMILAR
SMALLINT	SOME	SORT
SPECIFIC	SQL	SQLEXCEPTION
SQLSTATE	SQLWARNING	SQRT
START	STATIC	STDDEV
STDDEV\_POP	STDDEV\_SAMP	STOP
STREAM	SUBMULTISET	SUBSTRING
SUM	SYMMETRIC	SYSTEM
SYSTEM\_USER
T
TABLE	TABLESAMPLE	THEN
TIME	TIMESTAMP	TIMEZONE\_HOUR
TIMEZONE\_MINUTE	TINYINT	TO
TRAILING	TRANSLATE	TRANSLATION
TREAT	TRIGGER	TRIM
TRUE	TRUNCATE
U
UESCAPE	UNION	UNIQUE
UNKNOWN	UNNEST	UPDATE
UPPER	USER	USING
V
VALUE	VALUES	VARBINARY
VARCHAR	VARYING	VAR\_POP
VAR\_SAMP
W
WHEN	WHENEVER	WHERE
WIDTH\_BUCKET	WINDOW	WITH
WITHIN	WITHOUT
Y
YEAR