(1)添加列:
alter table [db.]table_name add column column_name [type] [default_expr] [after name_after]
type:类型
default_expr:默认值
after name_agter:把新列添加在指定列后面
(2)删除列:
alter table [db.]table_name drop column column_name
(3)修改列
alter table [db.]table_name modify column column_name [type] [default_expr]
(4)删除分区
alter table [db.]table drop partition 'partition_name'