python bin/datax.py -p "-Dstarttime='2018-01-15 00:00:00' -Dendtime='2018-01-15 23:59:59' -Ddays='2018-01-15' " ../job/writemysql1.json
{
"job": {
"setting": {
"speed": {
"channel": 1
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "123456",
"connection": [
{
"querySql": [
"SELECT DATE(update_time) as count_time,judge_id ,distinguish_status,count(*)as number FROM t_greylist WHERE update_time>'$starttime' and update_time<'$endtime' GROUP BY judge_id,distinguish_status;"
],
"jdbcUrl": [
"jdbc:mysql://192.168.2.63:3306/rg_web3_1"
]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "root",
"password": "123456",
"column": [
"count_time",
"judge_id",
"judge_type",
"judge_type_count"
],
"session": [
"set session sql_mode='ANSI'"
],
"preSql": [
"delete from fact_greylist_analysis_count where count_time='$days' "
],
"connection": [
{
"jdbcUrl": "jdbc:mysql://192.168.2.63:3306/rg_web3_1?useUnicode=true&characterEncoding=utf8",
"table": [
"fact_greylist_analysis_count"
]
}
]
}
}
}
]
}
}