06_update_everyday_feature.sh 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. #!/bin/sh
  2. set -ex
  3. # 0 全局变量/参数
  4. today="$(date +%Y%m%d)"
  5. today_early_1="$(date -d '1 days ago' +%Y%m%d)"
  6. HADOOP="/opt/apps/HADOOP-COMMON/hadoop-common-current/bin/hadoop"
  7. export SPARK_HOME=/opt/apps/SPARK2/spark-2.4.8-hadoop3.2-1.0.8
  8. export PATH=$SPARK_HOME/bin:$PATH
  9. export HADOOP_CONF_DIR=/etc/taihao-apps/hadoop-conf
  10. export JAVA_HOME=/usr/lib/jvm/java-1.8.0
  11. max_hour=11
  12. max_minute=00
  13. # 0 判断上游表是否生产完成,最长等待到12点
  14. source /root/anaconda3/bin/activate py37
  15. while true; do
  16. python_return_code=$(python utils.py --excute_program check_item_hive --partition ${today_early_1})
  17. if [ $python_return_code -eq 0 ]; then
  18. echo "Python程序返回0,退出循环。"
  19. break
  20. fi
  21. echo "Python程序返回非0值,等待五分钟后再次调用。"
  22. sleep 300
  23. current_hour=$(date +%H)
  24. current_minute=$(date +%M)
  25. if (( current_hour > max_hour || (current_hour == max_hour && current_minute >= max_minute) )); then
  26. echo "最长等待时间已到,失败:${current_hour}-${current_minute}"
  27. exit 1
  28. fi
  29. done
  30. conda deactivate
  31. # 1 item 生产数据
  32. /opt/apps/SPARK2/spark-2.4.8-hadoop3.2-1.0.8/bin/spark-class2 org.apache.spark.deploy.SparkSubmit \
  33. --class com.aliyun.odps.spark.examples.makedata.makedata_08_item2redis \
  34. --name makedata_08_item2redis_${today} \
  35. --master yarn --driver-memory 1G --executor-memory 1G --executor-cores 1 --num-executors 16 \
  36. /root/zhangbo/recommend-emr-dataprocess/target/spark-examples-1.0.0-SNAPSHOT-shaded.jar \
  37. date:${today_early_1} tablePart:32 expireDay:4 ifDebug:False \
  38. ifVideo:True ifWriteRedis:True savePathVideo:/dw/recommend/model/09_feature/video
  39. if [ $? -eq 1 ]; then
  40. echo "---------item写入redis执行失败---------"
  41. exit 1
  42. else
  43. echo "---------item写入redis执行成功---------"
  44. fi
  45. # 2 检查user上游表
  46. source /root/anaconda3/bin/activate py37
  47. while true; do
  48. python_return_code=$(python utils.py --excute_program check_user_hive --partition ${today_early_1})
  49. if [ $python_return_code -eq 0 ]; then
  50. echo "Python程序返回0,退出循环。"
  51. break
  52. fi
  53. echo "Python程序返回非0值,等待五分钟后再次调用。"
  54. sleep 300
  55. current_hour=$(date +%H)
  56. current_minute=$(date +%M)
  57. if (( current_hour > max_hour || (current_hour == max_hour && current_minute >= max_minute) )); then
  58. echo "最长等待时间已到,失败:${current_hour}-${current_minute}"
  59. exit 1
  60. fi
  61. done
  62. # 3 检查mid 时间,上游表
  63. while true; do
  64. python_return_code=$(python utils.py --excute_program check_hive --partition ${today_early_1} --project loghubods --table mid_uid)
  65. if [ $python_return_code -eq 0 ]; then
  66. echo "Python程序返回0,退出循环。上游表loghubods.mid_uid=${today_early_1} 已生产完毕"
  67. break
  68. fi
  69. echo "Python程序返回非0值,等待五分钟后再次调用。上游表loghubods.mid_uid=${today_early_1} 未完成"
  70. sleep 300
  71. current_hour=$(date +%H)
  72. current_minute=$(date +%M)
  73. if (( current_hour > max_hour || (current_hour == max_hour && current_minute >= max_minute) )); then
  74. echo "最长等待时间已到,失败:${current_hour}-${current_minute}"
  75. exit 1
  76. fi
  77. done
  78. conda deactivate
  79. # 4 user 生产数据
  80. #/opt/apps/SPARK2/spark-2.4.8-hadoop3.2-1.0.8/bin/spark-class2 org.apache.spark.deploy.SparkSubmit \
  81. #--class com.aliyun.odps.spark.examples.makedata.makedata_09_user2redis \
  82. #--name makedata_09_user2redis_${today} \
  83. #--master yarn --driver-memory 1G --executor-memory 4G --executor-cores 1 --num-executors 32 \
  84. #--conf spark.yarn.executor.memoryoverhead=1024 \
  85. #/root/zhangbo/recommend-emr-dataprocess/target/spark-examples-1.0.0-SNAPSHOT-shaded.jar \
  86. #date:${today_early_1} tablePart:32 expireDay:3 ifDebug:False \
  87. #ifUser:True ifDeleteRedisUser:False ifWriteRedisUser:True sampleRate:1.0 midDays:7 \
  88. #savePathUser:/dw/recommend/model/feature/user/
  89. /opt/apps/SPARK2/spark-2.4.8-hadoop3.2-1.0.8/bin/spark-class2 org.apache.spark.deploy.SparkSubmit \
  90. --class com.aliyun.odps.spark.examples.makedata.makedata_09_user2redis_freq \
  91. --name makedata_09_user2redis_freq \
  92. --master yarn --driver-memory 1G --executor-memory 4G --executor-cores 1 --num-executors 32 \
  93. --conf spark.yarn.executor.memoryoverhead=2024 \
  94. --conf spark.shuffle.service.enabled=true \
  95. --conf spark.shuffle.service.port=7337 \
  96. --conf spark.shuffle.consolidateFiles=true \
  97. --conf spark.shuffle.manager=sort \
  98. --conf spark.storage.memoryFraction=0.4 \
  99. --conf spark.shuffle.memoryFraction=0.5 \
  100. --conf spark.default.parallelism=400 \
  101. --conf spark.speculation=true \
  102. --conf spark.speculation.multiplier=10 \
  103. --conf spark.speculation.quantile=0.75 \
  104. --conf spark.network.timeout=120 \
  105. /root/zhangbo/recommend-emr-dataprocess/target/spark-examples-1.0.0-SNAPSHOT-shaded.jar \
  106. date:${today_early_1} tablePart:64 expireDay:3 ifWriteRedisUser:True ifUser:True midDays:14 redisLimit:100000000 \
  107. savePathUser:/dw/recommend/model/09_feature/user/
  108. if [ $? -eq 1 ]; then
  109. echo "---------user写入redis执行失败---------"
  110. exit 1
  111. else
  112. echo "---------user写入redis执行成功---------"
  113. fi
  114. #nohup sh 06_update_everyday_feature.sh > p6.log 2>&1 &