数据库与缓存
Elasticsearch

8 Elasticsearch操作总结

# 精准度搜索

DELETE  /article

POST /article/_bulk
{ "create": { "_id": "1"} }
 {"title" : "elasticsearch" }
{ "create": { "_id": "2"} }
{"title" : "java"}
{ "create": { "_id": "3"} }
{"title" : "elasticsearch"}
{ "create": { "_id": "4"} }
{"title" : "hadoop"}
{ "create": { "_id": "5"} }
{"title" : "spark"}

GET /article/_search
{
    "query": {
        "bool": {
            "should": [
                {
                    "term": {
                        "title": {
                            "value": "java"
                        }
                    }
                },
                {
                    "term": {
                        "title": {
                            "value": "spark"
                        }
                    }
                },
                {
                    "term": {
                        "title": {
                            "value": "hadoop"
                        }
                    }
                },
                {
                    "term": {
                        "title": {
                            "value": "elasticsearch"
                        }
                    }
                }
            ]
        }
    }
}

GET /article/_search
{
    "query": {
        "bool": {
            "should": [
                {
                    "term": {
                        "title": {
                            "value": "java",
                            "boost": 5
                        }
                    }
                },
                {
                    "term": {
                        "title": {
                            "value": "spark",
                            "boost": 4
                        }
                    }
                },
                {
                    "term": {
                        "title": {
                            "value": "hadoop",
                            "boost": 3
                        }
                    }
                },
                {
                    "term": {
                        "title": {
                            "value": "elasticsearch"
                        }
                    }
                }
            ]
        }
    }
}

POST /article/_bulk
{ "update": { "_id": "1"} }
{ "doc" : {"content" : "i like to write best elasticsearch article"} }
{ "update": { "_id": "2"} }
{ "doc" : {"content" : "i think java is the best programming language"} }
{ "update": { "_id": "3"} }
{ "doc" : {"content" : "i am only an elasticsearch beginner"} }
{ "update": { "_id": "4"} }
{ "doc" : {"content" : "elasticsearch and hadoop are all very good solution, i am a beginner"} }
{ "update": { "_id": "5"} }
{ "doc" : {"content" : "spark is best big data solution based on scala ,an programming language similar to java"} }

GET /article/_search
{
    "query": {
        "bool": {
            "should": [
                {
                    "match": {
                        "title": "java solution"
                    }
                },
                {
                    "match": {
                        "content": "java solution"
                    }
                }
            ]
        }
    }
}

GET  /article/_search
{
    "query": {
        "dis_max": {
            "queries": [
                {
                    "match": {
                        "title": "java solution"
                    }
                },
                {
                    "match": {
                        "content": "java solution"
                    }
                }
            ]
        }
    }
}

# 数据建模

PUT /user/_doc/1
{
  "name": "John Smith",
  "email": "john@smith.com",
  "dob": "1970/10/24"
}



PUT /blogpost/_doc/2
{
  "title": "Relationships",
  "body": "It's complicated...",
  "user": 1
}

GET /user/_search
{
  "query": {
    "match": {
      "name": "John"
    }
  }
}


GET /blogpost/_search
{
  "query": {
    "terms": {
      "user": [
        1
      ]
    }
  }
}



DELETE /user

DELETE /blogpost

PUT /user/_doc/1
{
  "name": "John Smith",
  "email": "john@smith.com",
  "dob": "1970/10/24"
}



PUT /blogpost/_doc/2
{
  "title": "Relationships",
  "body": "It's complicated...",
  "user": {
    "id": 1,
    "name": "John Smith"
  }
}

GET /blogpost/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "title": "relationships"
          }
        },
        {
          "match": {
            "user.name": "John"
          }
        }
      ]
    }
  }
}


PUT /drivers
{
  "mappings": {
    "properties": {
      "driver": {
        "type": "nested",
        "properties": {
          "last_name": {
            "type": "text"
          },
          "vehicle": {
            "type": "nested",
            "properties": {
              "make": {
                "type": "text"
              },
              "model": {
                "type": "text"
              }
            }
          }
        }
      }
    }
  }
}

PUT /drivers/_doc/1
{
  "driver": {
    "last_name": "McQueen",
    "vehicle": [
      {
        "make": "Powell Motors",
        "model": "Canyonero"
      },
      {
        "make": "Miller-Meteor",
        "model": "Ecto-1"
      }
    ]
  }
}

