Elasticsearch7教程

# 解决端口 9100 访问 9200 跨域问题
http.cors.enabled: true
http.cors.allow-origin: "*"

# 改成中文
i18n.locale: "zh-CN"

# 查询 movies 的数据
GET movies/_search

# 查询 movies 的数量
GET movies/_count

# 查看所有的索引
GET _cat/indices

# 查询id为24的数据
GET movies/_doc/24

# 添加新的文档，如果没有指定id，ES会自动生成id
POST users/_doc
{
  "firstname": "will",
  "lastname": "smith"
}


# 添加id为2的文档，ES不会自动生成id
POST users/_doc/2
{
  "firstname": "will2",
  "lastname": "smith2"
}

# 查询 users 的数据
GET users/_search

# 创建id为2的文档，如果索引中已经存在相同的id，会报错，创建失败；如果不存在相同的id，则创建成功
POST users/_create/2
{
  "firstname": "will2",
  "lastname": "smith2"
}

# 更新id为2的文档，更新指定field
POST users/_update/2
{
  "doc": {
    "firstname": "jack",
    "lastname": "well"
  }
}

# 更新id为2的文档，添加一个field
POST users/_update/2
{
  "doc": {
    "age": 30
  }
}

# 删除id为2的文档
DELETE users/_doc/2

# 删除 users 索引
DELETE users

# 创建或修改id为1的文档
PUT users/_doc/1
{
  "firstname": "jack",
  "lastname": "ma"
}

# 创建id为2的文档，如果索引中已经存在相同的id，会报错，创建失败；如果不存在相同的id，则创建成功
PUT users/_create/2
{
  "firstname": "will",
  "lastname": "smith"
}

# 批量查询多个指定index的指定field的值
GET _mget 
{
  "docs" : [
   {"_index": "users", "_id": 1},
   {"_index": "users", "_id": 2}
  ]
}

# 批量插入数据，如果id不存在，则创建；如果id存在，则更新
POST users/_bulk 
{"index" : {"_id" : 3}}
{"firstname": "A", "lastname": "a"}
{"index" : {"_id" : 4}}
{"firstname": "B", "lastname": "b"}
{"index" : {"_id" : 5}}
{"firstname": "C", "lastname": "c"}

# 查询title中包含2012的所有电影
GET movies/_search?q=2012

# 查询title中包含2012的所有电影，df（default field）
GET movies/_search?q=2012&df=title

# 查询title中包含2012的所有电影
GET movies/_search?q=title:2012

# 查询title中包含2012的所有电影，从第10条开始算起（不包含第10条），查询8条数据
GET movies/_search?q=title:2012&from=10&size=8

# 查询title中包含Beautiful或Mind的所有数据
GET movies/_search?q=title:Beautiful Mind
GET movies/_search?q=title:(Beautiful Mind)
GET movies/_search?q=title:(+Beautiful +Mind)

# 查询title中包含"Beautiful Mind"这个短语的所有数据
GET movies/_search?q=title:"Beautiful Mind"

# 查询title中既包含Mind，又包含Beautiful的所有数据
GET movies/_search?q=title:(Mind AND Beautiful)

# 查询title中包含Mind，或包含Beautiful的所有数据
GET movies/_search?q=title:(Mind OR Beautiful)

# 查询title中包含Beautiful但不包含Mind的所有数据
GET movies/_search?q=title:(Beautiful NOT Mind)
GET movies/_search?q=title:(Beautiful -Mind)

# 查询title中包含Beautiful且电影上映时间在2012年之后的所有数据
GET movies/_search?q=title:Beautiful AND year:>=2012

# 查询电影上映时间在2018年之后的所有数据
GET movies/_search?q=year:>=2018

# 注意[空格]格式问题
# 查询在2012到2017年的所有数据
GET movies/_search?q=year:(>=2012 AND <2018)

# 查询2016年到2017年上映的电影，开头可以是 { [，但必须以 ] 结尾
GET movies/_search?q=year:{2015 TO 2017]

# ? 代表一个字母
GET movies/_search?q=title:Min?

# 查询title中包含以Min开头的字母的电影
GET movies/_search?q=title:Min*

GET _analyze
{
  "analyzer": "standard",
  "text": ["2 Running quick brown-foxes leap over lazy dog in the summer evening"]
}

GET _analyze
{
  "analyzer": "simple",
  "text": ["2 Running quick brown-foxes leap over lazy dog in the summer evening"]
}

GET _analyze
{
  "analyzer": "stop",
  "text": ["2 Running quick brown-foxes leap over lazy dog in the summer evening"]
}

GET _analyze
{
  "analyzer": "whitespace",
  "text": ["2 Running quick brown-foxes leap over lazy dog in the summer evening"]
}

GET _analyze
{
  "analyzer": "keyword",
  "text": ["2 Running quick brown-foxes leap over lazy dog in the summer evening"]
}

