# elasticsearch在kibana中的操作代码 \`\`\`json GET _search { "query": { "match_all": {} } } # 测试es是否连接 GET / # 测试分词器 POST /_analyze { "text": "这是一首简单的歌曲songs嘤嘤嘤,哦买噶，白嫖简直就是奥利给蓝瘦香菇", "analyzer": "ik_smart" } # 创建索引库 PUT /hgh { "mappings": { "properties": { "info":{ "type": "text", "analyzer": "ik_smart" }, "email":{ "type": "keyword", "index": false }, "name":{ "properties": { "firstName": { "type": "keyword" } } } } } } # 查看索引库 GET /hgh # 修改索引库 PUT /hgh/_mapping { "properties": { "age":{ "type": "long" } } } # 删除索引库 DELETE /hgh # 新增文档 POST /hgh/_doc/1 { "info": "黑马程序员高级Java讲师", "email": "zy@itcast.cn", "name": { "firstName": "云", "lastName": "赵" } } # 修改文档（全量修改） PUT /hgh/_doc/1 { "info": "黑马程序员高级Java讲师", "email": "zy@itcast.cn", "name": { "firstName": "云", "lastName": "赵" } } # 修改文档（局部修改） POST /hgh/_update/1 { "doc": { "email": "23718494529@qq.com" } } # 查询文档 GET /hgh/_doc/1 #删除文档 DELETE /hgh/_doc/1 PUT /hotel { "mappings": { "properties": { "id": { "type": "keyword" }, "name":{ "type": "text", "analyzer": "ik_max_word", "copy_to": "all" }, "address":{ "type": "keyword", "index": false }, "price":{ "type": "integer" }, "score":{ "type": "integer" }, "brand":{ "type": "keyword", "copy_to": "all" }, "city":{ "type": "keyword", "copy_to": "all" }, "starName":{ "type": "keyword" }, "business":{ "type": "keyword" }, "location":{ "type": "geo_point" }, "pic":{ "type": "keyword", "index": false }, "all":{ "type": "text", "analyzer": "ik_max_word" } } } } DELETE /hotel GET /hotel GET /hotel/_doc/38665 # 批量查询 GET /hotel/_search # 查询所有 GET /hotel/_search { "query": { "match_all": {} } } # 全文检索 ## match查询 GET /hotel/_search { "query": { "match": { "all": "外滩" } } } ## multi_match查询(字段越多，效率越低) GET /hotel/_search { "query": { "multi_match": { "query": "外滩如家", "fields": \["brand","name","business"\] } } } # 精确查询 ## term查询 GET /hotel/_search { "query": { "term": { "city": { "value": "北京" } } } } ## rang查询 (greater than or equal 大于等于 less than or equal 小于等于) GET /hotel/_search { "query": { "range": { "price": { "gte": 100, "lte": 500 } } } } GET /hotel/_search { "query": { "range": { "price": { "gt": 100, "lt": 500 } } } } # 地理查询 ## geo_bounding_box查询(矩形范围查询) GET /hotel/_search { "query": { "geo_bounding_box": { "location": { "top_left": { "lat": 31.1, "lon": 121.5 }, "bottom_right": { "lat": 30.9, "lon": 121.7 } } } } } ## geo_distance查询（距离查询） GET /hotel/_search { "query": { "geo_distance":{ "distance": "2km", "location": "31.21, 121.5" } } } # 复合查询 ## function score查询 GET /hotel/_search { "query": { "function_score": { "query": {"match": { "all": "外滩" }}, "functions": \[ { "filter": { "term": { "brand": "7天酒店" } }, "weight": 2 } \], "boost_mode": "sum" } } } ## Boolean Query（布尔查询） GET /hotel/_search { "query": { "bool": { "must": \[ {"term": {"city": "上海" }} \], "should": \[ {"term": {"brand": "皇冠假日" }}, {"term": {"brand": "华美达" }} \], "must_not": \[ { "range": { "price": { "lte": 500 } }} \], "filter": \[ { "range": {"score": { "gte": 45 } }} \] } } } # sort排序 GET /hotel/_search { "query": { "match_all": {} }, "sort": \[ { "score": "desc" } \] } GET /hotel/_search { "query": { "match_all": {} }, "sort": \[ { "_geo_distance": { "location": { "lat": 39.906466, "lon": 116.409279 }, "order": "asc", "unit": "km" } } \] } # 分页查询 GET /hotel/_search { "query": { "match_all": {} }, "from": 9991, "size": 100, "sort": \[ { "_geo_distance": { "location": { "lat": 39.906466, "lon": 116.409279 }, "order": "asc", "unit": "km" } } \] } # 高亮查询,默认情况下，es搜索字段必须与高亮字段一致 GET /hotel/_search { "query": { "match": { "all": "如家" } }, "highlight": { "fields": { "name": { "pre_tags": "*", "post_tags": "*" , "require_field_match": "false" } } } } POST /hotel/_update/60935 { "doc": { "isAD": true } } # 聚合功能 ## Bucket聚合 GET /hotel/_search { "size": 0, "aggs": { "brandAgg": { "terms": { "field": "brand", "size": 50 } } } } ## Bucket聚合（桶聚合）,自定义排序规则 GET /hotel/_search { "size": 0, "aggs": { "brandAgg": { "terms": { "field": "brand", "order": { "_count": "asc" }, "size": 50 } } } } ## Bucket聚合,限定聚合范围 GET /hotel/_search { "query": { "range": { "price": { "gte": 100, "lte": 200 } } }, "size": 0, "aggs": { "brandAgg": { "terms": { "field": "brand", "size": 50 } } } } ## Metric聚合（度量聚合），与Bucket聚合嵌套使用，获取每个品牌的评分的min、avg等 GET /hotel/_search { "size": 0, "aggs": { "brandAgg": { "terms": { "field": "brand", "size": 50 }, "aggs": { "score_stats": { "stats": { "field": "score" } } } } } } ## Metric聚合（度量聚合），与Bucket聚合嵌套使用，根据avg进行排序 GET /hotel/_search { "size": 0, "aggs": { "brandAgg": { "terms": { "field": "brand", "size": 50, "order": { "score_stats.avg": "desc" } }, "aggs": { "score_stats": { "stats": { "field": "score" } } } } } } # 拼音分词器测试 POST /_analyze { "text":\["寻龙分金看缠山，一重缠是一重关；关门如有八重险，不出阴阳八卦形。"\], "analyzer": "pinyin" } # 自定义拼音分词器,搜索时也使用自定义拼音分词库 PUT /test { "settings": { "analysis": { "analyzer": { "my_analyzer": { "tokenizer": "ik_max_word", "filter": "py" } }, "filter": { "py": { "type": "pinyin", "keep_full_pinyin": false, "keep_joined_full_pinyin": true, "keep_original": true, "limit_first_letter_length": 16, "remove_duplicated_term": true, "none_chinese_pinyin_tokenize": false } } } }, "mappings": { "properties": { "name": { "type": "text", "analyzer": "my_analyzer" } } } } # 自定义拼音分词器测试 POST /test/_analyze { "text":\["寻龙分金看缠山，一重缠是一重关；关门如有八重险，不出阴阳八卦形。"\], "analyzer": "my_analyzer" } POST /test/_doc/1 { "id": 1, "name": "狮子" } POST /test/_doc/2 { "id": 2, "name": "虱子" } GET /test/_search { "query": { "match": { "name": "掉入狮子笼咋办" } } } # 删除自定义分词器 DELETE /test # 自定义拼音分词器,搜索时ik分词库(搜索时应避免使用拼音分词器) PUT /test { "settings": { "analysis": { "analyzer": { "my_analyzer": { "tokenizer": "ik_max_word", "filter": "py" } }, "filter": { "py": { "type": "pinyin", "keep_full_pinyin": false, "keep_joined_full_pinyin": true, "keep_original": true, "limit_first_letter_length": 16, "remove_duplicated_term": true, "none_chinese_pinyin_tokenize": false } } } }, "mappings": { "properties": { "name": { "type": "text", "analyzer": "ik_max_word" } } } } # 自动补全 ## 自动补全的索引库（类型为completion类型） PUT /test2 { "mappings": { "properties": { "title":{ "type": "completion" } } } } ## 示例数据（字段值为多词条的数组） POST test2/_doc { "title": \["Sony", "WH-1000XM3"\] } POST test2/_doc { "title": \["SK-II", "PITERA"\] } POST test2/_doc { "title": \["Nintendo", "switch"\] } ## 自动补全查询 GET /test2/_search { "suggest": { "titleSuggest": { "text": "s", "completion": { "field": "title", "skip_duplicates": true, "size": 10 } } } } DELETE /hotel # 酒店数据索引库 PUT /hotel { "settings": { "analysis": { "analyzer": { "text_anlyzer": { "tokenizer": "ik_max_word", "filter": "py" }, "completion_analyzer": { "tokenizer": "keyword", "filter": "py" } }, "filter": { "py": { "type": "pinyin", "keep_full_pinyin": false, "keep_joined_full_pinyin": true, "keep_original": true, "limit_first_letter_length": 16, "remove_duplicated_term": true, "none_chinese_pinyin_tokenize": false } } } }, "mappings": { "properties": { "id":{ "type": "keyword" }, "name":{ "type": "text", "analyzer": "text_anlyzer", "search_analyzer": "ik_smart", "copy_to": "all" }, "address":{ "type": "keyword", "index": false }, "price":{ "type": "integer" }, "score":{ "type": "integer" }, "brand":{ "type": "keyword", "copy_to": "all" }, "city":{ "type": "keyword" }, "starName":{ "type": "keyword" }, "business":{ "type": "keyword", "copy_to": "all" }, "location":{ "type": "geo_point" }, "pic":{ "type": "keyword", "index": false }, "all":{ "type": "text", "analyzer": "text_anlyzer", "search_analyzer": "ik_smart" }, "suggestion":{ "type": "completion", "analyzer": "completion_analyzer" } } } } # 查看索引库所有数据 GET /hotel/_search { "query": { "match_all": {} } } # 再次测试自动补全功能 GET /hotel/_search { "suggest": { "suggestion": { "text": "hq", "completion": { "field": "suggestion", "skip_duplicates": true, "size": 100 } } } } \`\`\`