StarRocks关键字

注: 加粗字体为常用关键字

A:

ADD , ADMIN , AFTER , AGGREGATE , ALL , ALTER , AND , ANALYZE , ANTI, ARRAY , AS , ASC , AUTHORS

B:

BACKEND, BACKUP , BETWEEN , BEGIN, BIGINT, BITMAP, BITMAP_UNION , BOOLEAN , BOTH, BROKER , BACKENDS , BY , BUILTIN, BUCKETS

C:

CANCEL , CASE , CAST , CHAIN, CHAR, CHARSET, CHECK, CLUSTER, CLUSTERS, COLLATE , COLLATION, COLUMN , COLUMNS , COMMENT, COMMIT, COMMITTED,CONFIG, CONNECTION, CONNECTION_ID, CONSISTENT, COSTS, COUNT , CREATE , CROSS, CUBE, CURRENT, CURRENT_TIMESTAMP, CURRENT_USER

D:

DATA , DATABASE , DATABASES , DATE , DATETIME , DAY , DECIMAL, DECIMALV2, DECIMAL32, DECIMAL64, DECIMAL128, DECOMMISSION , DEFAULT , DESC , DESCRIBE ,

DELETE , DISTINCT , DISTINCTPC, DISTINCTPCSA, DISTRIBUTED, DISTRIBUTION , DYNAMIC, DIV, DOUBLE, DROP , DROPP, DUAL, DUPLICATE, DENSE_RANK

E:

ELSE , END , ENGINE, ENGINES, ENTER, ERRORS, EVENTS, EXCEPT , EXISTS , EXPORT, EXTERNAL , EXTRACT, EVERY

F:

FALSE, FOLLOWER , FOLLOWING, FREE, FROM , FILE, FIRST , FLOAT, FOR, FORCE , FORMAT , FRONTEND , FRONTENDS , FULL, FN, FUNCTION , FUNCTIONS

G:

GLOBAL , GRANT , GRANTS , GROUP , GROUPING

H:

HASH, HAVING , HELP, HLL , HLL_UNION , HOUR , HUB

I:

IDENTIFIED, IF , IN , INDEX , INDEXES, INFILE, INSTALL,

INNER , INSERT , INT, SIGNED, INTERMEDIATE, INTERSECT , INTERVAL, INTO , IGNORE , IS , ISNULL , ISOLATION

J:

JOIN , JSON,

K:

KEY , KEYS, KILL

L:

LABEL, LARGEINT, LAST , LEFT , LESS , LEVEL , LIKE , LIMIT , LINK, LOAD ,

LOCAL , LOCATION , LATERAL , LOGICAL

M:

MATERIALIZED , MAX , MAX_VALUE, MERGE , MIN , MINUTE , MINUS , MIGRATE, MIGRATIONS, MODIFY , MONTH

N:

NAME, NAMES , NEGATIVE, NO , NOT , NULL , NULLS,

O:

OBSERVER , OFFSET, ON, ONLY, OPEN, OR, ORDER, OUTER , OUTFILE, OVER

P:

PARTITION , PARTITIONS , PASSWORD , PATH , PAUSE, PIPE, PRECEDING,PLUGIN, PLUGINS,

PRIMARY , PROC , PROCEDURE ,PROCESSLIST,PROPERTIES,PROPERTY,

PERCENTILE, PERCENTILE_UNION

Q:

QUERY, QUOTA

R:

RANDOM, RANGE , READ , RECOVER, REGEXP, RELEASE , RENAME , RANK,ROW_NUMBER

REPAIR, REPEATABLE, REPOSITORY, REPOSITORIES, REPLACE, REPLACE_IF_NOT_NULL, REPLICA , RESOURCE , RESOURCES , RESTORE, RETURNS, RESUME, REVOKE,

RIGHT , ROLE, ROLES, ROLLBACK , ROLLUP , ROUTINE , ROW , ROWS , REFRESH

S:

SCHEMA , SCHEMAS, SECOND, SELECT , SEMI , SERIALIZABLE, SESSION, SET, SETS , SET_VAR, SHOW,

SMALLINT, SNAPSHOT, SONAME, SPLIT, START , STATUS, STOP , STORAGE, STRING,

SUM , SUPERUSER, SYNC, SYSTEM , SWAP

T:

TABLE, TABLES, TABLET, TASK, TEMPORARY, TERMINATED, THAN, TIME, THEN , TIMESTAMP, TINYINT, TO , TRANSACTION, TRIGGERS, TRIM, TRUE, TRUNCATE, TYPE , TYPES,

U:

UNCOMMITTED, UNBOUNDED, UNION, UNIQUE , UNSIGNED, USE, USER, USING , UNINSTALL

V:

VALUE, VALUES , VARCHAR, VARIABLES, VERBOSE, VIEW

W:

WARNINGS, WEEK , WHEN , SQLBLACKLIST, WHITELIST, WHERE, WITH, WORK, WRITE

Y:

YEAR;

1赞

这个应该将关键字和保留字 写入到information_schema库中,方便查询,类似于mysql中