wlyy2.0/svr/svr-iot/sql-scripts/device_location_es.sql

创建索引
POST  http://172.26.0.190:9200/device_location_index

给索引加mapping
POST http://172.26.0.190:9200/device_location_index/device_location_type/_mapping
{
    "device_location_type": {
        "properties": {
            "categoryCode": {
                "type": "string",
                "index": "not_analyzed"
            },
            "createTime": {
                "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "deviceSn": {
                "type": "string",
                "index": "not_analyzed"
            },
            "deviceTime": {
                "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "idCard": {
                "type": "string",
                "index": "not_analyzed"
            },
            "location": {
                "type": "geo_point"
            }
        }
    }
}