{ "job": { "setting": { "speed": { "channel":1 } }, "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "user", "password": "pass", "connection": [ { "querySql": [ "select id,keyword,scount,icount,created_at from `b`.`a`" ], "jdbcUrl": [ "jdbc:mysql://127.0.0.1/db" ] } ] } }, "writer": { "name": "elasticsearchwriter", "parameter": { "endpoint": "http://127.0.0.1:9200", "accessId": "1", "accessKey": "1", "index": "tip", "type": "_doc", "cleanup": false, "discovery": false, "batchSize": 1000, "splitter": ",", "dynamic": true, "column" : [ {"name": "id", "type": "id"}, {"name": "keyword", "type": "text", "analyzer": "888pic_pinyin"}, {"name": "scount", "type": "integer"}, {"name": "icount", "type": "integer"}, {"name": "created_at", "type": "date", "format": "yyyy-MM-dd HH:mm:ss"} ] } } } ] } }