start="2018-06-17"

end="2018-07-01"

min=`date -d "${start}" +%Y%m%d`

max=`date -d "${end}" +%Y%m%d`

[ -e /tmp/fd3 ] || mkfifo /tmp/fd3

exec <>/tmp/fd3

rm -rf /tmp/fd3

for ((i=;i<=;i++))

do

    echo >&

done

while [ $min -le $max ]

do

read -u5

date=${min}

echo "date:" ${date}

{

sql="

select * from table where day = ${date} ;"

echo "${sql}"

hive -e "${sql}" > output_${date}.txt

echo >&

}&

min=`date -d "1 day ${date}" +%Y%m%d`

done

wait

exec <&-

exec >&-