shell脚本循环遍历日期，用于sqoop脚本

#! /bin/bash

first="$1"

second="$2"

while [ "$first" != "$second" ]

do

date=`date -d "$first" +"%Y-%m-%d"`

sqoop export \

--connect jdbc:mysql:// \

--username \

--password \

--table dwd_fact_front_orderinfo \

--export-dir /user/hive/warehouse/dwd.db/dwd_fact_front_orderinfo/day="$date" \

--input-null-non-string '\\N' \

--input-null-string '\\N' \

--input-fields-terminated-by "\t" \

--update-key id \

--update-mode allowinsert \

--m 1;

let first=`date -d "-1 days ago ${first}" +%Y%m%d`

done