1.新增分区:
ALTER TABLE
table_name
ADD PARTITION (dt
=
'
2016-09-12
'
);
2.删除分区:
ALTER TABLE login DROP IF EXISTS PARTITION (dt='2008-08-08');
3.复制表
CREATE TABLE IF NOT EXISTS table_name AS
(SELECT field1,field2 FROM table_name);
4.新增字段
ALTER TABLE
tableName ADD COLUMNS (field string COMMENT '描述');