添加分区
ALTER TABLE table_name ADD PARTITION (dt = '2020-08-08') LOCATION '/user/hadoop/warehouse/table_name/dt=2020-08-08';
一次添加多个分区
ALTER TABLE table_name ADD PARTITION (dt = '2020-08-08') LOCATION '/user/hadoop/warehouse/table_name/dt=2020-08-08' PARTITION (dt = '2020-08-09') LOCATION '/user/hadoop/warehouse/table_name/dt=2020-08-09';
修改分区名称
alter table table_name partition (dt='2020-09-02') rename to partition
(dt='2020-09-03');
修改分区位置
ALTER TABLE table_name (dt='2020-08-08') SET LOCATION "new location";
删除分区
alter table login DROP IF EXISTS PARTITION ();
ALTER TABLE page_view DROP IF EXISTS PARTITION (dt='20202-08-08', country='us');
修改表属性内部表,外部表
alter table table_name set TBLPROPERTIES ('EXTERNAL'='TRUE');
alter table table_name set TBLPROPERTIES ('EXTERNAL'='FALSE');
重命名表
alter table table_name rename to new_table_name;
增加一列
ALTER TABLE table_name ADD COLUMNS (col1 bigint COMMENT 'xx');
查看表的位置
desc formatted table_name
修改列名
ALTER TABLE table_name CHANGE old_col new_col bigint COMMENT 'xx';
删除某列
hive中不支持alter table table_name drop columns这种语法，试了replace也不行
