博客

删除库

drop database if exists db_name;

强制删除库

drop database if exists db_name cascade;

删除表

drop table if exists employee;

清空表

truncate table employee;

清空表，第二种方式

insert overwrite table employee select * from employee where 1=0; 

删除分区

alter table employee_table drop partition (stat_year_month>='2018-01');

按条件删除数据

insert overwrite table employee_table select * from employee_table where id>'180203a15f';