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 ADD COLUMNS
ALTER TABLE ADD COLUMNS
Last updated: 2024-08-07 17:14:57
Description
Supported engines: Presto and SparkSQL
Applicable table: Native Iceberg tables and external tables
Purpose: Change data table attributes.
Standard Statement
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]
Parameter
table_name: Name of the target tablepartition_col1_name: Partitioning column namepartition_col1_value: Partitioning column valuecol_name: Name of the column to be added.data_type: Type of the column to be added.Example
ALTER TABLE events ADD COLUMNS (eventowner string);ALTER TABLE events ADD COLUMNS (eventowner string) CASCADE;//The ALTER TABLE PARTITION ADD COLUMNS statement supports only native DLC tables.ALTER TABLE events PARTITION (year='2021') ADD COLUMNS (event string);
Caution
If you use the
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' format during table creation, you cannot add columns after the table is created. If you use JsonSerDe to create a table, confirm the table structure if possible. If you must add columns, you can delete the existing table and create a new one.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No