dataX_from_hive指定列_text_to_mysql

angela_bigdata

已于 2022-12-28 17:55:12 修改

阅读量609

点赞数

于 2022-12-28 17:53:31 首次发布

本文链接：https://blog.csdn.net/wanglifengchao222/article/details/128472076

版权

dataX 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

{
"job": {
"setting": {
"speed": {
"channel": 3
}
},
"content":[
{
"reader":{
"name":"hdfsreader",
"parameter":{
"path":"/warehouse/tablespace/managed/hive/db.db/test/",
"defaultFS":"hdfs://abcd.ambari.com:8020",
"column":[
{"index":0,"name":"code", "type":"string"},
{"index":1,"name":"name", "type":"string"}
],
"nullFormat": "\\N",
"fileType":"text",
"encoding":"UTF-8",
"fieldDelimiter":"^"
}
},
"writer":{
"name":"mysqlwriter",
"parameter":{
"writeMode":"insert",
"username":"username",
"password":"password",
"column":[
"bianma", "name"
],
"preSql":[
"truncate table test"
],
"connection":[
{
"jdbcUrl":"jdbc:mysql://dafdfad.fdafd.com:3306/databasedb?characterEncoding=UTF-8",
"table":[
"test"
]
}
]
}
}
}
]
}
}