执行脚本

export HIVE_HOME=/opt/install/hive-1.2.2-bin

function insert_into_part(){

$HIV{E}_{H}OME/bin/hive-e"use\ast \ast \ast \ast \ast \ast \ast ;insertoverwritetable\ast \ast \ast \ast \ast \ast \ast partition(inser{t}_{t}ime{=}^{\prime }${DATA_Date}’)
select id ,
inserter ,
updater ,
update_time ,
place_type_code ,
krt_no ,
place_type ,
place_name ,
place_prov_code ,
place_prov_name ,
place_city_code ,
place_city_name ,
place_county_code ,
place_county_name ,
place_town_code ,
place_town_name ,
place_village_code ,
place_village_name ,
place_addr ,
place_lng ,
place_lat ,
relate_code ,
relate_name ,
name ,
idcard ,
phone ,
household_code ,
household_name ,
household_prov_code ,
household_prov_name ,
household_city_code ,
household_city_name ,
household_county_code ,
household_county_name ,
household_town_code ,
household_town_name ,
household_village_code ,
household_village_name ,
prov_code ,
prov_name ,
city_code ,
city_name ,
county_code ,
county_name ,
town_code ,
town_name ,
village_code ,
village_name ,
addr ,
addr_code ,
lng ,
lat ,
is_reached_hubei ,
is_touch_hubei ,
is_touch_patient ,
is_touch_fever ,
is_fever ,
is_focus ,
is_out_city ,
in_city_date ,
temp_status ,
temp ,
personnel_nature ,
live_type ,
certificates_type ,
current_location ,
landlord_name ,
landlord_phone ,
from_prov_code ,
from_prov_name ,
from_city_code ,
from_city_name ,
from_county_code ,
from_county_name ,
job_unit ,
profession ,
is_reached_abroad
from no_part_antiepidemicdata where insert_time>=’$DAT{A}_{D}ate00:00:00^{\prime }andinser{t}_{t}ime<{=}^{\prime }${DATA_Date} 23:59:59’;"

}

for i in 01 02 03 04 05 06 07 08 09 10 11 12;
do
for j in 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31;
do
DATE=$(date+"${i}28 +$jday")DAT{A}_{D}ate=${DATE}
insert_into_part DATA_Date
#echo $DATA_Date;
done
done