datax shell 脚本补数据

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