GET _analyze
{
  "analyzer": "pattern",
  "text": ["2 Running quick brown-foxes leap over lazy dog in the summer evening"]
}

# 查询电影名字中包含有 beautiful 这个单词的所有电影，对于输入的单词不会进行分词的处理。
GET movies/_search
{
  "query": {
    "term": {
      "title": {
        "value": "beautiful"
      }
    }
  }
}

# 查询电影名字中包含有 beautiful 或者 mind 的所有电影，对于输入的单词不会进行分词的处理。
GET movies/_search
{
  "query": {
    "terms": {
      "title": [
        "beautiful",
        "mind"
      ]
    }
  }
}

# 查询上映时间在2016到2018年的所有电影，根据上映时间进行倒序排序
GET movies/_search
{
  "query": {
    "range": {
      "year": {
        "gte": 2016,
        "lte": 2018
      }
    }
  },
  "sort": [
    {
      "year": {
        "order": "desc"
      }
    }
  ]
}

# 查询 title 中包含 beautiful 的所有电影，不进行相关算分，查询数据进行缓存，提高效率
GET movies/_search
{
  "query": {
    "constant_score": {
      "filter": {
        "term": {
          "title": "beautiful"
        }
      }
    }
  }
}

# 查询电影名字中包含有 beautiful 的所有数据，每页10条，取第二页数据
GET movies/_search
{
  "query": {
    "match": {
      "title": "beautiful"
    }
  },
  "from": 1,
  "size": 10
}

# 查询电影名字中包含有 beautiful 或者 mind 的所有数据，但只显示 title 和 id 这两个属性
GET movies/_search
{
  "_source": ["title", "id"],
  "query": {
    "match": {
      "title": "beautiful mind"
    }
  }
}

# 查询电影名字中包含 beautiful mind 这个短语的所有数据
GET movies/_search
{
  "query": {
    "match_phrase": {
      "title": "beautiful mind"
    }
  }
}

# 查询 title 或 genre 中包含有 beautiful 或 Adventure 的所有数据
GET movies/_search
{
  "query": {
    "multi_match": {
      "query": "beautiful Adventure",
      "fields": ["title", "genre"]
    }
  }
}

# 查询所有数据
GET movies/_search
{
  "query": {
    "match_all": {}
  }
}

# 查询 title 中包含 beautiful 和 mind 的所有电影
GET movies/_search
{
  "query": {
    "query_string": {
      "default_field": "title",
      "query": "mind AND beautiful"
    }
  }
}


GET movies/_search
{
  "query": {
    "query_string": {
      "default_field": "title",
      "query": "mind beautiful",
      "default_operator": "AND"
    }
  }
}

# 查询 title 中包含 beautiful 和 mind 的所有电影
GET movies/_search
{
  "query": {
    "simple_query_string": {
      "query": "beautiful + mind",
      "fields": ["title"]
    }
  }
}


GET movies/_search
{
  "query": {
    "simple_query_string": {
      "query": "beautiful mind",
      "fields": ["title"],
      "default_operator": "AND"
    }
  }
}


# 查询 title 中包含 beautiful mind 这个短语的所有电影（用法类似 match_phrase）
GET movies/_search
{
  "query": {
    "simple_query_string": {
      "query": "\"beautiful mind\"",
      "fields": ["title"]
    }
  }
}


# 查询 title 或 genre 中包含 beautiful 或 mind 的所有电影（用法类似 multi_match）
GET movies/_search
{
  "query": {
    "simple_query_string": {
      "query": "beautiful mind",
      "fields": ["title", "genre"]
    }
  }
}


# 查询 title 中包含 beautiful mind 或者 Modern Romance 这两个短语的所有电影
GET movies/_search
{
  "query": {
    "simple_query_string": {
      "query": "\"beautiful mind\" | \"Modern Romance\"",
      "fields": ["title"]
    }
  }
}


# 查询 title 或者 genre 中包含 beautiful 和 mind 这两个词，或者 Comedy 和 Romance 和 Musical 和 Drama 和 Children 这五个词的所有数据
GET movies/_search
{
  "query": {
    "simple_query_string": {
      "query": "(beautiful + mind) | (Comedy + Romance + Musical + Drama + Children)",
      "fields": ["title", "genre"]
    }
  }
}


# 查询 title 中包含 beautiful 和 people，但不包含 Animals 的所有数据
GET movies/_search
{
  "query": {
    "simple_query_string": {
      "query": "beautiful + people + -Animals",
      "fields": ["title"]
    }
  }
}

# 查询 title中从第六个字母开始只要最多纠正一次，就与 neverendign 匹配的所有数据
GET movies/_search
{
  "query": {
    "fuzzy": {
      "title": {
        "value": "neverendign",
        "fuzziness": 1,
        "prefix_length": 5
      }
    }
  }
}

