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'