1.只有一个分区,如year
alter table t_test_order drop partition (year>'2015',year<'2019')
2.有多个分区,如year、month、day
alter table t_test_order drop partition (year='2019',month<='201904')
1.只有一个分区,如year
alter table t_test_order drop partition (year>'2015',year<'2019')
2.有多个分区,如year、month、day
alter table t_test_order drop partition (year='2019',month<='201904')