{
"order": {
"hops": [
{
"from": "Reader",
"to": "Writer"
}
]
},
"setting": {
"errorLimit": {
"record": "10"
},
"speed": {
"concurrent": 1,
"throttle": false
}
},
"steps": [
{
"category": "reader",
"name": "Reader",
"parameter": {
"column": [
"id",
"name",
"sex",
"birth",
"department",
"address"
],
"connection": [
{
"datasource": "zl_test_rdsmysql",
"querysql": [
"SELECT student.id,name,sex,birth,department,address,c_name,grade FROM student JOIN score on student.id=score.stu_id;"
],
"table": [
"score"
]
}
],
"encoding": "UTF-8",
"splitPk": "",
"where": ""
},
"stepType": "mysql"
},
{
"category": "writer",
"name": "Writer",
"parameter": {
"batchSize": 1000,
"cleanup": true,
"column": [
{
"name": "student_id",
"type": "id"
},
{
"name": "sex",
"type": "text"
},
{
"name": "name",
"type": "text"
},
{
"name": "birth",
"type": "integer"
},
{
"name": "quyu",
"type": "text"
},
{
"name": "address",
"type": "text"
},
{
"name": "cname",
"type": "text"
},
{
"name": "grades",
"type": "integer"
}
],
"datasource": "ES_data_source",
"discovery": false,
"index": "mysqljoin",
"indexType": "_doc",
"splitter": ","
},
"stepType": "elasticsearch"
}
],
"type": "job",
"version": "2.0"
}