-- 删除库
drop database [if exists] db_name;
-- 强制删除库
drop database [if exists] db_name cascade;
-- 删除表
drop table [if exists] table_name;
-- 清空表,第二种方式
insert overwrite table_name select * from table_name where 1=0;
-- 删除分区
alter table table_name drop [if exists] partition (dt='2019-01-01');
alter table table_name drop [if exists] partition (dt>='2019-01');