以下列出了GBase 8a MPP Cluster支持的SQL保留字。
|
ACCESSIBLE |
ADD |
ALL |
|
ALTER |
ANALYZE |
AND |
|
AS |
ASC |
ASENSITIVE |
|
BEFORE |
BETWEEN |
BIGINT |
|
BINARY |
BIT_AND |
BIT_OR |
|
BIT_XOR |
BLOB |
BOTH |
|
BY |
|
|
|
CALL |
CASCADE |
CASE |
|
CAST |
CHANGE |
CHAR |
|
CHARACTER |
CHECK |
CLUSTER |
|
COLLATE |
COLUMN |
COMPRESS |
|
CONDITION |
CONNECT |
CONSTRAINT |
|
CONTINUE |
CONVERT |
COUNT |
|
CREATE |
CROSS |
CURDATE |
|
CURDATETIME |
CURRENT_DATE |
CURRENT_DATETIME |
|
CURRENT_TIME |
CURRENT_TIMESTAMP |
CURRENT_USER |
|
CURSOR |
CURTIME |
|
|
DATABASE |
DATABASES |
DATE_ADD |
|
DATE_SUB |
DAY_HOUR |
DAY_MICROSECOND |
|
DAY_MINUTE |
DAY_SECOND |
DEC |
|
DECIMAL |
DECLARE |
DEFAULT |
|
DELAYED |
DELETE |
DENSE_RANK |
|
DESC |
DESCRIBE |
DETERMINISTIC |
|
DISTINCT |
DISTINCTROW |
DISTRIBUTE |
|
DISTRIBUTED |
DIV |
DOUBLE |
|
DROP |
DUAL |
|
|
EACH |
ELSE |
ELSEIF |
|
ENCLOSED |
ESCAPED |
EXISTS |
|
EXIT |
EXPLAIN |
EXTRACT |
|
EXCEPT |
|
|
|
FALSE |
FETCH |
FLOAT |
|
FLOAT4 |
FLOAT8 |
FOR |
|
FORCE |
FOREIGN |
FROM |
|
FULL |
FULLTEXT |
|
|
GCEXPORT |
GCIMPORT |
GCLOCAL |
|
GCLUSTER |
GCLUSTER_LOCAL |
GET |
|
GRANT |
GROUP |
GROUPED |
|
GROUP_CONCAT |
HAVING |
HIGH_PRIORITY |
|
HOUR_MICROSECOND |
HOUR_MINUTE |
HOUR_SECOND |
|
IF |
IGNORE |
IN |
|
INDEX |
INFILE |
INITNODEDATAMAP |
|
INNER |
INOUT |
INPATH |
|
INSENSITIVE |
INSERT |
INT |
|
INT1 |
INT2 |
INT3 |
|
INT4 |
INT8 |
INTEGER |
|
INTERSECT |
INTERVAL |
INTO |
|
IS |
ITERATE |
JOIN |
|
KEY |
KEYS |
KILL |
|
LAG |
LEAD |
LEADING |
|
LEAVE |
LEFT |
LEVEL |
|
LIKE |
LIMIT |
LIMIT_STORAGE_SIZE |
|
LINEAR |
LINES |
LINK |
|
LOAD |
LOCALTIME |
LOCALTIMESTAMP |
|
LOCK |
LONG |
LONGBLOB |
|
LONGTEXT |
LOOP |
LOW_PRIORITY |
|
MASTER_SSL_VERIFY_SERVER_CERT |
MATCH |
MAX |
|
MEDIUMBLOB |
MEDIUMINT |
MEDIUMTEXT |
|
MERGE |
MID |
MIDDLEINT |
|
MIN |
MINUS |
MINUTE_MICROSECOND |
|
MINUTE_SECOND |
MOD |
MODIFIES |
|
NATURAL |
NOCOPIES |
NOCYCLE |
|
NOT |
NOW |
NO_WRITE_TO_BINLOG |
|
NULL |
NUMERIC |
|
|
ON |
OPTIMIZE |
OPTION |
|
OPTIONALLY |
OR |
ORDER |
|
ORDERED |
OUT |
OUTER |
|
OUTFILE |
OVER |
|
|
POSITION |
PRECEDING |
PRIMARY |
|
PRIOR |
PROCEDURE |
PURGE |
|
RANGE |
RANK |
READ |
|
READS |
READ_WRITE |
REAL |
|
REFERENCES |
REFRESH |
REFRESHNODEDATAMAP |
|
REGEXP |
RELEASE |
RENAME |
|
REPEAT |
REPLACE |
REQUIRE |
|
RESTRICT |
RETURN |
REVERT |
|
REVOKE |
RIGHT |
RLIKE |
|
SCHEMA |
SCHEMAS |
SCN_NUMBER |
|
SECOND_MICROSECOND |
SEGMENT_ID |
SELECT |
|
SELF |
|
|
|
SENSITIVE |
SEPARATOR |
SET |
|
SHOW |
SMALLINT |
SORT |
|
SPATIAL |
SPECIFIC |
SQL |
|
SQLEXCEPTION |
SQLSTATE |
SQLWARNING |
|
SQL_BIG_RESULT |
SQL_CALC_FOUND_ROWS |
SQL_SMALL_RESULT |
|
SSL |
START |
STARTING |
|
STD |
STDDEV |
STDDEV_POP |
|
STDDEV_SAMP |
STRAIGHT_JOIN |
|
|
TABLE |
TARGET |
TERMINATED |
|
THEN |
TINYBLOB |
TINYINT |
|
TINYTEXT |
TO |
TRAILING |
|
TRIGGER |
TRIM |
TRUE |
|
UNDO |
UNION |
UNIQUE |
|
UNLOCK |
UNSIGNED |
UPDATE |
|
USAGE |
USE |
USING |
|
UTC_DATE |
UTC_DATETIME |
UTC_TIME |
|
UTC_TIMESTAMP |
|
|
|
VALUES |
VARBINARY |
VARCHAR |
|
VARCHARACTER |
VARYING |
VAR_SAMP |
|
WHEN |
WHERE |
WHILE |
|
WITH |
WRITE |
|
|
XOR |
|
|
|
YEAR_MONTH |
|
|
|
ZEROFILL |
|
|