PUT /drivers/_doc/2?refresh
{
"driver": {
  "last_name": "Hudson",
  "vehicle": [
    {
      "make": "Mifune",
      "model": "Mach Five"
    },
    {
      "make": "Miller-Meteor",
      "model": "Ecto-1"
    }
  ]
}
}

GET /drivers/_search
{
  "query": {
    "nested": {
      "path": "driver",
      "query": {
        "nested": {
          "path": "driver.vehicle",
          "query": {
            "bool": {
              "must": [
                {
                  "match": {
                    "driver.vehicle.make": "Powell  Motors"
                  }
                },
                {
                  "match": {
                    "driver.vehicle.model": "Canyonero"
                  }
                }
              ]
            }
          }
        }
      }
    }
  }
}

PUT my_index
{
  "mappings": {
    "properties": {
      "my_join_field": {
        "type": "join",
        "relations": {
          "question": "answer"
        }
      }
    }
  }
}


PUT /my_index/_doc/1?refresh
{
	"text": "This is a question",
	"my_join_field": {
  	"name": "question"
	}
}

PUT /my_index/_doc/2?refresh
{
	"text": "This is a question2",
	"my_join_field": "question"
}


PUT /my_index/_doc/3?routing=1
{
	"text": "This is an answer",
  "my_join_field": {
    "name": "answer",
    "parent": "1"
  }
}

POST my_index/_search
{
  "query": {
    "has_child": {
      "type": "answer",
      "query" : {
        "match": {
          "text" : "this"
        }
      }
    }
  }
}

GET my_index/_search
{

  "query": {
    "parent_id": {
      "type": "answer",
      "id": "1"
    }
  }
}

# 索引重建

PUT /book/_alias/book_alias

GET /book/_search?scroll=1m

{
"query": {
  "match_all": {}
},
"sort": ["_doc"],
"size": 1
}


GET /_search/scroll
{
  "scroll": "1m",
  "scroll_id" :
  "DXF1ZXJ5QW5kRmV0Y2gBAAAAAAACEgUWQUx2NlhnOGNTTTZLQmpVa3RDank0Zw=="
}


POST _reindex
{
  "source": {
    "index": "book"
  },
  "dest": {
    "index": "book_new"
  }
}

GET /book/_mapping

GET /book_new/_mapping


GET /book_new/_search

{
  "query":{
    "match_all":{}
  }
}


GET /book/_doc/2

GET /book_new/_doc/2

DELETE /book_new

POST _reindex
{
  "source": {
    "index": "book"
  },
  "dest": {
    "index": "book_new",
    "version_type": "external"
  }
}

POST _reindex
{
  "source": {
    "index": "book"
  },
  "dest": {
    "index": "book_new",
    "op_type": "create"
  }
}

POST _reindex
{
  "conflicts": "proceed",
  "source": {
    "index": "book"
  },
  "dest": {
    "index": "book_new",
    "op_type": "create"
  }xw
}

# 文件操作

POST /lagou-company-index/_doc/1
{
  "name":"百度",
  "job":"小度用户运营经理",
  "payment":"30000",
  "logo":"http://www.lgstatic.com/thubnail_120x120/i/image/M00/21/3E/CgpFT1kVdze  AJNbUAABJB7x9sm8374.png"
}

POST /lagou-company-index/_doc
{
  "name":"百度",
  "job":"算法工程师",
  "payment":"50000",
  "logo":"http://www.lgstatic.com/thubnail_120x120/i/image/M00/21/3E/CgpFT1kVdze AJNbUAABJB7x9sm4464.png"
}

GET /lagou-company-index/_doc/1

POST /lagou-company-index/_search
{
  "query":{
    "match_all":{}
  }
}

POST /lagou-company-index/_doc/_search
{
  "query":{
    "match_all":{}
  }
}

GET /lagou-company-index/_doc/1?_source=name,job

PUT /lagou-company-index/_doc/3
{
"name":"百度",
"job":"AI工程师",
"payment":"60000",
"logo":"http://www.lgstatic.com/thubnail_120x120/i/image/M00/21/3E/CgpFT1kVdzeAJNbUAABJB7x9sm4464.png"
}

GET /lagou-company-index/_doc/3

PUT /lagou-company-index/_doc/3
{
  "job":"AI工程师"
}

