200G表数据删除;
删除优先级:
分区/id/其他字段;
尽量按照分区删除而不是id;
alter table url_day drop partition p201804;
alter table url_day drop partition p201805;
alter table url_day drop partition p201806;
alter table url_day drop partition p201807;
分区删除
200G表数据删除;
删除优先级:
分区/id/其他字段;
尽量按照分区删除而不是id;
alter table url_day drop partition p201804;
alter table url_day drop partition p201805;
alter table url_day drop partition p201806;
alter table url_day drop partition p201807;
分区删除