四、Elasticsearch基本语法

索引基本操作

创建索引: PUT /索引名 注意：索引名必须全部由小写字母组成

PUT /order

查看所有索引:

GET /_cat/indices?v

查看单个索引: GET /索引名

GET /order

删除索引: DELETE /索引名

DELETE /order

删除所有索引: DELETE /*

DELETE /*

创建索引(index)，同时创建类型(type)和映射(mapping)，7.0以前是可以指定type的

PUT /order
{
    "mappings":{
        "order_detail":{
            "properties":{
                "id":{"type":"keyword"},
                "orderid":{"type":"keyword"},            
                "quantity":{"type":"integer"},
                "createdtime":{"type":"date"}
            }        
        }    
    }
}

7.0以后不能指定type，详细看官网介绍：

6.0之前一个索引可以对应多个类型，所以这里才会是先写mapping，再写type(order_detail1,order_detail2就是type)

PUT /order
{
    "mappings":{
        "order_detail1":{
            "properties":{
                "id":{"type":"keyword"},
                "orderid":{"type":"keyword"},            
                "quantity":{"type":"integer"},
                "createdtime":{"type":"date"}
            }        
        },
        "order_detail2":{
            "properties":{
                "id":{"type":"keyword"},
                "orderid":{"type":"keyword"},            
                "quantity":{"type":"integer"},
                "createdtime":{"type":"date"}
            }        
        }   
    }
}

创建索引同时设置settings与mappings

PUT /order
{
  "settings": {
        "index": {
            "number_of_shards": "3",
            "number_of_replicas": "1",
            "max_result_window": "10000000"
        },
        "analysis": {
            "analyzer": {
                "sanalyzer": {
                    "tokenizer": "standard"
                }
            },
            "normalizer": {
                "lowercase": {
                    "type": "custom",
                    "filter": [
                        "lowercase"
                    ]
                }
            }
        }
    },
    "mappings": {
        "properties": {
            "PlatformId": {
                "type": "short"
            },
            "Platform": {
                "type": "keyword",
                "normalizer": "lowercase"
            }
            "OrderRemark": {
                "type": "keyword",
                "normalizer": "lowercase"
            },
            "PackageInfos": {
                "properties": {
                    "PackageId": {
                        "type": "keyword",
                        "normalizer": "lowercase"
                    },
                    "ShippingTime": {
                        "type": "keyword",
                        "normalizer": "lowercase"
                    }
                }
            }
        }
    }
}

因为ES有默认返回数，可以自定义max_result_window

Docment基本操作

查询所有数据，track_total_hits返回所有条数

GET /order/_search
{
  "track_total_hits": true,
  "query": { "match_all": {} }
}

按单号搜索

GET /order/_search
{
  "query": { 
    "match": {
      "orderid": "orderid1"
    }
  }
}

按多个单号搜索

GET /order/_search
{
  "query": { 
    "terms": {
      "orderid": ["orderid1","orderid2"]
    }
  }
}

复杂查询，比如：查询订单状态为已下单，并且发货单是未上传状态的(这里会有两种情况：1.发货单还没生成，2.发货单已生成但是还没上传)

{
    "track_total_hits": true,
    "from": 0,
    "query": {
        "bool": {
            "must": [
                {
                    "terms": {
                        "COStateId": [
                            "Ordered"
                        ]
                    }
                },
                {
                    "bool": {
                        "should": [
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "exists": {
                                                "field": "PackageInfos"
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "terms": {
                                    "PackageInfos.WMSStateId": [
                                        "0"
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "size": 20,
    "sort": [
        {
            "InputTime": {
                "order": "desc"
            }
        }
    ]
}

根据某个条件(COID)查询重复数据

GET order/_search
{
  "size": 0,
  "aggs": {
    "duplicateCount": {
      "terms": {
        "field": "COID",
        "min_doc_count": 2
      },
      "aggs": {
        "duplicateDocuments": {
          "top_hits": {}
        }
      }
    }
  }
}