使用Datax将mySql数据同步到ES，问题总结

1、ES的mapping包含主键id，引也会包含_id。

如果需要_id的值和主键id一直 ，需要在reader的querysql里面查询 id as _id，在writer的column里面设置_id，如下图

        "reader": {
          "name": "mysqlreader",
          "parameter": {
            "username": "root",
            "password": "xxxx",
            "connection": [
              {
                "querySql": [
                  "select id as _id ,`id`, `name`  from table where  id ='1696750771921267' "
                ],
                "jdbcUrl": [
                  "jdbc:mysql:xxxxxxx"
                ]
              }
            ],
            "sliceRecordCount": 100000
          }
        },
        "writer": {
          "name": "elasticsearchwriter",
          "parameter": {
            "endpoint": "xxxxxx:9200",
            "accessId": "xxxxx",
            "accessKey": "xxxx",
            "index": "index_xxxx_1",
            "cleanup": false,
            "dynamic": true,
            "discovery": false,
            "batchSize": 1000,
            "column": [
              {
                "name": "_id",
                "type": "id"
              },
              {
                "name": "id",
                "type": "text"
              },
              {
                "name": "name",
                "type": "text"
              },
.........