1、datax代码
{
"setting": {},
"job": {
"setting": {
"speed": {
"channel": 2
}
},
"content": [
{
"reader": {
"name": "ftpreader",
"parameter": {
"protocol": "sftp",
"host": "192.168.127.128",
"port": 22,
"username": "root",
"password": "123456",
"path": [
"/root/test/test.txt"
],
"column": [
{
"index": 0,
"type": "String"
},
{
"index": 1,
"type": "String"
},{
"index": 2,
"type": "String"
}
],
"encoding": "UTF-8",
"fieldDelimiter": ","
}
},
"writer": {
"name": "ftpwriter",
"parameter": {
"protocol": "sftp",
"path": "/root/aa",
"host": "192.168.127.132",
"port": 22,
"username": "root",
"password": "123456",
"fileName": "time",
"writeMode": "truncate",
"format": "yyyy-MM-dd"
}
}
}
]
}
}
column:读取文件每列的值
**
2、sh文件
**
python /root/datax/bin/datax.py /root/json/sftp.json
3、定时
crontab -e
*/1 * * * * /root/time.sh
分 时 日 月 星期
上面代码是每分钟执行一次