ecs mysql,迁移ECS自建MySQL数据库至MaxCompute

{

"type": "job",

"steps": [

{

"stepType": "mysql",

"parameter": {

"column": [//源列名

"create_time",

"category",

"brand",

"buyer_id",

"trans_num",

"trans_amount",

"click_cnt"

],

"connection": [

{

"datasource": "shuai",//源数据源

"table": [

"good_sale"//源数据库表名，此处必须为方括号数组格式。

]

}

],

"where": "",

"splitPk": "",

"encoding": "UTF-8"

},

"name": "Reader",

"category": "reader"

},

{

"stepType": "odps",

"parameter": {

"partition": "",

"truncate": true,

"datasource": "odps_first",//目标数据源

"column": [//目标列名

"create_time",

"category",

"brand",

"buyer_id",

"trans_num",

"trans_amount",

"click_cnt"

],

"emptyAsNull": false,

"table": "good_sale"//目标表名

},

"name": "Writer",

"category": "writer"

}

],

"version": "2.0",

"order": {

"hops": [

{

"from": "Reader",

"to": "Writer"

}

]

},

"setting": {

"errorLimit": {

"record": "0"

},

"speed": {

"throttle": false,

"concurrent": 2

}

}

}