ES常用(阿里云)

13 阅读2分钟

查找指定ID的数据 GET /aizj_search_data_v1/_search

{
  "query": {
    "term": {
      "_id": "21788"
    }
  }
}

查找某列不为空的数据

GET /aizj_search_data_v1/_search
{
  "query": {
      "bool": {
          "must": [
        {
          "exists": {
            "field": "media_type"
          }
        }
      ]
    }
 
  }
}

更新指定ID的部分字段


POST /aizj_search_data_v1/_doc/21788/_update
{
    "doc": {
    "legal_org_name": "新组织",
    "legal_mem_name": "新成员",
    "org_id": "12345"
  }
}
 
查询字段及类型(映射)
GET /aizj_search_data_v1/_mapping?pretty
查询别名aizj_search_data_v1对应的索引
GET /aizj_search_data_v1/_alias/*
查询索引对应的别名
GET /*/_alias/aizj_search_data_v1
GET /_alias/aizj_search_data_v1

删除索引
DELETE /aizj_search_data_v1

新建别名
PUT /aizj_search_data_v1
更改指向
将别敏aizj_search_data_v1指向索引aizj_search_data_zgf_v2
POST /aizj_search_data_zgf_v2/_alias/aizj_search_data_v1

查询ID376的文档
GET /aizj_search_data_v1/_search
{
  "query": {
    "term": {
      "_id": "376"
    }
  }
}
 
             
条件查询                    
GET /aizj_search_data_v1/_search
{
  "query": {
      "bool": {
          "must": [
          {
          
                        "term": {
                            "tenant_no": {
                                "value": "lawUrge",
                                "boost": 1.0
                            }
                        }
                        
          }
        
      ]
    }
 
  }
}


GET /aizj_search_data_v1/_search
{
  "query": {
     "bool": {
                "must": [
                    {
                        "term": {
                            "legal_org_name": {
                                "value": "lawUrge",
                                "boost": 1.0
                            }
                        }
                    }
                ]
            }
  }
}
GET /aizj_search_data_v1/_search
{
  "query": {
     "bool": {
                "must": [
                    {
                        "term": {
                            "legal_org_name": {
                                "value": "lawUrge",
                                "boost": 1.0
                            }
                        }
                    },
                    {
                        "terms": {
                            "org_name": [
                                "所属机构1"
                            ],
                            "boost": 1.0
                        }
                    }
                ],
                "adjust_pure_negative": true,
                "boost": 1.0
            }
  }
}


POST /aizj_search_data_v1/_doc/376/_update
{
    "doc": {
    "legal_org_name": "催收机构2",
    "legal_mem_name": "催员1",
    "org_name": "所属机构1"
  }
}


POST /aizj_search_data_v1/_doc/376/_update
{
    "doc": {
    "legal_org_name": "催收机构2",
    "legal_mem_name": "催员1",
    "org_name": "所属机构1"
  }
}
 
 
 
 
 
 
PUT /aizj_search_data_vzgf
{ 
  }
 
 
 GET /aizj_search_data_v1/_settings

 
 
PUT /aizj_search_data_zgf_v1
{
  "settings" : {
      "index" : {
        "routing" : {
          "allocation" : {
            "include" : {
              "_tier_preference" : "data_content"
            }
          }
        },
        "search" : {
          "slowlog" : {
            "threshold" : {
              "fetch" : {
                "warn" : "200ms",
                "trace" : "50ms",
                "debug" : "80ms",
                "info" : "100ms"
              },
              "query" : {
                "warn" : "500ms",
                "trace" : "50ms",
                "debug" : "100ms",
                "info" : "200ms"
              }
            }
          }
        },
        "indexing" : {
          "slowlog" : {
            "threshold" : {
              "index" : {
                "warn" : "200ms",
                "trace" : "20ms",
                "debug" : "50ms",
                "info" : "100ms"
              }
            },
            "source" : "1000"
          }
        },
        "number_of_shards" : "3",
        "provided_name" : "aizj_search_data_v1",
        "max_result_window" : "100000000",
        "creation_date" : "1728969797777",
        "unassigned" : {
          "node_left" : {
            "delayed_timeout" : "5m"
          }
        },
        "analysis" : {
          "analyzer" : {
            "ik" : {
              "type" : "custom",
              "tokenizer" : "ik_max_word"
            }
          }
        },
        "number_of_replicas" : "1",
        "uuid" : "MwMQIGKLR0ujs24StM_rCQ",
        "version" : {
          "created" : "7160299"
        }
      }
    },
  "mappings": {
    "properties": {

        "legal_org_name" : {
          "type" : "keyword"
        },
        "legal_mem_name" : {
          "type" : "text"
        },
        "media_type" : {
          "type" : "keyword"
        },
        "org_id" : {
          "type" : "keyword"
        }
      }
    }
    
  }