POST /lagou-company-index/_update/3
{
  "doc":{
    "job":"AI工程师"
  }
}

DELETE /lagou-company-index/_doc/3

POST /lagou-company-index/_delete_by_query
{
  "query":{
    "match":{
      "name":"百度"
    }
  }
}

PUT /lagou-company-index/_doc/1/_create
{
  "name":"百度",
  "job":"小度用户运营经理",
  "payment":"30000",
  "logo":"http://www.lgstatic.com/thubnail_120x120/i/image/M00/21/3E/CgpFT1kVdzeAJNbUAABJB7x9sm8374.png"
}

GET /lagou-company-index/_doc/1

# 映射高级

PUT /company-locations
{
  "mappings": {
    "properties": {
      "name": {
        "type": "text"
      },
      "location": {
        "type": "geo_point"
      }
    }
  }
}

PUT /company-locations/_doc/1
{
  "name":"NetEase",
  "location":"40.715,74.011"
}

PUT /company-locations/_doc/2
{
  "name":"Sina",
  "location":{
    "lat":40.722,
    "lon":73.989
  }
}

PUT /company-locations/_doc/3
{
  "name":"Baidu",
  "location":[73.983,40.719]
}

GET /company-locations/_search
{
  "query": {
    "bool" : {
      "must" : {
        "match_all" : {}
      },
      "filter" : {
        "geo_bounding_box" : {
          "location" : {
            "top_left" : {
              "lat" : 40.73,
              "lon" : 71.12
            },
            "bottom_right" : {
              "lat" : 40.01,
              "lon" : 74.0
            }
          }
        }
      }
    }
  }
}

GET /company-locations/_search
{
  "query": {
    "bool" : {
      "must" : {
        "match_all" : {}
      },
      "filter" : {
        "geo_distance" : {
          "distance" : "350km",
          "location" : {
            "lat" : 40,
            "lon" : 70
          }
        }
      }
    }
  }
}

PUT /user
{
  "settings":{
    "number_of_shards": 3,
    "number_of_replicas": 0
  },
  "mappings":{
    "dynamic": "strict",
    "properties": {
      "name": {"type": "text"},
      "address": {"type": "object", "dynamic": true}
    }
  }
}

PUT /user/_doc/1
{
  "name": "lisi",
  "age": "20",
  "address": {
    "province": "beijing",
    "city": "beijing"
  }
}

DELETE /user

PUT /user
{
  "settings":{
    "number_of_shards": 3,
    "number_of_replicas": 0
  },
  "mappings":{
    "dynamic": true,
    "properties": {
      "name": {"type": "text"},
      "address": {"type": "object", "dynamic": true}
    }
  }
}

PUT /my_index/_doc/1
{
  "note":"2014-01-01"
}

GET /my_index/_mapping

PUT /my_index/_doc/2
{
  "note":"loggout"
}

DELETE /my_index

PUT /my_index
{
  "mappings": {
    "date_detection": false
  }
}

DELETE /my_index

PUT /my_index
{
  "mappings": {
    "dynamic_date_formats": "MM/dd/yyyy"
  }
}

PUT /my_index/_doc/1
{ "note": "2014-01-01" }

PUT /my_index/_doc/1
{ "note": "01/01/2014" }

GET /my_index/_mapping

PUT /my_index2
{
  "mappings": {
    "dynamic_templates": [
      {
        "es": {
          "match": "*_es",
          "match_mapping_type": "string",
          "mapping": {
            "type": "text",
            "analyzer": "spanish"
          }
        }
      },
      {
        "en": {
          "match": "*",
          "match_mapping_type": "string",
          "mapping": {
            "type": "text",
            "analyzer": "english"
          }
        }
      }
    ]
  }
}

GET /my_index2/_mapping

PUT /my_index2/_doc/1
{
  "name_es":"testes",
  "name":"es"
}

# 智能搜索建议

PUT /blogs/
{
  "mappings": {
    "properties": {
      "body": {
        "type": "text"
      }
    }
  }
}

