阿里云环境下,循环删除分区操作,通过pyodps实现:
我的分区字段是dt,类型是bigint
t = o.get_table('tmp_activity_push')
for a in range(20190501,20190530):
date = 'dt =' + str(a)
print(date)
t.delete_partition(date, if_exists=True) # 存在的时候才删除
//改进版
import datetime
def dateRange(beginDate, endDate):
dates = []
dt = datetime.datetime.strptime(beginDate, "%Y%m%d")
date = beginDate[:]
while date <= endDate:
dates.append(date)
dt = dt + datetime.timedelta(1)
date = dt.strftime("%Y%m%d")
return dates
t = o.get_table('main_recommend_style_feature_data_byday')
for a in dateRange('20210324','20210610'):
date = 'dt =' + str(a)
print(date)
t.delete_partition(date, if_exists=True) # 存在的时候才删除