#!/bin/sh start="20170831" end="20180208" while [[ ${start} -le ${end} ]];do echo ${start} sql="ALTER TABLE dwh.dm_install_list_v2 DROP IF EXISTS PARTITION (dt='${start}',business='adserver')" echo "${sql}" if [[ $? -ne 0 ]]; then exit 255 fi start=`date -d "1 day ${start}" +%Y%m%d` # 日期自增 done