1、shell 脚本补数据
参数设置:
post_code=071000
database=stg_jinxiong
start_date="20220507"
end_date="20220507"
post_code=071000
while [ "$start_date" -le "$end_date" ];
do
dt=$(date -d "$start_date" +%Y-%m-%d)
echo $dt
yesterday=$(date -d "${dt} -1 day" +%Y-%m-%d)
week=$(date -d "${dt} -1 week" +%Y-%m-%d)
lastmonthday=$(date -d "${dt} -1 month" +%Y-%m-%d)
lastyearday=$(date -d "${dt} -1 year" +%Y-%m-%d)
echo "dt: $dt"
echo "week: $week"
echo "yesterday: $yesterday"
echo "lastmonthday: $lastmonthday"
echo "lastyearday: $lastyearday"
hive -e ""
start_date=$(date -d "$start_date+1days" +%Y%m%d)
done
说明:
支持下面这种格式的 shell 脚本
天表中的原有参数:
today=`date +%Y%m%d`
post_code=071000
dt=$(date -d "${today} -1 day" +%Y-%m-%d)
yesterday=$(date -d "${dt} -1 day" +%Y-%m-%d)
lastmonthday=$(date -d "${dt} -1 month" +%Y-%m-%d)
echo "dt: $dt"
echo "yesterday: $yesterday"
echo "lastmonthday: $lastmonthday"
lastyearday=$(date -d "${dt} -1 year" +%Y-%m-%d)
echo "lastyearday: $lastyearday"
week=$(date -d "${dt} -7 day" +%Y-%m-%d)
echo "week: $week"
database=stg_jinxiong