es常用查询语句以及操作命令

es常用查询语句以及操作命令


下面整理记录下常用的es操作语句，方便查阅

1. 更新数据

 例1：增加字段值

 1 POST example/_update_by_query
 2 {
 3   "query": {
 4       "bool": {
 5         "must": [],
 6         "filter": [
 7           {
 8             "term": {
 9               "id": "84986808"
10             }
11           }
12         ]
13       }
14   },
15   "script":{
16     "source": "ctx._source['sort_time'] = 1645957516"
17   }
18 }

例2：更新指定的记录

 1 POST example/_update_by_query
 2 {
 3   "query": {
 4       "bool": {
 5         "must": [],
 6         "filter": [
 7           {
 8             "term": {
 9               "id": "14005923"
10             }
11           }
12         ]
13       }
14   },
15   "script":{
16     "source": "ctx._source['ext'] = '{\"on_duty\": 0,\"job_complete\": [{\"info\": [], \"label\": [775], \"occupation_id\": 39}], \"shumei_request_id\": \"8606a41366bbf6ac8838e732a2538804\", \"material_resources\": [], \"automatic_verify_tags\": [1, 2, 14, 20, 21]}'"
17   }
18 }

2. 删除数据

    例1：

 1 POST example/_delete_by_query
 2 {
 3   "query":{
 4     "terms": {
 5       "id": [
 6         "13966489"
 7       ]
 8     }
 9   }
10 }

    例2:

 1 POST example/_delete_by_query
 2 {
 3   "query":{
 4     "term": {
 5       "admin_user_id": {
 6         "value": "1543"
 7       }
 8     }
 9   }
10 }

 

3. 查询数据

     例1：条件筛选1

 1 GET example/_search
 2 {
 3   "query": {
 4     "term": {
 5       "admin_user_id": {
 6         "value": "1543"
 7       }
 8     }
 9   }
10 }

     例2：条件筛选2

 1 GET example/_search
 2 {
 3   "query": {
 4     "bool": {
 5       "must": [
 6         {
 7           "terms": {
 8             "expend_type": [
 9               "1",
10               "13"
11             ]
12           }
13         }
14       ],
15       "filter": [
16         {
17           "term": {
18             "target_id": "13991180"
19           }
20         }
21       ]
22     }
23   },
24   "_source": [
25     "id",
26     "target_id"
27   ],
28   "size": "2",
29   "sort": [
30     {
31       "id": "desc"
32     }
33   ]
34 }

    例3：条件筛选3

 1 GET example/_search
 2 {
 3   "query": {
 4       "bool": {
 5         "must": [],
 6         "filter": [
 7           {
 8             "term": {
 9               "complaint_id": "5891"
10             }
11           },
12           {
13             "term": {
14               "type": "1"
15             }
16           }
17         
18         ]
19       }
20   }
21 }

    例4：聚合查询

 1 GET  example/_search
 2 {
 3   "size":100,
 4   "query": {
 5     "bool": {
 6       "must": [
 7         {
 8           "terms": {
 9             "expend_type": [
10               1,
11               13
12             ]
13           }
14         }
15       ],
16       "filter": [
17         {
18           "term": {
19             "target_id": "13990899"
20           }
21         }
22       ]
23     }
24   },
25   "_source": [
26     "user_id"
27   ],
28   "aggs": {
29     "phone_count": {
30       "terms": {
31         "field": "user_id",
32         "size":20
33       }
34     }
35   }
36 }

 例5：对某字段折叠查询

 1 GET example/_search
 2 {
 3   "query": {
 4     "bool": {
 5       "must": [],
 6       "filter": [
 7         {
 8           "term": {
 9             "target_id": "14016237"
10           }
11         }
12       ]
13     }
14   },
15   "_source": [
16     "id",
17     "user_id",
18     "expend_type",
19     "@timestamp"
20   ],
21   "size": "15",
22   "collapse": {
23     "field": "user_id",
24     "inner_hits": {
25         "name": "expend_list",
26         "size":1,
27         "sort":[{"id":"asc"}]
28      }
29   },
30   "sort":[{"id":"desc"}]
31 }

 

posted @ 2023-01-14 11:05  欢乐豆123  阅读(1398)  评论(0)  编辑  收藏  举报