es相关DSL语句记录

es 6.0官方文档（包含增删查改）：https://www.elastic.co/guide/en/elasticsearch/reference/6.0/docs.html

GET /pi/event/_search
{
  "size": 0,
  "query" : {
    "bool": {
      "must":[
           {"match_phrase":{"userId": ${userId}}},
       <#if keyword == "">
           {"match_all": {}}
       <#else>  
           {"query_string":{
                "default_field": "_all",
                "query": "${keyword}"
              }
           }
       </#if>
      ],
      "filter": {
            "range":{
                "validataTimeSeconds":{
                    "gte" : ${gte_val}, 
                    "lte" : ${lte_val}
                }
            }
        }
    }
  },
  "aggs":{
        "by_time":{
            "date_histogram":{
                "field":"validataTimeSeconds",
                "interval":${interval},
                "extended_bounds":{
                    "min":${gte_val},
                    "max":${lte_val}
                }
            },
            "aggs":{
                "status":{
                    "terms":{
                        "field":"status.keyword"
                    }
                }
            }
        }
    }
}

GET pi/event/_search
{
  "size":0,
  "query":{
    "bool": {
      "must":[
       {"match":{"view.alarmId": "7"}}
      ]
    }
  },
  "post_filter" : {
    "range" : {
      "validataTimeSeconds" : {
        "gte" : 1499654928, 
        "lte" : 1499655320
      }
    }
  },
  "aggs":{
    "by_time": {
      "date_histogram" : {
        "field" : "validataTimeSeconds",
        "interval" : "100ms",
        "extended_bounds":{
          "min" : 1499654928,
          "max" : 1499655320
        }
      },
      "aggs":{
        "event_status_group": {
          "filters": {
            "filters": {
              "NODATA":{
                "match_phrase":{
                  "status":-1
                }
              },
              "ALERT":{
                "match_phrase":{
                  "status":0
                }
              },
              "OK": {
                "match_phrase":{
                  "status":1
                }
              }
            }
          }
        }
      }
    }
  }
}

GET /pi/event/_search
{
  "size": 1000, 
  "_source": {
    "include": [
      "validataTimeSeconds",
      "validataDate",
      "status",
      "alarmId",
      "host"
    ]
  },
  "sort": [
    {
      "validataTimeSeconds": {
        "order": "asc"
      }
    },
    {
      "host.keyword": {
        "order": "asc"
      }
    }
  ], 
  "query": {
    "bool": {
      "must": [
        {
          "match_phrase": {
            "userId": ${userId}
          }
        }
      ],
      "filter": {
        "range": {
          "validataTimeSeconds":{
              "gte":${gte_val},
              "lte":${lte_val}
          }
        }
      }
    }
  },
  "aggs": {
    "host_event_count": {
      "terms": {
        "field": "host.keyword"
      }
    }
  }
}

GET /pi/event/_search
{
  "from": ${page},
  "size": ${size},
  <#if keyword == "">
       "sort" :[{ "validataTimeSeconds" : {"order" : "desc"}}],
  <#else>  
       "sort" :["_score"],
  </#if>
  "query" : {
    "bool": {
      "must":[
       {"match_phrase":{"userId": ${userId}}},
       <#if alarmId != "">
           {"match_phrase":{"alarmId": ${alarmId}}},
       </#if>
       <#if status != "">
           {"match_phrase":{"status.keyword": ${status}}},
       </#if>
       <#if keyword == "">
           {"match_all": {}}
       <#else>  
           {
              "query_string":{
                "default_field": "_all",
                "query": "${keyword}"
              }
           }
       </#if>
      ],
      "filter": {
            "range":{
                "validataTimeSeconds":{
                    "gte" : ${gte_val}, 
                    "lte" : ${lte_val}
                }
            }
        }
    }
  }
}

scroll 分页

GET /pi/event/_search?scroll=1m&size=1000
{
  "_source": {
    "include": [
      "validataTimeSeconds"
    ]
  },
  "sort": [
    {
      "validataTimeSeconds": {
        "order": "asc"
      }
    },
    {
      "host.keyword": {
        "order": "asc"
      }
    }
  ], 
  "query": {
    "bool": {
      "must": [
        {
          "match_phrase": {
            "userId": 1
          }
        },
        {
          "match_phrase": {
            "alarmId": 32
          }
        }
      ],
      "filter": {
        "range": {
          "validataTimeSeconds":{
              "gte":1502084909,
              "lte":1502171309
          }
        }
      }
    }
  },
  "aggs": {
    "host_event_count": {
      "terms": {
        "field": "host.keyword"
      }
    }
  }
}


GET /_search/scroll
{
  "scroll":"1m",
  "scroll_id":"DnF1ZXJ5VGhlbkZldGNoBQAAAAAAALjaFkwtQllyZHIzVEtLMTd6TkRYTTF2VEEAAAAAAAC43BZMLUJZcmRyM1RLSzE3ek5EWE0xdlRBAAAAAAAAuNgWTC1CWXJkcjNUS0sxN3pORFhNMXZUQQAAAAAAALjZFkwtQllyZHIzVEtLMTd6TkRYTTF2VEEAAAAAAAC42xZMLUJZcmRyM1RLSzE3ek5EWE0xdlRB"
}

GET sun/search/_search
{ 
  "sort": { "_score": { "order": "desc" }},
  "query": {
        "bool":{
            "must":[
                     {"match": {"platId": "10002"}  },
                     {
                    "multi_match" : {
                      "query":    "武汉****", 
                      "fields": [ "userName", "expectJob","expectAddress","address","selfEvaluation","educationList.university","workExpList.company" ] 
                    }
                  }
            ]
        }


  }
}

GET sun/search/_search
{
    "_source": {
        "includes": [
            "extraData",
            "seekerId",
            "resumeId",
            "downloadFlag"
        ]
    },
    "query": {
        "bool": {
            "must": [
                {
                    "match": {
                        "platId": "10001"
                    }
                }
            ]
        }
    }
}

update字段name的内容：

POST /megacorp/employee/1/_update
{
    "doc" : {
        "name": "new_name_nam"
    }
}

根据查询条件删除：

POST megacorp/_delete_by_query
{
  "query": { 
    "match": {
      "first_name": "Douglas5555"
    }
  }
}