mysql2hdfs.json:
{
"job": {
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"column": [
"id",
"name"
],
"connection": [
{
"jdbcUrl": [
"jdbc:mysql://192.168.1.71:3306/datax"
],
"table": [
"student"
]
}
],
"password": "111111",
"username": "root",
"where": ""
}
},
"writer": {
"name": "hdfswriter",
"parameter": {
"column": [
{
"name": "id",
"type": "int"
},
{
"name": "name"
"type": "string"
}
],
"compress": "",
"defaultFS": "hdfs://192.168.1.51:9000",
"fieldDelimiter": "\t",
"fileName": "student.txt",
"fileType": "text",
"path": "/user/hive",
"writeMode": "append"
}
}
}
],
"setting": {
"speed": {
"channel": "1"
}
}
}
}
mysql2hive.json
{
"job": {
"content": [{
"reader": {
"name": "mysqlreader",
"parameter": {
"column": [
"id",
"name"
],
"connection": [{
"jdbcUrl": [
"jdbc:mysql://192.168.1.71:3306/datax"
],
"table": [
"student"
]
}],
"password": "111111",
"username": "root",
"where": ""
}
},
"writer": {
"name": "hdfswriter",
"parameter": {
"column": [{
"name": "id",
"type": "INT"
},
{
"name": "name",
"type": "VARCHAR"
}
],
"compress": "NONE",
"defaultFS": "hdfs://192.168.1.51:9000",
"fieldDelimiter": "\t",
"encoding": "UTF-8",
"fileName": "student",
"fileType": "orc",
"path": "/user/hive/warehouse/test.db/student",
"writeMode": "append"
}
}
}],
"setting": {
"speed": {
"channel": "1"
}
}
}
}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/543979/viewspace-3009938/ ，如需转载，请注明出处，否则将追究法律责任。
