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
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