方式一:
1 delete from tablename where .........
2 alter table tablename drop partition partitionname;
delete 在数据量非常大的情况下 效率很低
方式二:
1 alter table tablename truncate partition partiotionname;
2 alter table tablename dropn partition partitionname;
ALTER
TABLE
tableName
DROP
PARTITION
partionName