# 查询 title 中包含 beautiful 或 mind 单词，并且上映时间在 2016到2018 年的所有数据
GET movies/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "simple_query_string": {
            "query": "beautiful mind",
            "fields": ["title"]
          }
        },
        {
          "range": {
            "year": {
              "gte": 2016,
              "lte": 2018
            }
          }
        }
      ]
    }
  }
}

# 查询 title 中包含 beautiful 单词，并且上映年份在 2016到2018 年的所有数据，但不会进行相关行算分
GET movies/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "term": {
            "title": "beautiful"
          }
        },
        {
          "range": {
            "year": {
              "gte": 2016,
              "lte": 2018
            }
          }
        }
      ]
    }
  }
}

PUT users
{
  "mappings": {
       // mapping信息
  }
}

PUT users
{
  "mappings": {
    "properties": {
      "id": {
        "type": "integer"
      },
      "name": {
        "type": "keyword"
      },
      "job": {
        "type": "keyword"
      },
      "age": {
        "type": "integer"
      },
      "gender": {
        "type": "keyword"
      }
    }
  }
}

PUT users/_bulk
{"index": {"_id": 1}} 
{"id": 1, "name": "Bob", "job": "java", "age": 21, "sal": 8000, "gender": "female"} 
{"index": {"_id": 2}}
{"id": 2, "name": "Rod", "job": "html", "age": 31, "sal": 18000, "gender": "female"} 
{"index": {"_id": 3}} 
{"id": 3, "name": "Gaving", "job": "java", "age": 24, "sal": 12000, "gender": "male"} 
{"index": {"_id": 4}} 
{"id": 4, "name": "King", "job": "dba", "age": 26, "sal": 15000, "gender": "female"} 
{"index": {"_id": 5}} 
{"id": 5, "name": "Jonhson", "job": "dba", "age": 29, "sal": 16000, "gender": "male"} 
{"index": {"_id": 6}} 
{"id": 6, "name": "Douge", "job": "java", "age": 41, "sal": 20000, "gender": "female"} 
{"index": {"_id": 7}} 
{"id": 7, "name": "cutting", "job": "dba", "age": 27, "sal": 7000, "gender": "male"} 
{"index": {"_id": 8}} 
{"id": 8, "name": "Bona", "job": "html", "age": 22, "sal": 14000, "gender": "female"}
{"index": {"_id": 9}} 
{"id": 9, "name": "Shyon", "job": "dba", "age": 20, "sal": 19000, "gender": "female"} 
{"index": {"_id": 10}} 
{"id": 10, "name": "James", "job": "html", "age": 18, "sal": 22000, "gender": "male"}
{"index": {"_id": 11}} 
{"id": 11, "name": "Golsling", "job": "java", "age": 32, "sal": 23000, "gender": "female"} 
{"index": {"_id": 12}} 
{"id": 12, "name": "Lily", "job": "java", "age": 24, "sal": 2000, "gender": "male"} 
{"index": {"_id": 13}} 
{"id": 13, "name": "Jack", "job": "html", "age": 23, "sal": 3000, "gender": "female"} 
{"index": {"_id": 14}} 
{"id": 14, "name": "Rose", "job": "java", "age": 36, "sal": 6000, "gender": "female"} 
{"index": {"_id": 15}} 
{"id": 15, "name": "Will", "job": "dba", "age": 38, "sal": 4500, "gender": "male"} 
{"index": {"_id": 16}} 
{"id": 16, "name": "smith", "job": "java", "age": 32, "sal": 23000, "gender": "male"}

GET indexName/_search
{
  "aggs": {
    "aggs_name": {  // 名字自定义
      "AGG_TYPE": {
        // aggregation body
      }
    }
  }
}

# 查询总和工资
GET users/_search
{
  "size": 0, 
  "aggs": {
    "sal_sum": {
      "sum": {
        "field": "sal"
      }
    }
  }
}


# 查询平均工资
GET users/_search
{
  "size": 0,
  "aggs": {
    "avg_sal": {
      "avg": {
        "field": "sal"
      }
    }
  }
}


# 查询总共有多少个岗位，cardinality的值类似于sql中的count distinct，即去重统计总数
GET users/_search
{
  "size": 0,
  "aggs": {
    "count_job": {
      "cardinality": {
        "field": "job"
      }
    }
  }
}

# 查询工资的信息（数量、最大、最小、平均、总数）
GET users/_search
{
  "size": 0,
  "aggs": {
    "stats_sal": {
      "stats": {
        "field": "sal"
      }
    }
  }
}


# 查询到达不同城市的航班数量
GET kibana_sample_data_flights/_search
{
  "size": 0,
  "aggs": {
    "terms_flight_dest": {
      "terms": {
        "field": "DestCountry"
      }
    }
  }
}


