odps数据格式mysql_Datax实现odps和mysql之间数据传输

一、 mysql的数据加载到odps的表中

{

“job”: {

“setting”: {

“speed”: {“byte”: 1048576}

},

“content”: [

{

“reader”: {

“name”: “mysqlreader”,

“parameter”: {

“column”: [

“id”,

“name”,

“password”,

“position”

],

“connection”: [

{

“jdbcUrl”: [“jdbc:mysql://localhost:3306/test”],

“table”: [“user”]

}

],

“password”: “123456”,

“username”: “root”

}

},

“writer”: {

“name”: “odpswriter”,

“parameter”: {

“project”: “project_name”,

“table”: “userwrite”,

“column”: [“id”, “name”,“password”,“position”],

“accessId”: “",

“accessKey”: “************",

“truncate”: true,

“odpsServer”: "http