云服务器特惠 99/年起
  1. 腾讯云优惠网首页
  2. 腾讯云产品

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

• 腾讯云产品

关键字在 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

相关内容：

  1. 腾讯云数据仓库 TCHouse-X CREATE VIEW 语句 CREATE VIEW 语句允许你为复杂的查询创建一个简洁的别名（即视图）。视图纯粹是一个逻辑构造，不包含任何底层数据。...
  2. 腾讯云数据仓库 TCHouse-P 产品简介 为配合腾讯云云数据仓库品牌升级，原有“云数据仓库 PostgreSQL”服务计划于2023年9月4日更名为“腾讯云数据仓库 TCHouse-P”。此次云服务更名仅对产品介绍、控制台及产品文档中的产品名称进行更新，对产品功能使用无影响。本次品牌升级后，腾讯云企业级云数据仓库（TCHouse）将下设三大产品系列，分别是腾讯云数据仓库 TCHouse-C、腾讯云数据仓库 TCHouse-D、腾讯云数据仓库 TCHouse-。...
  3. 腾讯云数据仓库 TCHouse-X UNPIVOT UNPIVOT 子句将列转换为行，是 PIVOT 的逆操作（但不包含聚合），支持无别名和标识符别名两种形式。...
  4. 腾讯云数据仓库 TCHouse-X TABLESAMPLE TABLESAMPLE 语句用于对表进行采样，支持按行数 (ROWS)、百分比 (PERCENT) 或桶 (BUCKET) 采样。...
  5. 腾讯云数据仓库 TCHouse-X 快速入门 TCHouse-X 是一款具备“离在线一体化”能力的新一代云原生数据仓库。本简介旨在帮助用户通过一个完整的闭环流程（从实例创建到 BI 可视化分析），快速掌握产品核心功能与操作逻辑。...
  6. 腾讯云数据仓库 TCHouse-X CTE(Common Table Expression) 公共表表达式（CTE）定义了一个临时结果集，用户可以在 SQL 语句的范围内多次引用。CTE 主要用于 SELECT 语句。...
  7. 腾讯云数据仓库 TCHouse-X CREATE TABLE LIKE CREATE TABLE LIKE 语句复制已有表的结构（Schema），创建一个具有相同列定义但不含数据的新表，新表可以覆盖部分属性（如 TBLPROPERTIES、COMMENT 等）。...
  8. 腾讯云数据仓库 TCHouse-X RENAME TABLE ALTER TABLE ... RENAME TO 语句用于重命名已有的表。重命名操作只修改元数据，不影响表中实际存储的数据。...
赞 (0)
上一篇 4天前
下一篇 4天前