腾讯云数据仓库 TCHouse-X 关键字

关键字在 TCHouse-X 中具有特殊含义，不能直接用作库名、表名、列名或其他标识符。
标识符引用规则
如果您必须使用保留字作为标识符，必须使用反引号（`）将其括起来。
示例
CREATE TABLE select (x INT);    -- 错误：select 是保留字
CREATE TABLE `select` (x INT);  -- 正确：使用了反引号
关键字列表
ADD
AGGREGATE
ALL
ALLOCATE
ALTER
ANALYTIC
AND
ANTI
ANY
API_VERSION
ARE
ARRAY
ARRAY_AGG
ARRAY_MAX_CARDINALITY
AS
ASC
ASENSITIVE
ASYMMETRIC
AT
ATOMIC
AUTHORIZATION
AUTO
AVRO
BEGIN_FRAME
BEGIN_PARTITION
BETWEEN
BIGINT
BINARY
BLOB
BLOCK_SIZE
BOOLEAN
BOTH
BUCKETS
BY
CACHED
CACHEMETRICS
CALLED
CAMUSER
CARDINALITY
CASCADE
CASCADED
CASE
CAST
CHANGE
CHAR
CHARACTER
CHARSET
CLASS
CLOB
CLOSE_FN
CLUSTERED
COLLATE
COLLATION
COLLECT
COLUMN
COLUMNS
COMMENT
COMMIT
COMPACT
COMPRESSION
COMPUTE
CONDITION
CONNECT
CONSTRAINT
CONTAINS
CONVERT
COPY
CORRESPONDING
CREATE
CROSS
CUBE
CURRENT
CURRENT_DEFAULT_TRANSFORM_GROUP
CURRENT_PATH
CURRENT_ROLE
CURRENT_ROW
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TRANSFORM_GROUP_FOR_TYPE
CURSOR
CYCLE
DATA
DATABASE
DATABASES
DATE
DATETIME
DBPROPERTIES
DEALLOCATE
DEC
DECFLOAT
DECIMAL
DECLARE
DEFAULT
DEFINE
DELETE
DELIMITED
DEREF
DESC
DESCRIBE
DETERMINISTIC
DISABLE
DISCONNECT
DISTINCT
DIV
DOUBLE
DROP
DYNAMIC
EACH
ELEMENT
ELSE
EMPTY
ENABLE
ENCODING
END
END_FRAME
END_PARTITION
ENFORCED
ENGINES
EQUALS
ESCAPE
ESCAPED
EVERY
EXCEPT
EXEC
EXECUTE
EXISTS
EXPLAIN
EXTENDED
EXTERNAL
FALSE
FAST
FETCH
FIELDS
FILEFORMAT
FILES
FILE_SIZE_THRESHOLD_MB
FILTER
FINALIZE_FN
FIRST
FLOAT
FN
FOLLOWING
FOR
FOREIGN
FORMAT
FORMATTED
FRAME_ROW
FREE
FROM
FULL
FUNCTION
FUNCTIONS
FUSION
GET
GLOBAL
GRANT
GROUP
GROUPING
GROUPS
HASH
HAVING
HOLD
HORN_CTE_MATERIALIZE
HORN_DPHYPER_ENABLE
HUDIPARQUET
ICEBERG
IDENTIFIED
IF
IGNORE
ILIKE
IN
INCREMENTAL
INDEX
INDEXES
INDICATOR
INITIAL
INIT_FN
INNER
INOUT
INPATH
INSENSITIVE
INSERT
INT
INTEGER
INTERMEDIATE
INTERSECT
INTERSECTION
INTERVAL
INTO
INVALIDATE
IREGEXP
IS
JOIN
JSONFILE
JSON_ARRAY
JSON_ARRAYAGG
JSON_EXISTS
JSON_OBJECT
JSON_OBJECTAGG
JSON_QUERY
JSON_TABLE
JSON_TABLE_PRIMITIVE
JSON_VALUE
KEYS
KILL
KUDU
LARGE
LAST
LATERAL
LEADING
LEFT
LEXICAL
LIKE
LIKE_REGEX
LIMIT
LINES
LISTAGG
LOAD
LOCAL
LOCALTIMESTAMP
LOCATION
MANAGEDLOCATION
MAP
MATCH
MATCHED
MATCHES
MATCH_NUMBER
MATCH_RECOGNIZE
MERGE
MERGE_FN
METADATA
METHOD
MINUS
MODEL
MODELS
MODEL_OPTIONS
MODIFIES
MULTISET
MYSQL
NAMES
NATIONAL
NATURAL
NCHAR
NCLOB
NO
NONE
NORELY
NORMALIZE
NOT
NOVALIDATE
NULL
NULLS
NUMERIC
OCCURRENCES_REGEX
OCTET_LENGTH
OF
OFFSET
OMIT
ON
ONE
ONLY
OPTIMIZE
OR
ORC
ORDER
OUT
OUTER
OVER
OVERLAPS
OVERLAY
OVERWRITE
PARQUET
PARQUETFILE
PARTITION
PARTITIONED
PARTITIONS
PATTERN
PER
PERCENT
PERCENTILE_CONT
PERCENTILE_DISC
PLUGINS
PORTION
POSITION
POSITION_REGEX
POSTGRESQL
PRECEDES
PRECEDING
PREPARE
PREPARE_FN
PRIMARY
PROCEDURE
PRODUCED
PROPERTIES
PTF
PURGE
QUERY
RANGE
RCFILE
READS
REAL
RECOVER
RECURSIVE
REF
REFERENCES
REFERENCING
REFRESH
REGEXP
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RELEASE
RELY
RENAME
REPEATABLE
REPLACE
REPLICATION
RESOURCE
RESOURCES
RESTRICT
RETURNS
REVOKE
RIGHT
RLIKE
ROLE
ROLES
ROLLUP
ROW
ROWS
RUNNING
RWSTORAGE
SAVEPOINT
SCHEMA
SCHEMAS
SCOPE
SCROLL
SEARCH
SEEK
SELECT
SEMI
SENSITIVE
SEQUENCEFILE
SERDEPROPERTIES
SERIALIZE_FN
SESSION
SET
SETS
SHOW
SIMILAR
SKIP
SMALLINT
SOME
SORT
SPARK
SPEC
SPECIFIC
SPECIFICTYPE
SQLEXCEPTION
SQLSTATE
SQLWARNING
STATIC
STATS
STATUS
STORAGEHANDLER_URI
STORED
STRAIGHT_JOIN
STREAM
STRING
STRUCT
SUBMULTISET
SUBSET
SUBSTRING_REGEX
SUCCEEDS
SYMBOL
SYMMETRIC
SYNC
SYSTEM_TIME
SYSTEM_VERSION
TABLE
TABLES
TABLESAMPLE
TBLPROPERTIES
TCI
TERMINATED
TEXTFILE
THEN
TIMESTAMP
TIMESTAMPNTZ
TIMESTAMPTZ
TIMESTAMP_NTZ
TIMEZONE_HOUR
TIMEZONE_MINUTE
TINYINT
TO
TRAILING
TRANSLATE_REGEX
TRANSLATION
TREAT
TRIGGER
TRIM_ARRAY
TRUE
TRUNCATE
UESCAPE
UNBOUNDED
UNCACHED
UNION
UNIQUE
UNKNOWN
UNLOCK
UNNEST
UNSET
UPDATE
UPDATE_FN
UPSERT
USE
USERS
USING
VALIDATE
VALUES
VALUE_OF
VARBINARY
VARCHAR
VARIABLES
VARYING
VERSIONING
VIEW
VIEWS
VIRTUAL_WAREHOUSE
WARMUP
WARNINGS
WHEN
WHENEVER
WHERE
WINDOW
WITH
WITHIN
WITHOUT
ZORDER

`ADD`	`AGGREGATE`	`ALL`
`ALLOCATE`	`ALTER`	`ANALYTIC`
`AND`	`ANTI`	`ANY`
`API_VERSION`	`ARE`	`ARRAY`
`ARRAY_AGG`	`ARRAY_MAX_CARDINALITY`	`AS`
`ASC`	`ASENSITIVE`	`ASYMMETRIC`
`AT`	`ATOMIC`	`AUTHORIZATION`
`AUTO`	`AVRO`	`BEGIN_FRAME`
`BEGIN_PARTITION`	`BETWEEN`	`BIGINT`
`BINARY`	`BLOB`	`BLOCK_SIZE`
`BOOLEAN`	`BOTH`	`BUCKETS`
`BY`	`CACHED`	`CACHEMETRICS`
`CALLED`	`CAMUSER`	`CARDINALITY`
`CASCADE`	`CASCADED`	`CASE`
`CAST`	`CHANGE`	`CHAR`
`CHARACTER`	`CHARSET`	`CLASS`
`CLOB`	`CLOSE_FN`	`CLUSTERED`
`COLLATE`	`COLLATION`	`COLLECT`
`COLUMN`	`COLUMNS`	`COMMENT`
`COMMIT`	`COMPACT`	`COMPRESSION`
`COMPUTE`	`CONDITION`	`CONNECT`
`CONSTRAINT`	`CONTAINS`	`CONVERT`
`COPY`	`CORRESPONDING`	`CREATE`
`CROSS`	`CUBE`	`CURRENT`
`CURRENT_DEFAULT_TRANSFORM_GROUP`	`CURRENT_PATH`	`CURRENT_ROLE`
`CURRENT_ROW`	`CURRENT_SCHEMA`	`CURRENT_TIME`
`CURRENT_TRANSFORM_GROUP_FOR_TYPE`	`CURSOR`	`CYCLE`
`DATA`	`DATABASE`	`DATABASES`
`DATE`	`DATETIME`	`DBPROPERTIES`
`DEALLOCATE`	`DEC`	`DECFLOAT`
`DECIMAL`	`DECLARE`	`DEFAULT`
`DEFINE`	`DELETE`	`DELIMITED`
`DEREF`	`DESC`	`DESCRIBE`
`DETERMINISTIC`	`DISABLE`	`DISCONNECT`
`DISTINCT`	`DIV`	`DOUBLE`
`DROP`	`DYNAMIC`	`EACH`
`ELEMENT`	`ELSE`	`EMPTY`
`ENABLE`	`ENCODING`	`END`
`END_FRAME`	`END_PARTITION`	`ENFORCED`
`ENGINES`	`EQUALS`	`ESCAPE`
`ESCAPED`	`EVERY`	`EXCEPT`
`EXEC`	`EXECUTE`	`EXISTS`
`EXPLAIN`	`EXTENDED`	`EXTERNAL`
`FALSE`	`FAST`	`FETCH`
`FIELDS`	`FILEFORMAT`	`FILES`
`FILE_SIZE_THRESHOLD_MB`	`FILTER`	`FINALIZE_FN`
`FIRST`	`FLOAT`	`FN`
`FOLLOWING`	`FOR`	`FOREIGN`
`FORMAT`	`FORMATTED`	`FRAME_ROW`
`FREE`	`FROM`	`FULL`
`FUNCTION`	`FUNCTIONS`	`FUSION`
`GET`	`GLOBAL`	`GRANT`
`GROUP`	`GROUPING`	`GROUPS`
`HASH`	`HAVING`	`HOLD`
`HORN_CTE_MATERIALIZE`	`HORN_DPHYPER_ENABLE`	`HUDIPARQUET`
`ICEBERG`	`IDENTIFIED`	`IF`
`IGNORE`	`ILIKE`	`IN`
`INCREMENTAL`	`INDEX`	`INDEXES`
`INDICATOR`	`INITIAL`	`INIT_FN`
`INNER`	`INOUT`	`INPATH`
`INSENSITIVE`	`INSERT`	`INT`
`INTEGER`	`INTERMEDIATE`	`INTERSECT`
`INTERSECTION`	`INTERVAL`	`INTO`
`INVALIDATE`	`IREGEXP`	`IS`
`JOIN`	`JSONFILE`	`JSON_ARRAY`
`JSON_ARRAYAGG`	`JSON_EXISTS`	`JSON_OBJECT`
`JSON_OBJECTAGG`	`JSON_QUERY`	`JSON_TABLE`
`JSON_TABLE_PRIMITIVE`	`JSON_VALUE`	`KEYS`
`KILL`	`KUDU`	`LARGE`
`LAST`	`LATERAL`	`LEADING`
`LEFT`	`LEXICAL`	`LIKE`
`LIKE_REGEX`	`LIMIT`	`LINES`
`LISTAGG`	`LOAD`	`LOCAL`
`LOCALTIMESTAMP`	`LOCATION`	`MANAGEDLOCATION`
`MAP`	`MATCH`	`MATCHED`
`MATCHES`	`MATCH_NUMBER`	`MATCH_RECOGNIZE`
`MERGE`	`MERGE_FN`	`METADATA`
`METHOD`	`MINUS`	`MODEL`
`MODELS`	`MODEL_OPTIONS`	`MODIFIES`
`MULTISET`	`MYSQL`	`NAMES`
`NATIONAL`	`NATURAL`	`NCHAR`
`NCLOB`	`NO`	`NONE`
`NORELY`	`NORMALIZE`	`NOT`
`NOVALIDATE`	`NULL`	`NULLS`
`NUMERIC`	`OCCURRENCES_REGEX`	`OCTET_LENGTH`
`OF`	`OFFSET`	`OMIT`
`ON`	`ONE`	`ONLY`
`OPTIMIZE`	`OR`	`ORC`
`ORDER`	`OUT`	`OUTER`
`OVER`	`OVERLAPS`	`OVERLAY`
`OVERWRITE`	`PARQUET`	`PARQUETFILE`
`PARTITION`	`PARTITIONED`	`PARTITIONS`
`PATTERN`	`PER`	`PERCENT`
`PERCENTILE_CONT`	`PERCENTILE_DISC`	`PLUGINS`
`PORTION`	`POSITION`	`POSITION_REGEX`
`POSTGRESQL`	`PRECEDES`	`PRECEDING`
`PREPARE`	`PREPARE_FN`	`PRIMARY`
`PROCEDURE`	`PRODUCED`	`PROPERTIES`
`PTF`	`PURGE`	`QUERY`
`RANGE`	`RCFILE`	`READS`
`REAL`	`RECOVER`	`RECURSIVE`
`REF`	`REFERENCES`	`REFERENCING`
`REFRESH`	`REGEXP`	`REGR_AVGX`
`REGR_AVGY`	`REGR_COUNT`	`REGR_INTERCEPT`
`REGR_R2`	`REGR_SLOPE`	`REGR_SXX`
`REGR_SXY`	`REGR_SYY`	`RELEASE`
`RELY`	`RENAME`	`REPEATABLE`
`REPLACE`	`REPLICATION`	`RESOURCE`
`RESOURCES`	`RESTRICT`	`RETURNS`
`REVOKE`	`RIGHT`	`RLIKE`
`ROLE`	`ROLES`	`ROLLUP`
`ROW`	`ROWS`	`RUNNING`
`RWSTORAGE`	`SAVEPOINT`	`SCHEMA`
`SCHEMAS`	`SCOPE`	`SCROLL`
`SEARCH`	`SEEK`	`SELECT`
`SEMI`	`SENSITIVE`	`SEQUENCEFILE`
`SERDEPROPERTIES`	`SERIALIZE_FN`	`SESSION`
`SET`	`SETS`	`SHOW`
`SIMILAR`	`SKIP`	`SMALLINT`
`SOME`	`SORT`	`SPARK`
`SPEC`	`SPECIFIC`	`SPECIFICTYPE`
`SQLEXCEPTION`	`SQLSTATE`	`SQLWARNING`
`STATIC`	`STATS`	`STATUS`
`STORAGEHANDLER_URI`	`STORED`	`STRAIGHT_JOIN`
`STREAM`	`STRING`	`STRUCT`
`SUBMULTISET`	`SUBSET`	`SUBSTRING_REGEX`
`SUCCEEDS`	`SYMBOL`	`SYMMETRIC`
`SYNC`	`SYSTEM_TIME`	`SYSTEM_VERSION`
`TABLE`	`TABLES`	`TABLESAMPLE`
`TBLPROPERTIES`	`TCI`	`TERMINATED`
`TEXTFILE`	`THEN`	`TIMESTAMP`
`TIMESTAMPNTZ`	`TIMESTAMPTZ`	`TIMESTAMP_NTZ`
`TIMEZONE_HOUR`	`TIMEZONE_MINUTE`	`TINYINT`
`TO`	`TRAILING`	`TRANSLATE_REGEX`
`TRANSLATION`	`TREAT`	`TRIGGER`
`TRIM_ARRAY`	`TRUE`	`TRUNCATE`
`UESCAPE`	`UNBOUNDED`	`UNCACHED`
`UNION`	`UNIQUE`	`UNKNOWN`
`UNLOCK`	`UNNEST`	`UNSET`
`UPDATE`	`UPDATE_FN`	`UPSERT`
`USE`	`USERS`	`USING`
`VALIDATE`	`VALUES`	`VALUE_OF`
`VARBINARY`	`VARCHAR`	`VARIABLES`
`VARYING`	`VERSIONING`	`VIEW`
`VIEWS`	`VIRTUAL_WAREHOUSE`	`WARMUP`
`WARNINGS`	`WHEN`	`WHENEVER`
`WHERE`	`WINDOW`	`WITH`
`WITHIN`	`WITHOUT`	`ZORDER`

关键字

本页目录：

标识符引用规则

示例

关键字列表