ElasticSearch es 数据增删改查与结构更新脚本

忘是亡心i 2022-04-04 17:09 542阅读 0赞

### 1、条件查询 ###

**http://192.168.250.101:9200/call\_record\_index/call\_record\_type/\_search**

{ 
      "query": { 
        "range": { 
          "serverFee": { 
            "gte": 1 
          } 
        } 
      } 
    }

http://192.168.250.101:9200/tel\_rent\_index/tel\_rent\_type/\_search  
http://192.168.250.101:9200/vi\_order\_index/vi\_order\_type/\_search  
\{   
  "query": \{   
    "range": \{   
      "assignTime": \{   
        "gte": "2018-05-24 17:57:00"  
      \}   
    \}   
  \}   
\}

\{   
  "query": \{   
    "term": \{   
      "servicerId": "001"   
    \}   
  \}   
\}

\{  
    "query":\{  
        "range":\{  
            "createTime":\{  
                "gte":"2018-04-01",  
                "lte":"2018-04-30 23:59:59"  
            \}  
        \},  
        "term":\{  
            "servicerId":"001"  
        \}  
    \}  
\}

### 2、删除 ###

**\#1、按照id删除**  
http://192.168.251.7:9200/vi\_order\_index/vi\_order\_type/CfrkYmMBULguzjmvrJ7e

**\#2、删除文档所有数据**  
http://192.168.251.7:9200/cust\_map\_index/cust\_map\_type/\_delete\_by\_query?pretty  
\{  
    "query": \{  
        "match": \{  
            "enterpriseCode": "platform"  
        \}  
    \}  
\}

**\#3、左右模糊查询**  
POST  
http://192.168.251.7:9200/telnum\_fee\_index/telnum\_fee\_type/\_search  
\{  
    "query": \{  
        "wildcard": \{  
            "enterpriseName": "\*保\*"   
        \}  
    \}  
\}

**\#4、删除所有**  
http://192.168.251.7:9200/customer\_center\_index/customer\_center\_type/\_delete\_by\_query  
http://192.168.251.7:9200/data\_center\_index/data\_center\_type/\_delete\_by\_query  
http://192.168.251.7:9200/car\_center\_index/car\_center\_type/\_delete\_by\_query  
\{  
"query": \{  
"match\_all": \{\}  
\}  
\}

继续整理中....