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

数据湖计算 DLC ALTER TABLE … WRITE ORDERED BY

• 腾讯云产品

ALTER TABLE table_identifier WRITE [LOCALLY] ORDERED BY {col_name [ASC|DESC] [NULLS FIRST|LAST]}[, …]。

相关产品
数据湖计算 DLC 产品页，含版本规格、价格与购买入口。

一、说明

·支持内核：SparkSQL。

·适用表范围：外部 Iceberg 表、原生 Iceberg 表。

·用途：设置表数据插入时的排序方式。

二、参数

table_identifier：数据表名称

三、示例

ALTER TABLE dempts WRITE ORDERED BY category, id;– use optional ASC/DEC keyword to specify sort order of each field (default ASC)ALTER TABLE dempts WRITE ORDERED BY category ASC, id DESC;– use optional NULLS FIRST/NULLS LAST keyword to specify null order of each field (default FIRST)ALTER TABLE dempts WRITE ORDERED BY category ASC NULLS LAST, id DESC NULLS FIRST;– To order within each task, not across tasksALTER TABLE dempts WRITE LOCALLY ORDERED BY category, id;

相关内容：

  1. 数据湖计算 DLC ALTER TABLE … WRITE DISTRIBUTED BY PARTITION ALTER TABLE table_identifier WRITE DISTRIBUTED BY PARTITION [ LOCALLY ORDERED BY {col_name [ASC|DESC] [NULLS FIRST|LAST]}[, ...]]。...
  2. 腾讯云数据仓库 TCHouse-X WRITE ORDERED BY ALTER TABLE ... WRITE ORDERED BY 语句用于为表设置写入时的排序顺序。当数据写入该表时（例如通过 MERGE INTO），引擎会按照指定的排序顺序组织数据，从而提升查询性能。...
  3. 数据湖计算 DLC ALTER TABLE ADD PARTITION FIELD ALTER TABLE table_name ADD PARTITION partition_column | hidden_partition_spec [AS alias]hidden_partition_spec: Supported transformations are: years(ts): partition by year months(ts): partition by month days(ts。...
  4. 数据湖计算 DLC DDL 语法（Iceberg 表语法） CREATE TABLE [ IF NOT EXISTS ] table_identifier( col_name[:] col_type [ COMMENT col_comment ], ... )[ COMMENT table_comment ][ PARTITIONED BY ( col_name1, transform(col_name2), ... ) ]。...
  5. 数据湖计算 DLC ALTER TABLE DROP PARTITION FIELD ALTER TABLE table_name ADD PARTITION partition_column | hidden_partition_spechidden_partition_spec: Supported transformations are: years(ts): partition by year months(ts): partition by month days(ts) or date(t。...
  6. 数据湖计算 DLC TABLE METADATA SELECT select_expr (, select_expr)*FROM `Catalog`.`db`.`tableName${history|snapshots|files|manifests|partitions|all_data_files|all_manifests}`[WHERE where_condition][LIMIT [offset,] rows]。...
  7. 数据湖计算 DLC ALTER TABLE SET TBLPROPERTIES ALTER TABLE table_name SET TBLPROPERTIES (property_name=property_value, ...)。...
  8. 数据湖计算 DLC ALTER TABLE … RENAME COLUMN ALTER TABLE table_identifier RENAME COLUMN old_column_name TO new_column_name。...
赞 (0)
上一篇 4天前
下一篇 4天前