#!/bin/sh set -ex # 原始数据table name table='alg_recsys_sample_all' # 处理分区配置 beginStr="$(date -d '1 days ago' +%Y%m%d)" endStr="$(date -d '1 days ago' +%Y%m%d)" beginHhStr=00 endHhStr=23 # 0 判断上游表是否生产完成,最长等待到12点 # shellcheck disable=SC2039 source /root/anaconda3/bin/activate py37 echo "----------step1------------开始校验是否生产完数据,分区信息:beginStr:${beginStr}${beginHhStr},endStr:${endStr}${endHhStr}" while true; do python_return_code=$(python checkHiveDataUtil.py --table ${table} --beginStr ${beginStr}${beginHhStr} --endStr ${endStr}${endHhStr}) echo "python 返回值:${python_return_code}" if [ $python_return_code -eq 0 ]; then echo "Python程序返回0,校验存在数据,退出循环。" break fi echo "Python程序返回非0值,不存在数据,等待五分钟后再次调用。" sleep 300 current_hour=$(date +%H) current_minute=$(date +%M) # shellcheck disable=SC2039 if (( current_hour > max_hour || (current_hour == max_hour && current_minute >= max_minute) )); then echo "最长等待时间已到,失败:${current_hour}-${current_minute}" exit 1 fi done # 1 生产原始数据 echo "----------step2------------开始根据${table}生产原始数据" /opt/apps/SPARK2/spark-2.4.8-hadoop3.2-1.0.8/bin/spark-class2 org.apache.spark.deploy.SparkSubmit \ --class com.aliyun.odps.spark.examples.makedata_qiao.makedata_13_originData_20240705 \ --master yarn --driver-memory 1G --executor-memory 2G --executor-cores 1 --num-executors 16 \ ./target/spark-examples-1.0.0-SNAPSHOT-shaded.jar \ tablePart:64 repartition:32 \ beginStr:${beginStr} endStr:${endStr} \ savePath:/dw/recommend/model/13_sample_data/ \ table:${table} if [ $? -ne 0 ]; then echo "Spark原始样本生产任务执行失败" exit 1 else echo "spark原始样本生产执行成功" fi # 2 特征值拼接 /opt/apps/SPARK2/spark-2.4.8-hadoop3.2-1.0.8/bin/spark-class2 org.apache.spark.deploy.SparkSubmit \ --class com.aliyun.odps.spark.examples.makedata_qiao.makedata_14_valueData_20240705 \ --master yarn --driver-memory 1G --executor-memory 3G --executor-cores 1 --num-executors 32 \ ./target/spark-examples-1.0.0-SNAPSHOT-shaded.jar \ readPath:/dw/recommend/model/13_sample_data/ \ savePath:/dw/recommend/model/14_feature_data/ \ beginStr:${beginStr} endStr:${endStr} repartition:1000 if [ $? -ne 0 ]; then echo "Spark特征值拼接处理任务执行失败" exit 1 else echo "spark特征值拼接处理执行成功" fi # 3 特征分桶 echo "----------step3------------根据特征分桶生产重打分特征数据" /opt/apps/SPARK2/spark-2.4.8-hadoop3.2-1.0.8/bin/spark-class2 org.apache.spark.deploy.SparkSubmit \ --class com.aliyun.odps.spark.examples.makedata_qiao.makedata_16_bucketData_20240705 \ --master yarn --driver-memory 2G --executor-memory 4G --executor-cores 1 --num-executors 16 \ ./target/spark-examples-1.0.0-SNAPSHOT-shaded.jar \ beginStr:${beginStr} endStr:${endStr} repartition:1000 if [ $? -ne 0 ]; then echo "Spark特征分桶处理任务执行失败" exit 1 else echo "spark特征分桶处理执行成功" fi