es查询相关

 

 

1.in查询

curl -H "Content-Type: application/json" -XPOST 'http://192.168.1.135:19200/metric_pl/_count?pretty' -d '
{
    "query" : {
        "constant_score" : {
            "filter" : {
                "terms" : { 
                    "month" : ["2022-03-30", "2022-03-31"]
                }
            }
        }
    }
}'

 

2.匹配查询

curl -H "Content-Type: application/json" -XPOST 'http://192.168.1.135:19200/metric_pl/_count?pretty' -d '
{
"query": { "match": {"rt": "777"} }
}'

 

3.查询后更新

curl -H "Content-Type: application/json" -XPOST 'http://192.168.1.135:19200/metric_pl/_update_by_query?pretty' -d '
{
"query": { "match": {"month": "2022-03-25"} },
"script": {
        "source": "ctx._source.rt =777"
    }
}'

 

curl -H "Content-Type: application/json" -XPOST 'http://192.168.1.135:19200/metric_pl/_update_by_query?pretty' -d '
{
"query" : {"range" : {"id" : {"gte" : 1,"lte"  : 50000000}}},
"script": {
        "source": "ctx._source.rt =777"
    }
}

 

4.查询所有

curl -H "Content-Type: application/json" -XPOST 'http://192.168.1.135:19200/metric_pl/_count?pretty' -d '
{
"query": { "match_all": {} }
}'

 

 

5.字段组合查询

id>= and id <=  and pass_qps=

curl -H "Content-Type: application/json" -XPOST 'http://192.168.1.135:19200/metric_pl/_search?pretty' -d '
{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "id": {
              "gte": 1,
              "lte": 100
            }
          }
        },
        {
          "term": {
            "pass_qps": 399
          }
        }
      ]
    }
  }
}'

 

6.查询所有，默认返回10条

curl -u elastic:elastic -H "Content-Type: application/json" -XPOST '192.168.1.134:19200/metric_pl/_search?pretty' -d '
{
"query": { "match_all": {} }
}'