ADD COLUMNS
Function
The ADD COLUMNS command is used to add a column to an existing table.
Syntax
ALTER TABLE Table name ADD COLUMNS(col_spec[, col_spec ...])
Parameter Description
Parameter |
Description |
---|---|
tableName |
Table name. |
col_spec |
Column specifications, consisting of four fields, col_name, col_type, nullable, and comment.
|
Required Permissions
- SQL permissions
Permission Description |
---|
ALTER permission on a table |
- Fine-grained permission: dli:table:alter
- Metadata services provided by LakeFormation. Refer to the LakeFormation documentation for details on permission configuration.
Example
alter table h0 add columns(ext0 string); alter table h0 add columns(new_col int comment 'add new column'); alter table delta.`obs://bucket_name0/db0/delta_table0` add columns(new_col string);
Response
You can run the DESCRIBE command to view the new column.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot