Data Lake Compute
- Getting Started
- Operation Guide
- Console Operation Introduction
- Data Development and Exploration
- Data Exploration
- Data Query Task
- Resource Management
- Engine Management
- SuperSQL Engine
- Standard Engine
- Resource Group
- Private Connection
- Storage Configuration
- Ops Management
- Insight Management
- System Management
- User and Permission Management
- Monitoring and Alarms
- Development Guide
- System Restraints
- Client Access
- JDBC Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Unified Statement
- DDL Statement
- ALTER TABLE
- DML Statement
- DQL Statement
- Iceberg Table Statement
- API Documentation
- Making API Requests
- Data Table APIs
- Task APIs
- Metadata APIs
- Service Configuration APIs
- Permission Management APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- General Reference
- Operation Guide on Connecting Third-Party Software to DLC
DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER TABLEALTER TABLE DROP PARTITION FIELD
ALTER TABLE DROP PARTITION FIELD
Last updated: 2024-08-07 17:17:00
Description
Supported engines: Presto and SparkSQL
Applicable table: Native Iceberg tables and external tables
Purpose: Delete a partition field of a data table.
Standard Statement
ALTER TABLE table_name ADD PARTITION partition_column | hidden_partition_spechidden_partition_spec:Supported transformations are:years(ts): partition by yearmonths(ts): partition by monthdays(ts) or date(ts): equivalent to dateint partitioninghours(ts) or date_hour(ts): equivalent to dateint and hour partitioningbucket(N, col): partition by hashed value mod N bucketstruncate(L, col): partition by value truncated to LStrings are truncated to the given lengthIntegers and longs truncate to bins: truncate(10, i) produces partitions 0, 10, 20, 30, …
Parameter Description
table_name: Name of the target tablepartition_column: Partitioning column.Example
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
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No