本文属于机器翻译版本。若本译文内容与英语原文存在差异,则一律以英文原文为准。
保留字和关键字
保留字
以下是自版本 5.0.1 起 Amazon Kinesis Data Analytics 应用程序中的保留关键字的列表。
| A | ||
| ABS | ALL | ALLOCATE | 
| 允许 | 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 | 忽略 | 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 | 
| 否 | ||
| NATIONAL | NATURAL | NCHAR | 
| NCLOB | 新 | 否 | 
| NODE | NONE | NORMALIZE | 
| NOT | NTH_VALUE | NULL | 
| NULLIF | NUMERIC | |
| O | ||
| OCTET_LENGTH | OF | OLD | 
| 开 | ONLY | OPEN | 
| 或 | 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 | 联合 | UNIQUE | 
| UNKNOWN | UNNEST | UPDATE | 
| UPPER | USER | USING | 
| V | ||
| 值 | VALUES | VARBINARY | 
| VARCHAR | VARYING | VAR_POP | 
| VAR_SAMP | ||
| W | ||
| WHEN | WHENEVER | WHERE | 
| WIDTH_BUCKET | WINDOW | WITH | 
| WITHIN | WITHOUT | |
| Y | ||
| YEAR | ||