partitions.sh 1023 Bytes
Newer Older
wang-jinfeng committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
#!/usr/bin/env bash

# alter table dev.fe_event_core add if not exists partition(`day`='20190601',`hour`='18') location 's3://mob-emr-test/shun.yao/dsp_c_log_res/fe_event_core/20190601/18';

days="01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23"
# days="01"
hours="00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23"
# hours="00"
# hh="00 01 02 03 04 05 06 07 08 09"
# minute="00 15 30 45"

for day in ${days}
do
    for hour in ${hours}
    do
        # sql="alter table dev.fe_event_core add if not exists partition(\`day\`='201906${day}',\`hour\`='${hour}') location 's3://mob-emr-test/shun.yao/dsp_c_log_res/fe_event_core/201906${day}/${hour}';"
        sql="alter table dev.fe_event_error add if not exists partition(\`day\`='201906${day}',\`hour\`='${hour}') location 's3://mob-emr-test/shun.yao/dsp_c_log_res/fe_event_error/201906${day}/${hour}';"
        echo "${sql}"
        # hive -e "${sql}"
        if [[ $? -ne 0 ]];then
            exit 255
        fi
     done
done