POST _bulk/?refresh=true
{ "index" : { "_index" : "blogs" } }
{ "body": "Lucene is cool"}
{ "index" : { "_index" : "blogs" } }
{ "body": "Elasticsearch builds on top of lucene"}
{ "index" : { "_index" : "blogs" } }
{ "body": "Elasticsearch rocks"}
{ "index" : { "_index" : "blogs" } }
{ "body": "Elastic is the company behind ELK stack"}
{ "index" : { "_index" : "blogs" } }
{ "body": "elk rocks"}
{ "index" : { "_index" : "blogs"} }
{ "body": "elasticsearch is rock solid"}

POST _analyze
{
  "text": [
    "Lucene is cool",
    "Elasticsearch builds on top of lucene",
    "Elasticsearch rocks",
    "Elastic is the company behind ELK stack",
    "elk rocks",
    "elasticsearch is rock solid"
  ]
}

POST /blogs/_search
{
  "suggest": {
    "my-suggestion": {
      "text": "lucne rock",
      "term": {
        "suggest_mode": "missing",
        "field": "body"
      }
    }
  }
}

POST /blogs/_search
{
  "suggest": {
    "my-suggestion": {
      "text": "lucne rocks",
      "term": {
        "suggest_mode": "popular",
        "field": "body"
      }
    }
  }
}

POST /blogs/_search
{
  "suggest": {
    "my-suggestion": {
      "text": "lucne rocks",
      "term": {
        "suggest_mode": "always",
        "field": "body"
      }
    }
  }
}

POST /blogs/_search
{
  "suggest": {
    "my-suggestion": {
      "text": "lucne and elasticsear rock",
      "phrase": {
        "field": "body",
        "highlight": {
          "pre_tag": "<em>",
          "post_tag": "</em>"
        }
      }
    }
  }
}

PUT /blogs_completion/
{
  "mappings": {
    "properties": {
      "body": {
        "type": "completion"
      }
    }
  }
}

POST _bulk/?refresh=true
{ "index" : { "_index" : "blogs_completion" } }
{ "body": "Lucene is cool"}
{ "index" : { "_index" : "blogs_completion" } }
{ "body": "Elasticsearch builds on top of lucene"}
{ "index" : { "_index" : "blogs_completion"} }
{ "body": "Elasticsearch rocks"}
{ "index" : { "_index" : "blogs_completion" } }
{ "body": "Elastic is the company behind ELK stack"}
{ "index" : { "_index" : "blogs_completion" } }
{ "body": "the elk stack rocks"}
{ "index" : { "_index" : "blogs_completion"} }
{ "body": "elasticsearch is rock solid"}

POST /blogs_completion/_search?pretty
{ 
"size": 0,
"suggest": {
  "blog-suggest": {
    "prefix": "elastic i",
    "completion": {
      "field": "body"
    }
  }
}
}

DELETE /blogs_completion

PUT /blogs_completion/
{
  "mappings": {
    "properties": {
      "body": {
        "type": "completion",
        "analyzer":"english"
      }
    }
  }
}

POST _bulk/?refresh=true
{ "index" : { "_index" : "blogs_completion" } }
{ "body": "Lucene is cool"}
{ "index" : { "_index" : "blogs_completion" } }
{ "body": "Elasticsearch builds on top of lucene"}
{ "index" : { "_index" : "blogs_completion"} }
{ "body": "Elasticsearch rocks"}
{ "index" : { "_index" : "blogs_completion" } }
{ "body": "Elastic is the company behind ELK stack"}
{ "index" : { "_index" : "blogs_completion" } }
{ "body": "the elk stack rocks"}
{ "index" : { "_index" : "blogs_completion"} }
{ "body": "elasticsearch is rock solid"}

POST /blogs_completion/_search?pretty
{
    "size": 0,
    "suggest": {
        "blog-suggest": {
            "prefix": "elastic i",
            "completion": {
                "field": "body"
            }
        }
    }
}


POST _analyze
{
  "text": "elasticsearch is rock solid",
  "analyzer":"english"
}

POST _analyze
{
  "text": "elasticsearch is rock solid"
}

POST /blogs_completion/_search?pretty
{
    "size": 0,
    "suggest": {
        "blog-suggest": {
            "prefix": "elastic is",
            "completion": {
                "field": "body"
            }
        }
    }
}

# DSL-分页高亮

GET /book/_search
{
  "query": {
    "term" : { "description" : "solr"}
  }
}

GET /book/_search
{
  "query": {
    "constant_score" : {
      "filter" : {
        "term" : { "description" : "solr"}
      },
      "boost" : 1.2
    }
  }
}

