testmysqltoelasticsearch72.json 微测试，仅参考

{
    "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"}
                        ]
                    }
                }
            }
        ]
    }
}