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

数据湖计算 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。

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

一、说明

·支持内核：Presto、SparkSQL。

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

·用途：删除数据表的某个分区字段。

二、参数说明

·table_name：需要的表名字。

·partition_column：分区列。

三、示例

ALTER TABLE prod.db.sample DROP PARTITION FIELD catalogALTER TABLE prod.db.sample DROP PARTITION FIELD bucket(16, id)ALTER TABLE prod.db.sample DROP PARTITION FIELD truncate(data, 4)ALTER TABLE prod.db.sample DROP PARTITION FIELD years(ts)ALTER TABLE prod.db.sample DROP PARTITION FIELD shard

相关内容：

  1. 数据湖计算 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。...
  2. 数据湖计算 DLC ALTER TABLE DROP PARTITION ALTER TABLE table_name DROP [IF EXISTS] PARTITION (partition_spec) [,PARTITION (partition_spec), ...]partition_spec: : partition_column = partition_col_value, partition_column = partition_col_value, ...。...
  3. 数据湖计算 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]}[, ...]]。...
  4. 数据湖计算 DLC ALTER TABLE ADD PARTATION ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION (partition_spec) [PARTITION (partition_spec) ...]partition_spec: : partition_column = partition_col_value, partition_column = partition_col_value, ...。...
  5. 数据湖计算 DLC ALTER TABLE SET LOCATION ALTER TABLE table_name [ PARTITION (partition_spec) ] SET LOCATION 'new location'。...
  6. 数据湖计算 DLC ALTER TABLE ADD COLUMNS ALTER TABLE table_name [PARTITION (partition_col1_name = partition_col1_value [,partition_col2_name = partition_col2_value][,...])] ADD COLUMNS (col_name data_type) [RESTRICT | CASCADE]。...
  7. 数据湖计算 DLC ALTER TABLE … WRITE ORDERED BY ALTER TABLE table_identifier WRITE [LOCALLY] ORDERED BY {col_name [ASC|DESC] [NULLS FIRST|LAST]}[, ...]。...
  8. 数据湖计算 DLC ALTER TABLE SET TBLPROPERTIES ALTER TABLE table_name SET TBLPROPERTIES (property_name=property_value, ...)。...
赞 (0)
上一篇 4天前
下一篇 4天前