[大数据]Hive SQL基本操作

添加分区

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也不行