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