date=`date -d "-1 day" +%F`
spark-submit \
--name "suanfa_zjk_tyc_tjy_export" \
--master yarn \
--deploy-mode cluster \
--driver-memory 3G \
--executor-memory 3G \
--executor-cores 3 \
--num-executors 6 \
--queue batch \
--class com.*****.mysql.CrmApp2mysql \
ossref://bigdata-shell/bigdata_code/******.jar 'datamaslk' "***" "jdbc:mysql://rm-********387s.mysql.rds.aliyuncs.com:3306/databasename?serverTimezone=Asia/Shanghai&tinyInt1isBit=false&characterEncoding=gbk" "select * from ads.*** where dt = '$date'" 'Overwrite' '******_export'
