elasticsearch7.x kibana的常用DSL（自己练习的）

妖狐艹你老母 2022-09-10 00:24 192阅读 0赞

GET bank/_mapping
    
    GET bank/_search
    
    GET bank/_search
    {
      "aggs": {
        "age_group": {
          "range": {
            "field": "age",
            "ranges": [
              {
                "from": 20,
                "to": 29
              },
               {
                "from": 30,
                "to": 39
              },
              {
                "from": 40,
                "to": 49
              }
            ]
          }, 
          "aggs": {
            "gender_group": {
              "terms": {
                "field": "gender.keyword"
              },
              "aggs": {
                "balance_avg": {
                  "avg": {
                    "field": "balance"
                  }
                }
              }
            }
          }
        }
          
      },
      "size": 0
    }
    
    
    
    GET bank/_search
    {
      "aggs": {
        "state_group": {
          "terms": {
            "field": "state.keyword",
            "order": {
              "balance_avg": "asc"
            }
          },
          "aggs": {
            "balance_avg": {
              "avg": {
                "field": "balance"
              }
            }
          }
        }
      },
      "size": 0
    }
    
    
    
    GET bank/_search
    {
      "aggs": {
        "state_group": {
          "terms": {
            "field": "state.keyword"
          },
          "aggs": {
            "balance_avg": {
              "avg": {
                "field": "balance"
              }
            }
          }
        }
      },
      "size": 0
    }
    
    
    
    GET bank/_search
    {
      "aggs": {
        "state_group": {
          "terms": {
            "field": "state.keyword"
          }
        }
        
      },
      "size": 0
    }
    
    
    
    GET bank/_search
    {
      "query": {
        "bool": {
          "must": [
            {
              "range": {
               "balance": {
                "gte": 20000,
                "lte": 30000
          }
              }
            }
          ]
        }
      },
      "sort": [
        {
          "balance": {
            "order": "desc"
          }
        }
      ]
      
    }
    
    
    
    GET bank/_search
    {
      "query": {
        "range": {
          "balance": {
            "gte": 20000,
            "lte": 30000
          }
        }
      },
      "sort": [
        {
          "balance": {
            "order": "desc"
          }
        }
      ]
      
    }
    
    
    
    
    GET bank/_search
    {
      "query": {
        "bool": {
          "must": [
            {
              "match": {
                "age": 40
              }
            }
          ], 
          "must_not": [
            {
              "match": {
                "state": "ID"
              }
            }
          ]
        }
      }
    }
    
    
    GET bank/_search
    {
      "query": {
        "bool": {
          "must_not": [
            {
              "match": {
                "address": "mill"
              }
            },
            {
               "match": {
                "address": "lane"
              }
            }
          ]
        }
      }
    }
    
    
    GET bank/_search
    {
      "query": {
        "bool": {
          "must": [
            {
              "match": {
                "address": "mill"
              }
            },
            {
               "match": {
                "address": "lane"
              }
            }
          ]
        }
      }
    }
    
    
    GET bank/_search
    {
      "query": {
        "match_phrase": {
          "address": "mill lane"
        }
      }
    }
    
    
    GET bank/_search
    {
      "query": {
        "bool": {
          "should": [
            {
              "match": {
                "address": "mile"
              }
            },
             {
              "match": {
                "address": "lane"
              }
            }
          ]
        }
      }
    }
    
    
    GET bank/_search
    {
      "query": {
        "match": {
          "address": "mill lane"
        }
      }
    }
    
    
    GET bank/_search
    {
      "query": {
        "match": {
          "address": "mill"
        }
      }
    }
    
    GET bank/_search?q=account_number:20
    
    GET bank/_search
    {
      "query": {
        "match": {
          "account_number": "20"
        }
      }
    }
    GET bank/_search
    {
      "query": {
        "bool": {
          "must": [
            {
              "match": {
                "account_number": 20
              }
            }
          ]
        }
      }
    }
    
    GET /bank/_search
    {
      "query": {
        "match_all": {}
      },
      "_source": ["account_number","balance"]
    }
    
    
    GET bank/_search
    {
      "query": {
        "match_all": {}
        
      },
      "sort": [
        {
          "balance": {
            "order": "desc"
          }
        }
      ],
      "size": 10
    }
    
    
    POST bank/_update/1
    {
      "script":"ctx._source.age+=5"
    }
    
    GET bank/_doc/1
    
    POST my_index/_doc
    {
      "productName":"雪花啤酒100L"
    }
    
    GET my_index/_search
    {
      "query": {
        "match": {
          "productName": "xh"
        }
      }
    }
    
    
    PUT /my_index/_mapping
    {
      "properties":{
        "productName":{
          "type":"text",
          "analyzer":"ik_pinyin_analyzer",
          "search_analyzer":"ik_pingying_smark"
        }
      }
    }
    
    PUT my_index
    {
      "settings": {
        "analysis": {
          "analyzer": {
            "ik_pinyin_analyzer": {
              "type": "custom",
              "tokenizer": "ik_smart",
              "filter": [
                "pinyin_max_word_filter"
              ]
            },
            "ik_pingying_smark": {
              "type": "custom",
              "tokenizer": "ik_smart",
              "filter": [
                "pinyin_smark_word_filter"
              ]
            }
          },
          "filter": {
            "pinyin_max_word_filter": {
              "type": "pinyin",
              "keep_full_pinyin": "true", 
              "keep_separate_first_letter": "true",
              "keep_joined_full_pinyin": true 
            },
            "pinyin_smark_word_filter": {
              "type": "pinyin",
              "keep_separate_first_letter": "false", 
              "keep_first_letter": "false"     
            }
          }
        }
      }
    }
    
    
    POST /_analyze
    {
      "analyzer": "pinyin",
      "text":"我是中国人"
    }
    
    
    POST /_analyze
    {
      "analyzer": "simple",
      "text": "决战到天亮"
    }
    
    
    POST /_analyze
    {
      "analyzer": "ik_smart",
      "text": "我是中国人"
    }
    
    POST /_analyze
    {
      "analyzer": "ik_max_word",
      "text": "太白"
    }
    
    
    
    POST bank/_search
    {
      "aggs": {
        "group_by_age": {
          "range": {
            "field": "age",
            "ranges": [
              {
                "from": 20,
                "to": 30
              },
              {
                "from": 30,
                "to": 40
              },
              {
                "from": 40,
                "to": 50
              }
            ]
          }
        }
      },
      "size": 0
    }
    
    POST bank/_search
    {
      "aggs": {
        "taibai": {
          "terms": {
            "field": "age"
          },
          "aggs": {
            "count": {
              "top_hits": {
                "size": 3
              }
            }
          }
        }
      },
      "size": 0
    }
    
    
    
    POST bank/_search
    {
      "aggs": {
        "taibai": {
          "terms": {
            "field": "age"
          }
        }
      },
      "size": 0
    }
    
    
    
    
    POST bank/_search
    {
      "aggs": {
        "taibai": {
          "value_count": {
            "field": "age"
          }
        }
      },
      "size": 0
    }
    
    
    
    POST bank/_search
    {
      "aggs": {
        "taibai": {
          "extended_stats": {
            "field": "age"
          }
        }
      },
      "size": 0
    }
    
    
    
    POST bank/_search
    {
      "aggs": {
        "taibai": {
          "cardinality": {
            "field": "age"
          }
        }
      },
      "size": 0
    }
    
    POST bank/_search
    {
      "aggs": {
        "taibai": {
          "avg": {
            "script": {
              "source": "doc.age.value"
            }
          }
        }
      },
      "size": 0
    }
    
    
    POST bank/_search
    {
      "aggs":{
        "taibai":{
          "avg":{
            "field": "age"
          }
        }
      },
      "size":0
    }
    
    
    GET taibai/_search
    {
      "query": {
         "bool": {
           "must": 
             {
               "term": {
                 "sex":  "男"
               }
             },
    
             "must_not": 
             {
               "term": {
                 "age":  "29"
               }
             },
             "should":[
               {
                 "term":{
                 "sex": "男"
                 }
               },
                {
       "term":{
                  "id": "1003"
                }
               }
             ]
         }
      }
    }
    
    
    GET taibai/_search
    {
      "query": {
        "match": {
          "name": "三"
        }
      }
    }
    
    
    GET taibai/_search
    {
      "query": {
        "range": {
          "age": {
            "gte": 20,
            "lte": 30
          }
        }
      }
    }
    
    GET taibai/_search
    {
      "query": {
        "exists": {
          "field": "age"
        }
      }
    }
    
    
    GET taibai/_search
    {
      "query": {
        "term": {
          "name.keyword": "张三"
        }
      }
    }
    
    POST /_analyze
    {
      "analyzer":"standard",
      "text":"决战到天亮"
    }
    
    POST /_analyze
    {
      "analyzer":"ik_max_word",
      "text":"决战到天亮"
    }
    
    POST /_analyze
    {
      "analyzer": "standard",
      "text": "张三"
    }
    
    GET taibai/_mapping
    
    GET taibai/_search
    {
      "query": {
        "term": {
          "name": "张三"
        }
      }
    }
    
    GET taibai/_search
    
    GET /bank/_search
    {
      "size": 2,
      "from": 0,
      "sort": [
        {
          "_id": {
            "order": "asc"
          }
        }
      ],
      "search_after":[
        1
      ]
    }
    
    
    //浅分页
    
    GET bank/_search
    {
      "size": 20,
      "from": 0,
      "sort": [
        {
          "_id": {
            "order": "desc"
          }
        }
      ]
    }
    
    GET /bank/_search?scroll=5m
    {
      "size": 20,
      "from": 0,
      "sort": [
        {
          "_id": {
            "order": "desc"
          }
        }
      ]
    }
    
    GET _search/scroll
    {
      "scroll_id":
      "FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFkM2RkJhMEFGU3g2OWZLQ0trNEpzcVEAAAAAAAAIyBZ4UEV6VFpWTlFoZXNhMkRQNHdZZVh3",
       "scroll":"5m"
    }
    
    DELETE _search/scroll/FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFkM2RkJhMEFGU3g2OWZLQ0trNEpzcVEAAAAAAAAIyBZ4UEV6VFpWTlFoZXNhMkRQNHdZZVh3
    
    DELETE _search/scroll/_all
    
    
    
    GET bank/_search
    {
      "query": {
        "match_all": {}
      },
       "sort": [
        {
          "_id": {
            "order": "asc"
          }
        }
      ],
      "size": 4,
      "from": 0
    }
    
    POST _bulk 
    { "create" :{ "_index" : "taibai", "_id" : "101" } }
    {
       "id":101,"name":"name1","age": 20,"sex": "男"} 
    { "create" : { "_index" : "taibai", "_id" : "401" }}
    {
       "id":401,"name":"name1","age": 20,"sex": "男"}
    
    
    POST _bulk
    { "update" :{ "_index" : "taibai", "_id" : "101" } }
    {
       "doc": {
       "id":101,"name":"name101","age": 201,"sex": "男101"}}
    { "update" : { "_index" : "taibai", "_id" : "401" }}
    {
       "doc": {
       "id":401,"name":"name401","age": 20401,"sex": "男401"}}
    
    
    POST _bulk 
    { "delete":{ "_index" : "taibai", "_id":"101" }}
    { "delete": { "_index" : "taibai", "_id":"401" }} 
    
    
    
    GET taibai/_search
    
    GET /bank/_mget
    {
      "ids":[
        "1","40"
        ]
    }
    
    
    GET bank/_source/40?_source=age,email
    
    
    
    GET bank/_doc/40?_source=id,name
    
    GET bank/_search?q=age:23
    
    GET bank/_search
    {
      "query": {
        "match_all": {}
      },
      "size": 1000,
      "from": 0
    }
    
    GET taibai/_search
    
    POST taibai/_doc
    {
      "id":1001,
      "name" : "张三",
      "age" : 22,
      "sex" : "男"
    }
    
    
    
    
    
    
    
    
    GET kuangshen/user/_search
    {
      "query":{
        "match": {
          "name": "狂神"
        }
      },
      "_source":["name","desc"] 
    }
    
    POST taibai/_doc/1001
    {
      "id":1002,
      "name":"太白"
    }
    
    GET taibai/_search
    
    
    PUT /taibai
    {
      "settings": {
        "number_of_replicas": 0,
        "number_of_shards": 1
      }
    }
    
    DELETE taibai
    
    POST taibai/_doc
    {
      "id":1001,
      "name":"taibai"
      
    }
    
    
    PUT taibai/_doc/1002
    {
      "id":1002,
      "name":"taibai",
       "age":21,
       "sex":"哈哈"
    }
    
    POST /taibai/_update/1002
    {
      "doc": {
        "age":21
      }
    }
    
    GET /taibai/_doc/1002
    
    DELETE taibai/_doc/9gU0l3sBa2-WIiyKQyQG

--------------------

完