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 '描述');