{
"job": {
"content": [{
"reader": {
"name": "mysqlreader",
"parameter": {
"column": [
"*"
],
"connection": [{
"querySql": [
"select aa.*,Year(aa.createTime) as applicationhistory_year,MONTH(aa.createTime) as applicationhistory_month,DAY(aa.createTime) as applicationhistory_day from ApplicationHistory aa limit 10;"
],
"jdbcUrl": [
"jdbc:mysql://172.16.10.114:3307/credit"
]
}],
"password": "8r155FdbSff3eGVNQwED",
"username": "bd_dev"
}
},
"writer": {
"name": "hdfswriter",
"parameter": {
"column": [{
"name": "applicationHistoryId",
"type": "INT"
},
{
"name": "auditingInfoId",
"type": "VARCHAR"
},
{
"name": "nodeState",
"type": "TINYINT"
},
{
"name": "optionId",
"type": "INT"
},
{
"name": "optionName",
"type": "VARCHAR"
},
{
"name": "createTime",
"type": "DATE"
},
{
"name": "reason",
"type": "VARCHAR"
},
{
"name": "remark",
"type": "VARCHAR"
},
{
"name": "dw_update_time",
"type": "DATE"
},
{
"name": "year",
"type": "string"
},
{
"name": "month",
"type": "string"
},
{
"name": "day",
"type": "string"
}
],
"defaultFS": "hdfs://172.20.11.180",
"fieldDelimiter": ",",
"fileName": "fz23",
"fileType": "text",
"path": "/apps/hive/warehouse/applicationhistory",
"writeMode": "append"
}
}
}],
"setting": {
"speed": {
"channel": "2"
}
}
}
}
datax的json范例
需积分: 42 69 浏览量
2018-08-26
17:50:57
上传
评论
收藏 142KB ZIP 举报
benjamin3721
- 粉丝: 3
- 资源: 7