recreate all partitions in hive table

loop_create_partitions.sh

start='2020-04-01'
end='2020-09-09'

start=$(date -d $start +%Y%m%d)
end=$(date -d $end +%Y%m%d)

iter=$start

while [[ $iter -le $end ]]
do
        echo $iter

        day=$(date -d "$iter" +%d)
        month=$(date -d "$iter" +%m)
        year=$(date -d "$iter" +%Y)

        echo $day
        echo $month
        echo $year

        hive -v -f create_partition_in_table.sql" \
        --hiveconf year=$year --hiveconf month=$month --hiveconf day=$day;

        iter=$(date -d "$iter + 1 day" +"%Y%m%d")

done