shell脚本编写循环hive sql

循环里日期判断

if [ $# -eq 1 ]; then
     n_date=`date -d "$1" +"%Y-%m-%d"`
else
     n_date=`date -d " -1 days" +"%Y-%m-%d"`
fi
t_date=`date -d "${n_date} -6 days" +"%Y-%m-%d"`

until [ $t_date == $n_date ];do
#判断循环执行是否结束(以执行时间为昨天结束)

t_date=`date -d "${t_date} +1 days" +"%Y-%m-%d"`
echo "t_date ${t_date}"

hive <<END_HIVE
select 1
from tdanalytics.stg_td_web_page_ex
where starttime_day='${t_date}';
END_HIVE

done 

循环次数判断

if [ $# -eq 1 ]; then
     n_date=`date -d "$1" +"%Y-%m-%d"`
else
     n_date=`date -d " -1 days" +"%Y-%m-%d"`
fi
t_date=`date -d "${n_date} -6 days" +"%Y-%m-%d"`
count=0

until [ $count -eq '4' ];do
#判断循环次数是否满足

t_date=`date -d "${t_date} +1 days" +"%Y-%m-%d"`
let count+=1
echo "t_date ${t_date}"
echo "count ${count}"

hive -e "
select 1
from tdanalytics.stg_td_web_page_ex
where starttime_day='${t_date}';
"

done