03_xgb_model_train_tmp.sh 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327
  1. #!/bin/sh
  2. set -x
  3. export PATH=$SPARK_HOME/bin:$PATH
  4. export HADOOP_CONF_DIR=/etc/taihao-apps/hadoop-conf
  5. export JAVA_HOME=/usr/lib/jvm/java-1.8.0
  6. sh_path=$(cd $(dirname $0); pwd)
  7. source ${sh_path}/00_common.sh
  8. source /root/anaconda3/bin/activate py37
  9. # 全局常量
  10. HADOOP=/opt/apps/HADOOP-COMMON/hadoop-common-current/bin/hadoop
  11. TRAIN_PATH=/dw/recommend/model/31_ad_sample_data_v4
  12. BUCKET_FEATURE_PATH=/dw/recommend/model/33_ad_train_data_v4
  13. TABLE=alg_recsys_ad_sample_all
  14. # 特征文件名
  15. feature_file=20240703_ad_feature_name.txt
  16. # 模型本地临时保存路径
  17. model_local_home=/root/zhaohp/XGB/
  18. # 模型HDFS保存路径,测试时修改为其他路径,避免影响线上
  19. MODEL_PATH=/dw/recommend/model/35_ad_model
  20. # 预测结果保存路径,测试时修改为其他路径,避免影响线上
  21. PREDICT_RESULT_SAVE_PATH=/dw/recommend/model/34_ad_predict_data
  22. # 模型OSS保存路径,测试时修改为其他路径,避免影响线上
  23. MODEL_OSS_PATH=oss://art-recommend.oss-cn-hangzhou.aliyuncs.com/zhangbo/
  24. # 线上模型名,测试时修改为其他模型名,避免影响线上
  25. model_name=model_xgb_351_1000_v2
  26. # 本地保存HDFS模型路径文件,测试时修改为其他模型名,避免影响线上
  27. model_path_file=${model_local_home}/online_model_path.txt
  28. # 获取当前是星期几,1表示星期一
  29. current_day_of_week="$(date +"%u")"
  30. # 任务开始时间
  31. start_time=$(date +%s)
  32. # 前一天
  33. today_early_1="$(date -d '1 days ago' +%Y%m%d)"
  34. # 线上模型在HDFS中的路径
  35. online_model_path=`cat ${model_path_file}`
  36. # 训练用的数据路径
  37. train_data_path=""
  38. # 评估用的数据路径
  39. predict_date_path=""
  40. #评估结果保存路径
  41. new_model_predict_result_path=""
  42. # 模型保存路径
  43. model_save_path=""
  44. # 评测结果保存路径,后续需要根据此文件评估是否要更新模型
  45. predict_analyse_file_path=""
  46. # 保存模型评估的分析结果
  47. old_incr_rate_avg=0
  48. new_incr_rate_avg=0
  49. top10_msg=""
  50. declare -A real_score_map
  51. declare -A old_score_map
  52. declare -A new_score_map
  53. # 校验命令的退出码
  54. check_run_status() {
  55. local status=$1
  56. local step_start_time=$2
  57. local step_name=$3
  58. local msg=$4
  59. local step_end_time=$(date +%s)
  60. local step_elapsed=$(($step_end_time - $step_start_time))
  61. if [ $status -ne 0 ]; then
  62. echo "$LOG_PREFIX -- ${step_name}失败: 耗时 $step_elapsed"
  63. local elapsed=$(($step_end_time - $start_time))
  64. /root/anaconda3/bin/python ${sh_path}/ad_monitor_util.py --level error --msg "$msg" --start "$start_time" --elapsed "$elapsed" --top10 "${top10_msg}"
  65. exit 1
  66. else
  67. echo "$LOG_PREFIX -- ${step_name}成功: 耗时 $step_elapsed"
  68. fi
  69. }
  70. send_success_upload_msg(){
  71. # 发送更新成功通知
  72. local msg=" 广告模型文件更新完成"
  73. msg+="\n\t - 老模型Top10差异平均值: ${old_incr_rate_avg}"
  74. msg+="\n\t - 新模型Top10差异平均值: ${new_incr_rate_avg}"
  75. msg+="\n\t - 模型在HDFS中的路径: ${model_save_path}"
  76. msg+="\n\t - 模型上传OSS中的路径: ${MODEL_OSS_PATH}/${model_name}.tar.gz"
  77. local step_end_time=$(date +%s)
  78. local elapsed=$(($step_end_time - $start_time))
  79. /root/anaconda3/bin/python ${sh_path}/ad_monitor_util.py --level info --msg "${msg}" --start "${start_time}" --elapsed "${elapsed}" --top10 "${top10_msg}"
  80. }
  81. init() {
  82. declare -a date_keys=()
  83. local count=1
  84. local current_data="$(date -d '2 days ago' +%Y%m%d)"
  85. # 循环获取前 n 天的非节日日期
  86. while [[ $count -lt 7 ]]; do
  87. date_key=$(date -d "$current_data" +%Y%m%d)
  88. # 判断是否是节日,并拼接训练数据路径
  89. if [ $(is_not_holidays $date_key) -eq 1 ]; then
  90. # 将 date_key 放入数组
  91. date_keys+=("$date_key")
  92. if [[ -z ${train_data_path} ]]; then
  93. train_data_path="${BUCKET_FEATURE_PATH}/${date_key}"
  94. else
  95. train_data_path="${BUCKET_FEATURE_PATH}/${date_key},${train_data_path}"
  96. fi
  97. count=$((count + 1))
  98. else
  99. echo "日期: ${date_key}是节日,跳过"
  100. fi
  101. current_data=$(date -d "$current_data -1 day" +%Y%m%d)
  102. done
  103. last_index=$((${#date_keys[@]} - 1))
  104. train_first_day=${date_keys[$last_index]}
  105. train_last_day=${date_keys[0]}
  106. model_save_path=${MODEL_PATH}/${model_name}_${train_first_day: -4}_${train_last_day: -4}
  107. predict_date_path=${BUCKET_FEATURE_PATH}/${today_early_1}
  108. new_model_predict_result_path=${PREDICT_RESULT_SAVE_PATH}/${today_early_1}_351_1000_${train_first_day: -4}_${train_last_day: -4}
  109. online_model_predict_result_path=${PREDICT_RESULT_SAVE_PATH}/${today_early_1}_351_1000_${online_model_path: -9}
  110. predict_analyse_file_path=${model_local_home}/predict_analyse_file/${today_early_1}_351_1000_analyse.txt
  111. echo "init param train_data_path: ${train_data_path}"
  112. echo "init param predict_date_path: ${predict_date_path}"
  113. echo "init param new_model_predict_result_path: ${new_model_predict_result_path}"
  114. echo "init param online_model_predict_result_path: ${online_model_predict_result_path}"
  115. echo "init param model_save_path: ${model_save_path}"
  116. echo "init param online_model_path: ${online_model_path}"
  117. echo "init param feature_file: ${feature_file}"
  118. echo "init param model_name: ${model_name}"
  119. echo "init param model_local_home: ${model_local_home}"
  120. echo "init param model_oss_path: ${MODEL_OSS_PATH}"
  121. echo "init param predict_analyse_file_path: ${predict_analyse_file_path}"
  122. echo "init param current_day_of_week: ${current_day_of_week}"
  123. echo "当前Python环境安装的Python版本: $(python --version)"
  124. echo "当前Python环境安装的三方包: $(python -m pip list)"
  125. }
  126. xgb_train() {
  127. local step_start_time=$(date +%s)
  128. /opt/apps/SPARK3/spark-3.3.1-hadoop3.2-1.0.5/bin/spark-class org.apache.spark.deploy.SparkSubmit \
  129. --class com.tzld.piaoquan.recommend.model.train_01_xgb_ad_20240808 \
  130. --master yarn --driver-memory 6G --executor-memory 9G --executor-cores 1 --num-executors 31 \
  131. --conf spark.yarn.executor.memoryoverhead=1000 \
  132. --conf spark.shuffle.service.enabled=true \
  133. --conf spark.shuffle.service.port=7337 \
  134. --conf spark.shuffle.consolidateFiles=true \
  135. --conf spark.shuffle.manager=sort \
  136. --conf spark.storage.memoryFraction=0.4 \
  137. --conf spark.shuffle.memoryFraction=0.5 \
  138. --conf spark.default.parallelism=200 \
  139. /root/zhangbo/recommend-model/recommend-model-produce/target/recommend-model-produce-jar-with-dependencies.jar \
  140. featureFile:20240703_ad_feature_name.txt \
  141. trainPath:${train_data_path} \
  142. testPath:${predict_date_path} \
  143. savePath:${new_model_predict_result_path} \
  144. modelPath:${model_save_path} \
  145. eta:0.01 gamma:0.0 max_depth:5 num_round:1000 num_worker:30 repartition:20
  146. local return_code=$?
  147. check_run_status $return_code $step_start_time "XGB模型训练任务" "XGB模型训练失败"
  148. }
  149. calc_model_predict() {
  150. local count=0
  151. local max_line=10
  152. local old_total_diff=0
  153. local new_total_diff=0
  154. top10_msg="| CID | 老模型相对真实CTCVR的变化 | 新模型相对真实CTCVR的变化 |"
  155. top10_msg+=" \n| ---- | --------- | -------- |"
  156. while read -r line && [ ${count} -lt ${max_line} ]; do
  157. # 使用 ! 取反判断,只有当行中不包含 "cid" 时才执行继续的逻辑
  158. if [[ "${line}" == *"cid"* ]]; then
  159. continue
  160. fi
  161. read -a numbers <<< "${line}"
  162. # 分数分别保存
  163. real_score_map[${numbers[0]}]=${numbers[3]}
  164. old_score_map[${numbers[0]}]=${numbers[6]}
  165. new_score_map[${numbers[0]}]=${numbers[7]}
  166. # 拼接Top10详情的飞书消息
  167. top10_msg="${top10_msg} \n| ${numbers[0]} | ${numbers[6]} | ${numbers[7]} | "
  168. old_total_diff=$( echo "${old_total_diff} + ${numbers[6]}" | bc -l )
  169. new_total_diff=$( echo "${new_total_diff} + ${numbers[7]}" | bc -l )
  170. count=$((${count} + 1))
  171. done < "${predict_analyse_file_path}"
  172. local return_code=$?
  173. check_run_status $return_code $step_start_time "计算Top10差异" "计算Top10差异异常"
  174. old_incr_rate_avg=$( echo "scale=6; ${old_total_diff} / ${count}" | bc -l )
  175. check_run_status $? $step_start_time "计算老模型Top10差异" "计算老模型Top10差异异常"
  176. new_incr_rate_avg=$( echo "scale=6; ${new_total_diff} / ${count}" | bc -l )
  177. check_run_status $? $step_start_time "计算新模型Top10差异" "计算新模型Top10差异异常"
  178. echo "老模型Top10差异平均值: ${old_incr_rate_avg}"
  179. echo "新模型Top10差异平均值: ${new_incr_rate_avg}"
  180. echo "新老模型分数对比: "
  181. for cid in "${!new_score_map[@]}"; do
  182. echo "\t CID: $cid, 老模型分数: ${old_score_map[$cid]}, 新模型分数: ${new_score_map[$cid]}"
  183. done
  184. }
  185. model_predict() {
  186. # 线上模型评估最新的数据
  187. local step_start_time=$(date +%s)
  188. /opt/apps/SPARK3/spark-3.3.1-hadoop3.2-1.0.5/bin/spark-class org.apache.spark.deploy.SparkSubmit \
  189. --class com.tzld.piaoquan.recommend.model.pred_01_xgb_ad_hdfsfile_20240813 \
  190. --master yarn --driver-memory 1G --executor-memory 3G --executor-cores 1 --num-executors 30 \
  191. --conf spark.yarn.executor.memoryoverhead=1024 \
  192. --conf spark.shuffle.service.enabled=true \
  193. --conf spark.shuffle.service.port=7337 \
  194. --conf spark.shuffle.consolidateFiles=true \
  195. --conf spark.shuffle.manager=sort \
  196. --conf spark.storage.memoryFraction=0.4 \
  197. --conf spark.shuffle.memoryFraction=0.5 \
  198. --conf spark.default.parallelism=200 \
  199. /root/zhangbo/recommend-model/recommend-model-produce/target/recommend-model-produce-jar-with-dependencies.jar \
  200. featureFile:20240703_ad_feature_name.txt \
  201. testPath:${predict_date_path} \
  202. savePath:${online_model_predict_result_path} \
  203. modelPath:${online_model_path}
  204. local return_code=$?
  205. check_run_status $return_code $step_start_time "线上模型评估${predict_date_path: -8}的数据" "线上模型评估${predict_date_path: -8}的数据失败"
  206. # 结果分析
  207. local python_return_code=$(python ${sh_path}/model_predict_analyse.py -p ${online_model_predict_result_path} ${new_model_predict_result_path} -f ${predict_analyse_file_path})
  208. check_run_status $python_return_code $step_start_time "分析线上模型评估${predict_date_path: -8}的数据" "分析线上模型评估${predict_date_path: -8}的数据失败"
  209. calc_model_predict
  210. if (( $(echo "${new_incr_rate_avg} > 0.100000" | bc -l ) ));then
  211. echo "线上模型评估${predict_date_path: -8}的数据,绝对误差大于0.1,请检查"
  212. check_run_status 1 $step_start_time "${predict_date_path: -8}的数据,绝对误差大于0.1" "线上模型评估${predict_date_path: -8}的数据,绝对误差大于0.1,请检查"
  213. exit 1
  214. fi
  215. # 对比两个模型的差异
  216. score_diff=$( echo "${new_incr_rate_avg} - ${old_incr_rate_avg}" | bc -l )
  217. if (( $(echo "${score_diff} > 0.050000" | bc -l ) ));then
  218. echo "两个模型评估${predict_date_path: -8}的数据,两个模型分数差异为: ${score_diff}, 大于0.05, 请检查"
  219. check_run_status 1 $step_start_time "两个模型评估${predict_date_path: -8}的数据" "两个模型评估${predict_date_path: -8}的数据,两个模型分数差异为: ${score_diff}, 大于0.05"
  220. exit 1
  221. fi
  222. }
  223. model_upload_oss() {
  224. local step_start_time=$(date +%s)
  225. (
  226. cd ${model_local_home}
  227. ${HADOOP} fs -get ${model_save_path} ${model_name}
  228. if [ ! -d ${model_name} ]; then
  229. echo "从HDFS下载模型失败"
  230. check_run_status 1 $step_start_time "HDFS下载模型任务" "HDFS下载模型失败"
  231. exit 1
  232. fi
  233. tar -czvf ${model_name}.tar.gz -C ${model_name} .
  234. rm -rf ${model_name}.tar.gz.crc
  235. ${HADOOP} fs -rm -r -skipTrash ${MODEL_OSS_PATH}/${model_name}.tar.gz
  236. ${HADOOP} fs -put ${model_name}.tar.gz ${MODEL_OSS_PATH}
  237. local return_code=$?
  238. check_run_status $return_code $step_start_time "模型上传OSS任务" "模型上传OSS失败"
  239. echo ${model_save_path} > ${model_path_file}
  240. rm -f ./${model_name}.tar.gz
  241. rm -rf ./${model_name}
  242. )
  243. local return_code=$?
  244. check_run_status $return_code $step_start_time "模型上传OSS任务" "模型上传OSS失败"
  245. local step_end_time=$(date +%s)
  246. local elapsed=$(($step_end_time - $start_time))
  247. echo -e "$LOG_PREFIX -- 模型更新完成 -- 模型更新成功: 耗时 $elapsed"
  248. send_success_upload_msg
  249. }
  250. # 主方法
  251. main() {
  252. init
  253. xgb_train
  254. model_predict
  255. # model_upload_oss
  256. }
  257. main