datax将mysql导入文本_Datax使用SQL语句数据导入

{

"job": {

"setting": {

"speed": {

"channel": 2

}

},

"content": [

{

"reader": {

"name": "mysqlreader",

"parameter": {

"username": "XXX",

"password": "XXX",

"connection": [

{

"querySql": [

"select id,name,times from tru where id > 10"

],

"jdbcUrl": [

"jdbc:mysql://localhost:3306/ada_test"

]

}

]

}

},

"writer": {

"name": "hdfswriter",

"parameter": {

"defaultFS": "hdfs://node002:8020",

"fileType": "text",

"path": "/apps/hive/warehouse/test.db/order",

"fileName": "incrementOrderData",

"column": [

{

"name": "id",

"type": "int"

},

{

"name": "name",

"type": "STRING"

},

{

"name": "times",

"type": "STRING"

}

],

"writeMode": "append",

"fieldDelimiter": "\t",

"compress":"NONE"

}

}

}

]

}

}