# 查询每个岗位有多少人数
GET users/_search
{
  "size": 0,
  "aggs": {
    "terms_job": {
      "terms": {
        "field": "job"
      }
    }
  }
}


# 查询目的地的航班次数以及天气信息
GET kibana_sample_data_flights/_search
{
  "size": 0,
  "aggs": {
    "terms_dest_city": {
      "terms": {
        "field": "DestCityName"
      },
      "aggs": {
        "terms_whether_info": {
          "terms": {
            "field": "DestWeather"
          }
        }
      }
    }
  }
}


# 查询每个岗位下工资的信息（平均、最高、最低）
GET users/_search
{
  "size": 0,
  "aggs": {
    "terms_job_info": {
      "terms": {
        "field": "job"
      },
      "aggs": {
        "stats_sal_info": {
          "stats": {
            "field": "sal"
          }
        }
      }
    }
  }
}


# 查询不同工种的男女数量，然后统计不同工种下男女员工的工资信息
GET users/_search
{
  "size": 0,
  "aggs": {
    "terms_job_info": {
      "terms": {
        "field": "job"
      },
      "aggs": {
        "terms_gender_info": {
          "terms": {
            "field": "gender"
          },
          "aggs": {
            "stats_sal_info": {
              "stats": {
                "field": "sal"
              }
            }
          }
        }
      }
    }
  }
}


# 查询年龄最大的两位员工的信息
GET users/_search
{
  "size": 0,
  "aggs": {
    "top_age_2": {
      "top_hits": {
        "size": 2,
        "sort": [
          {
            "age": {
              "order": "desc"
            }
          }  
        ]
      }
    }
  }
}


# 查询不同区间人员的工资统计信息
GET users/_search
{
  "size": 0,
  "aggs": {
    "range_sal_info": {
      "range": {
        "field": "sal",
        "ranges": [
          {
            "key": "0 <= sal <= 5000", 
            "from": 0,
            "to": 5000
          },
          {
            "key": "5001 <= sal <= 10000",
            "from": 5001,
            "to": 10000
          }
        ]
      }
    }
  }
}


# 以直方图的方式以每5000元为一个区间查看工资信息
## interval：指定的值为一个区间
## extended_bounds：指定区间的范围
GET users/_search
{
  "size": 0,
  "aggs": {
    "histogram_sal_info": {
      "histogram": {
        "field": "sal",
        "interval": 5000,
        "extended_bounds": {
          "min": 0,
          "max": 30000
        }
      }
    }
  }
}


# 查询平均工资中最低工资的工种
GET users/_search
{
  "size": 0,
  "aggs": {
    "job_info": {
      "terms": {
        "field": "job"
      },
      "aggs": {
        "job_avg_sal": {
          "avg": {
            "field": "sal"
          }
        }
      }
    },
    "min_sal_job": {
      "min_bucket": {
        "buckets_path": "job_info>job_avg_sal"
      }
    }
  }
}


# 求工资和工种的信息
GET users/_search
{
  "size": 0,
  "aggs": {
    "job_info": {
      "terms": {
        "field": "job"
      }
    },
    "sal_info": {
      "stats": {
        "field": "sal"
      }
    }
  }
}


# 查询年龄大于30的员工的平均工资
GET users/_search
{
  "size": 0,
  "query": {
    "range": {
      "age": {
        "gte": 30
      }
    }
  },
  "aggs": {
    "avg_sal": {
      "avg": {
        "field": "sal"
      }
    }
  }
}


# 查询Java员工的平均工资
GET users/_search
{
  "size": 0,
  "query": {
    "constant_score": {
      "filter": {
        "term": {
          "job": "java"
        }
      },
      "boost": 1.2
    }
  },
  "aggs": {
    "avg_sal": {
      "avg": {
        "field": "sal"
      }
    }
  }
}


# 查询30岁以上的员工的平均工资和所有的工种信息
GET users/_search
{
  "size": 0,
  "aggs": {
    "older_emp": {
      "filter": {
        "range": {
          "age": {
            "gte": 30
          }
        }
      },
      "aggs": {
        "avg_sal": {
          "avg": {
            "field": "sal"
          }
        }
      }
    },
    "job_info": {
      "terms": {
        "field": "job"
      }
    }
  }
}

GET movies/_search
{
  "suggest": {
    # 自定义的名称
    "title_suggestion": {
      "text": "drema",
      "term": {
        "field": "title",
        "suggest_mode": "popular"
      }
    }
  }
}

GET movies/_search
{
  "query": {
    "match": {
      "title": "beautiful"
    }
  },
  "highlight": {
    "pre_tags": "<span color='red'>",   # 需要高亮文本的前置 html 内容
    "post_tags": "</span>",             # 需要高亮文本的后置 html 内容
    "fields": {                         # 需要高亮的属性
      "title": {}
    }
  }
}