第05篇_ElasticSearch

第01章_Elasticsearch快速入门

第一节 索引操作

1. 创建索引

1
PUT /goods
2
{
3
  "settings": {
4
    "number_of_shards": 1,
5
    "number_of_replicas": 0
6
  }
7
}

2. 删除索引

1
1
DELETE /goods

3. 查看索引信息

1
1
GET /goods

第二节 映射操作

1. 创建映射

16
1
PUT /goods/_mapping/docs
2
{
3
  "properties": {
4
    "title":{
5
      "type": "text",
6
      "analyzer": "ik_max_word"
7
    },
8
    "images":{
9
      "type": "keyword",
10
      "index": false
11
    },
12
    "price":{
13
      "type": "double"
14
    }
15
  }
16
}

2. 查看映射信息

1
1
GET /goods/_mapping

第三节 数据增删改

1. 新增数据

​x
1
POST /goods/docs/1
2
{
3
    "title":"小米手机",
4
    "images":"http://image.leyou.com/12479122.jpg",
5
    "price":2899.00
6
}
7

8
tips:新增数据中存在映射没有的字段，则会自动更新映射信息

2. 修改数据

8
1
PUT /goods/docs/1
2
{
3
    "title":"小米手机",
4
    "images":"http://image.leyou.com/12479122.jpg",
5
    "price":2799.00
6
}
7

8
tips:只需将新增的POST请求改为PUT就行了

3. 删除数据

1
1
DELETE /goods/docs/1

4. 批量新增

37
1
PUT /cars
2
{
3
  "settings": {
4
    "number_of_shards": 1,
5
    "number_of_replicas": 0
6
  },
7
  "mappings": {
8
    "transactions": {
9
      "properties": {
10
        "color": {
11
          "type": "keyword"
12
        },
13
        "make": {
14
          "type": "keyword"
15
        }
16
      }
17
    }
18
  }
19
}
20

21
POST /cars/transactions/_bulk
22
{ "index": {}}
23
{ "price" : 10000, "color" : "red", "make" : "honda", "sold" : "2014-10-28" }
24
{ "index": {}}
25
{ "price" : 20000, "color" : "red", "make" : "honda", "sold" : "2014-11-05" }
26
{ "index": {}}
27
{ "price" : 30000, "color" : "green", "make" : "ford", "sold" : "2014-05-18" }
28
{ "index": {}}
29
{ "price" : 15000, "color" : "blue", "make" : "toyota", "sold" : "2014-07-02" }
30
{ "index": {}}
31
{ "price" : 12000, "color" : "green", "make" : "toyota", "sold" : "2014-08-19" }
32
{ "index": {}}
33
{ "price" : 20000, "color" : "red", "make" : "honda", "sold" : "2014-11-05" }
34
{ "index": {}}
35
{ "price" : 80000, "color" : "red", "make" : "bmw", "sold" : "2014-01-01" }
36
{ "index": {}}
37
{ "price" : 25000, "color" : "blue", "make" : "ford", "sold" : "2014-02-12" }

第四节 数据查询

1. 查询所有数据

6
1
GET /goods/_search
2
{
3
  "query": {
4
    "match_all": {}
5
  }
6
}

2. 分词匹配查询

1) 分词or匹配

8
1
GET /goods/_search
2
{
3
  "query": {
4
    "match": {
5
      "title": "小米手机"
6
    }
7
  }
8
}

2) 分词and匹配

11
1
GET /goods/_search
2
{
3
  "query": {
4
    "match": {
5
      "title": {
6
        "query": "小米手机",
7
        "operator": "and"
8
      }
9
    }
10
  }
11
}

3) 分词比例匹配

11
1
GET /goods/_search
2
{
3
  "query": {
4
    "match": {
5
      "title": {
6
        "query": "小米手机",
7
        "minimum_should_match": "75%"
8
      }
9
    }
10
  }
11
}

3. 多字段分词匹配查询

9
1
GET /goods/_search
2
{
3
  "query": {
4
    "multi_match": {
5
      "query": "小米",
6
      "fields": ["title","subTitle"]
7
    }
8
  }
9
}

4. 词条匹配查询

17
1
GET goods/_search
2
{
3
  "query": {
4
    "term": {
5
      "price": 2799.00
6
    }
7
  }
8
}
9

