shell脚本导入中间文件（处理长脚本sql)

!/bin/bash

COMMON_PATH=data/test_hive/common.sh
v_job_stat=0
name_path =/data
select_str=cat ${name_path}/install.sql

for n in {1…365…1} do let YYYYMMDD= ( d a t e + (date +%Y%m%d -d " (date+{n} days ago")

hql=“insert overwrite table dataintel_dw.dwd_tmp partition(dayno=${YYYYMMDD})
SELECT imei ${select_str}
from dataintel_tmp.hcx_install_cnt_map
;
"
echo ( d a t e + (date +%Y-%m-%d:%T) " (date+hql”
ExecuteHQLIntentionRecog “${hql}”
v_job_stat=expr ${v_job_stat} + $?

done – 步长for循环

#########################################################################
#返回作业执行状态码
#########################################################################
echo “v_job_stat = ${v_job_stat}”
exit ${v_job_stat}

########################################################## 方法内嵌
#function ExecuteHQL(){

/usr/local/share/hive/bin/beeline --color=true --showHeader=true --outputformat=tsv2 -n dataintel -p c2248Br9ERs51RQY -u “jdbc:hive2://bj1240:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=com-hive” -e “$1”

#}
##重定向 时间
###echo $(date +%Y-%m-%d:%T) $(date +%Y%m%d)