脚本刷新物化视图

#!/bin/bash
export PATH=/opt/Kingbase/ES/V9/bin:$PATH
export PGHOME=/opt/Kingbase/ES/V9
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH

# 刷新物化视图
ksql -U system -d risk_db <<EOF
REFRESH MATERIALIZED VIEW risk_features_mv;
EOF

# 日志记录
echo "$(date '+%Y-%m-%d %H:%M:%S') - MV refreshed" >> /var/log/risk_refresh.log

配置 Cron 定时任务 1. 编辑当前用户的 crontab* * * * * /home/kingbase/scripts/refresh_mv.sh