10
GET /goods/_search
11
{
12
    "query":{
13
        "terms":{
14
            "price":[2799.00,2899.00,3899.00]
15
        }
16
    }
17
}

5. 范围查询

11
1
GET /goods/_search
2
{
3
  "query": {
4
    "range": {
5
      "price": {
6
        "gte": 2500,
7
        "lte": 3000
8
      }
9
    }
10
  }
11
}

6. 模糊查询

11
1
GET goods/_search
2
{
3
  "query": {
4
    "fuzzy": {
5
      "title": {
6
        "value": "小木",
7
        "fuzziness": 2
8
      }
9
    }
10
  }
11
}

7. 布尔查询(高级查询)

31
1
GET goods/_search
2
{
3
  "query": {
4
    "bool": {
5
      "must": [
6
        {"match": {
7
          "title": "手机"
8
        }}
9
      ],
10
      "must_not": [
11
        {"term": {
12
          "price": {
13
            "value": "2799"
14
          }
15
        }}
16
      ],
17
      "should": [
18
        {"multi_match": {
19
            "query": "小米",
20
            "fields": ["title","subTitle"]
21
          }
22
        }
23
      ]
24
    }
25
  }
26
}
27

28
上述语句地含义为：
29
1. 必须满足："title包含手机"
30
2. 不能满足："price为2799"
31
3. 最好满足："title或subTitle包含小米"

8. 查询过滤

20
1
GET goods/_search
2
{
3
  "query": {
4
    "bool": {
5
      "must": [
6
        {"match": {
7
          "title": "小米"
8
        }}
9
      ],
10
      "filter": {
11
        "range": {
12
          "price": {
13
            "gte": 2699,
14
            "lte": 2799
15
          }
16
        }
17
      }
18
    }
19
  }
20
}

第五节 结果集操作

1. 结果列过滤

17
1
GET /goods/_search
2
{
3
  "_source": ["title","price"], 
4
  "query": {
5
    "match_all": {}
6
  }
7
}
8

9
GET /goods/_search
10
{
11
  "_source": {
12
    "excludes": ["price","images"]
13
    }, 
14
  "query": {
15
    "match_all": {}
16
  }
17
}

2. 结果排序

1) 单字段排序

13
1
GET goods/_search
2
{
3
  "query": {
4
    "match_all": {}
5
  },
6
  "sort": [
7
    {
8
      "price": {
9
        "order": "desc"
10
      }
11
    }
12
  ]
13
}

2) 多字段排序

10
1
GET /goods/_search
2
{
3
    "query": {
4
    "match_all": {}
5
  },
6
    "sort": [
7
      { "price": { "order": "desc" }},
8
      { "_score": { "order": "desc" }}
9
    ]
10
}

3. 结果聚合

1) 聚合为桶

11
1
GET /cars/_search
2
{
3
  "size": 0,
4
  "aggs": {
5
    "popular_colors": {
6
      "terms": {
7
        "field": "color"
8
      }
9
    }
10
  }
11
}

2) 桶内度量

18
1
GET /cars/_search
2
{
3
  "size": 0,
4
  "aggs": {
5
    "popular_colors": {
6
      "terms": {
7
        "field": "color"
8
      },
9
      "aggs": {
10
        "avg_price": {
11
          "avg": {
12
            "field": "price"
13
          }
14
        }
15
      }
16
    }
17
  }
18
}

3) 桶内嵌套桶

23
1
GET /cars/_search
2
{
3
  "size": 0,
4
  "aggs": {
5
    "popular_colors": {
6
      "terms": {
7
        "field": "color"
8
      },
9
      "aggs": {
10
        "avg_price": {
11
          "avg": {
12
            "field": "price"
13
          }
14
        },
15
        "maker":{
16
          "terms": {
17
            "field": "make"
18
          }
19
        }
20
      }
21
    }
22
  }
23
}

4) 阶梯分桶

13
1
GET cars/_search
2
{
3
  "size": 0,
4
  "aggs": {
5
    "price_agg": {
6
      "histogram": {
7
        "field": "price",
8
        "interval": 5000,
9
        "min_doc_count": 1
10
      }
11
    }
12
  }
13
}