POST /book/_search
{
  "query": {
    "bool" : {
      "should" : {
        "match" : { "description" : "java" }
      },
      "filter": {
        "term" : { "name" : "solr" }
      },
      "must_not" : {
        "range" : {
          "price" : { "gte" : 200, "lte" : 300 }
        }
      },
      "minimum_should_match" : 1,
      "boost" : 1.0
    }
  }
}

POST /book/_search
{
  "query": {
    "match": {"description":"solr"}
  }
}

POST /book/_search
{
  "query": {
    "match": {"description":"solr"}
  },
  "sort": [
    {"_score": {"order": "asc"}}
  ]
}

POST /book/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {"price": {"order": "desc"}}
  ]
}

POST /book/_search
{
  "query":{
    "match_all":{}
  },
  "sort": [
    { "price": { "order": "desc" }},
    { "timestamp": { "order": "desc" }}
  ]
}

POST /book/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {"price": {"order": "desc"}}
  ],
  "size": 2,
  "from": 0
}

POST /book/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {"price": {"order": "desc"}}
  ],
  "size": 2,
  "from": 2
}

POST /book/_search
{
  "query": {
    "match": {
      "name": "elasticsearch"
    }
  },
  "highlight": {
    "pre_tags": "<font color='pink'>",
    "post_tags": "</font>",
    "fields": [{"name":{}}]
  }
}

POST /book/_search
{
  "query": {
    "match": {
      "name": "elasticsearch"
    }
  },
  "highlight": {
    "pre_tags": "<font color='pink'>",
    "post_tags": "</font>",
    "fields": [{"name":{}},{"description":{}}]
  }
}

POST /book/_search
{
  "query": {
    "query_string" : {
      "query" : "elasticsearch"
    }
  },
  "highlight": {
    "pre_tags": "<font color='pink'>",
    "post_tags": "</font>",
    "fields": [{"name":{}},{"description":{}}]
  }
}

GET /_mget
{
  "docs" : [
    {
      "_index" : "book",
      "_id" : 2
    },
    {
      "_index" : "lagou-company-index",
      "_id" : 1
    }
  ]
}

GET /book/_mget
{
  "docs" : [
    {
      "_id" : 2
    },
    {
      "_id" : 3
    }
  ]
}

POST /_bulk
{ "delete": { "_index": "book", "_id": "1" }}
{ "create": { "_index": "book", "_id": "5" }}
{ "name": "test14","price":100.99 }
{ "update": { "_index": "book", "_id": "2"} }
{ "doc" : {"name" : "test"} }

# DSL-match_all和full-text

POST /lagou-company-index/_search
{
  "query":{
    "match_all":{}
  }
}

POST /company-locations/_search
{
  "query":{
    "match_all":{}
  }
}

PUT /lagou-property
{
  "settings": {},
  "mappings": {
    "properties": {
      "title": {
        "type": "text",
        "analyzer": "ik_max_word"
      },
      "images": {
        "type": "keyword"
      },
      "price": {
        "type": "float"
      }
    }
  }
}

POST /lagou-property/_doc/
{
  "title": "小米电视4A",
  "images": "http://image.lagou.com/12479122.jpg",
  "price": 4288
}

POST /lagou-property/_doc/
{
  "title": "小米手机",
  "images": "http://image.lagou.com/12479622.jpg",
  "price": 2699
}

POST /lagou-property/_doc/
{
  "title": "华为手机",
  "images": "http://image.lagou.com/12479922.jpg",
  "price": 5699
}

POST /lagou-property/_search
{
  "query":{
    "match":{
      "title":"小米电视4A"
    }
  }
}

POST /lagou-property/_search
{
  "query": {
    "match": {
      "title": {
        "query": "小米电视4A",
        "operator": "and"
      }
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "match_phrase": {
      "title": "小米电视"
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "match_phrase": {
      "title": "小米 4A"
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "match_phrase": {
      "title": {
        "query": "小米 4A",
        "slop": 3
      }
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "query_string" : {
      "query" : "2699"
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "query_string" : {
      "query" : "2699",
      "default_field" : "title"
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "query_string" : {
      "query" : "手机 OR 小米",
      "default_field" : "title"
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "query_string" : {
      "query" : "手机 AND 小米",
      "default_field" : "title"
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "query_string" : {
      "query" : "大米~1",
      "default_field" : "title"
    }
  }
}

GET /lagou-property/_search
{
  "query": {
    "query_string" : {
      "query":"2699",
      "fields": [ "title","price"]
    }
  }
}

POST /lagou-property/_search
{
  "query": {
    "multi_match" : {
      "query":"2699",
      "fields": [ "title","price"]
    }
  }
}

POST /lagou-property/_search
{
  "query": {
    "multi_match" : {
      "query":"2699",
      "fields": [ "title","pr*"]
    }
  }
}

# Filter-聚合操作

POST /book/_search
{
  "query": {
    "filtered": {
      "query": {
        "match_all": {}
      },
      "filter": {
        "range": {
          "price": {
            "gte": 200,
            "lte": 1000
          }
        }
      }
    }
  }
}

POST /book/_search
{
  "query": {
    "bool": {
      "must": {
        "match_all": {}
      },
      "filter": {
        "range": {
          "price": {
            "gte": 200,
            "lte": 1000
          }
        }
      }
    }
  }
}

GET /book/_search?explain
{
"query": {
  "match1": {
    "name": "test"
  }
}
}

GET /book/_validate/query?explain
{
"query": {
  "match1": {
    "name": "test"
  }
}
}

POST /book/_search
{
  "size": 0,
  "aggs": {
    "max_price": {
      "max": {
        "field": "price"
      }
    }
  }
}

POST /book/_count
{
  "query": {
    "range": {
      "price" : {
        "gt":100
      }
    }
  }
}

POST /book/_search?size=0
{
"aggs": {
  "price_count": {
    "value_count": {
      "field": "price"
    }
  }
}
}

POST /book/_search?size=0
{
"aggs": {
  "_id_count": {
    "cardinality": {
      "field": "_id"
    }
  },
  "price_count": {
    "cardinality": {
      "field": "price"
    }
  }
}
}

POST /book/_search?size=0
{
"aggs": {
  "price_stats": {
    "stats": {
      "field": "price"
    }
  }
}
}

POST /book/_search?size=0
{
"aggs": {
  "price_stats": {
    "extended_stats": {
      "field": "price"
    }
  }
}
}

POST /book/_search?size=0
{
"aggs": {
  "price_percents": {
    "percentiles": {
      "field": "price"
    }
  }
}
}

POST /book/_search?size=0
{
"aggs": {
  "price_percents": {
    "percentiles": {
      "field": "price",
      "percents" : [75, 99, 99.9]
    }
  }
}
}

POST /book/_search?size=0
{
"aggs": {
  "gge_perc_rank": {
    "percentile_ranks": {
      "field": "price",
      "values": [
        100,200
      ]
    }
  }
}
}

POST /book/_search
{
  "size": 0,
  "aggs": {
    "group_by_price": {
      "range": {
        "field": "price",
        "ranges": [
          {
            "from": 0,
            "to": 200
          },
          {
            "from": 200,
            "to": 400
          },
          {
            "from": 400,
            "to": 1000
          }
        ]
      },
      "aggs": {
        "average_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    }
  }
}

POST /book/_search
{
  "size": 0,
  "aggs": {
    "group_by_price": {
      "range": {
        "field": "price",
        "ranges": [
          {
            "from": 0,
            "to": 200
          },
          {
            "from": 200,
            "to": 400
          },
          {
            "from": 400,
            "to": 1000
          }
        ]
      },
      "aggs": {
        "average_price": {
          "avg": {
            "field": "price"
          }
        },
        "count_price": {
          "value_count": {
            "field": "price"
          }
        }
      }
    }
  }
}

POST /book/_search
{
  "size": 0,
  "aggs": {
    "group_by_price": {
      "range": {
        "field": "price",
        "ranges": [
          {
            "from": 0,
            "to": 200
          },
          {
            "from": 200,
            "to": 400
          },
          {
            "from": 400,
            "to": 1000
          }
        ]
      },
      "aggs": {
        "average_price": {
          "avg": {
            "field": "price"
          }
        },
        "having": {
          "bucket_selector": {
            "buckets_path": {
              "avg_price": "average_price"
            },
            "script": {
              "source": "params.avg_price >= 200 "
            }
          }
        }
      }
    }
  }
}

# tem-level-queries

PUT /book
{
  "settings": {},
  "mappings" : {
    "properties" : {
      "description" : {
        "type" : "text",
        "analyzer" : "ik_max_word"
      },
      "name" : {
        "type" : "text",
        "analyzer" : "ik_max_word"
      },
      "price" : {
        "type" : "float"
      },
      "timestamp" : {
        "type" : "date",
        "format" : "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis"
      }
    }
  }
}

PUT /book/_doc/1
{
  "name": "lucene",
  "description": "Lucene Core is a Java library providing powerful indexing and search features, as well as spellchecking, hit highlighting and advanced analysis/tokenization capabilities. The PyLucene sub project provides Python bindings for Lucene Core. ",
  "price":100.45,
  "timestamp":"2020-08-21 19:11:35"
}

PUT /book/_doc/2
{
  "name": "solr",
  "description": "Solr is highly scalable, providing fully fault tolerant distributed indexing, search and analytics. It exposes Lucenes features through easy to use JSON/HTTP interfaces or native clients for Java and other languages.",
  "price":320.45,
  "timestamp":"2020-07-21 17:11:35"
}

PUT /book/_doc/3
{
  "name": "Hadoop",
  "description": "The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models.",
  "price":620.45,
  "timestamp":"2020-08-22 19:18:35"
}

PUT /book/_doc/4
{
  "name": "ElasticSearch",
  "description": "Elasticsearch是一个基于Lucene的搜索服务器。它提供了一个分布式多用户能力的全文搜索引擎，基于RESTful web接口。Elasticsearch是用Java语言开发的，并作为Apache许可条款下的开放源码发布，是一种流行的企业级搜索引擎。Elasticsearch用于云计算中，能够达到实时搜索，稳定，可靠，快速，安装使用方便。官方客户端在Java、.NET（C#）、PHP、Python、Apache Groovy、Ruby和许多其他语言中都是可用的。根据DB-Engines的排名显示，Elasticsearch是最受欢迎的企业搜索引擎，其次是Apache Solr，也是基于Lucene。",
  "price":999.99,
  "timestamp":"2020-08-15 10:11:35"
}

POST /book/_search
{
  "query":{
    "term":{
      "name":"solr"
    }
  }
}

POST /book/_search
{
  "query":{
    "terms":{
      "name":["solr","elasticsearch"]
    }
  }
}

GET /book/_search
{
  "query": {
    "range" : {
      "price" : {
        "gte" : 10,
        "lte" : 200,
        "boost" : 2.0
      }
    }
  }
}

GET /book/_search
{
  "query": {
    "range" : {
      "timestamp" : {
        "gte" : "now-7d/d",
        "lt" : "now/d"
      }
    }
  }
}

GET book/_search
{
  "query": {
    "range" : {
      "timestamp" : {
        "gte": "18/06/2020",
        "lte": "2021",
        "format": "dd/MM/yyyy||yyyy"
      }
    }
  }
}

GET /book/_search
{
  "query": {
    "exists" : { "field" : "price" }
  }
}

POST /book/_search
{
  "query":{
    "prefix":{
      "name":"so"
    }
  }
}

GET /book/_search
{
  "query": {
    "wildcard" : { "name" : "So*r" }
  }
}

GET /book/_search
{
  "query": {
    "wildcard": {
      "name": {
        "value": "lu*",
        "boost": 2
      }
    }
  }
}

GET /book/_search
{
  "query": {
    "regexp":{
      "name": "s.*"
    }
  }
}

GET /book/_search
{
  "query": {
    "regexp":{
      "name": {
        "value":"s.*",
        "boost":1.2
      }
    }
  }
}

GET /book/_search
{
  "query": {
    "fuzzy" : { "name" : "so" }
  }
}

GET /book/_search
{
  "query": {
    "fuzzy" : {
      "name" : {
        "value": "so",
        "boost": 1.0,
        "fuzziness": 2
      }
    }
  }
}

GET /book/_search
{
  "query": {
    "fuzzy" : {
      "name" : {
        "value": "sorl",
        "boost": 1.0,
        "fuzziness": 2
      }
    }
  }
}

GET /book/_search
{
  "query": {
    "ids" : {
      "values" : ["1", "3"]
    }
  }
}

POST /book/_search
{
  "query":{
    "terms":{
      "_id":[1,3]
    }
  }
}

上次更新: 2023/08/10, 16:25:16

← 7 Elasticsearch深度应用及原理