AI 助理
备案控制台
开发者社区 开发与运维 文章 正文

Elasticsearch系列之Query DSL

2020-07-14 583
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
本文涉及的产品
检索分析服务 Elasticsearch 版，2核4GB开发者规格 1个月
推荐场景：
数据可视化分析航班信息
简介： DSL是啥？由Elasticsearch提供的一套完整的JSON格式的查询语句。

1 前言

我们先通过阅读官方文档，了解一下什么是 Query DSL 。

1.1 Query DSL

Elasticsearch provides a full Query DSL (Domain Specific Language) based on JSON to define queries. 

DSL是啥？
由Elasticsearch提供的一套完整的JSON格式的查询语句。

Think of the Query DSL as an AST (Abstract Syntax Tree) of queries, consisting of two types of clauses:

Leaf query clauses
Leaf query clauses look for a particular value in a particular field, such as the match, term or range queries. These queries can be used by themselves.
**

Compound query clauses

Compound query clauses wrap other leaf or compound queries and are used to combine multiple queries in a logical fashion (such as the bool or dis_max query), or to alter their behaviour (such as the constant_score query).

两种查询类型：DSL和AST。
一种是根据查询关键字进行查询。
另一种就是符合查询。

Query clauses behave differently depending on whether they are used in query context or filter context.

由两种查询行为：
一种是你告诉我，你有多匹配。
另一种，通过筛选，剔除不满足条件的。

Allow expensive queries

Certain types of queries will generally execute slowly due to the way they are implemented, which can affect the stability of the cluster. Those queries can be categorised as follows:

根据行为的不同，查询速度也会有不同，而这些查询行为是非常缓慢的，可能还会影响集群的稳定性。

The execution of such queries can be prevented by setting the value of the search.allow_expensive_queries setting to false (defaults to true).

既然有这些问题，Elasticsearch也提供优化办法，就是禁用这些查询行为，默认是开启的。

1.2 官方文档

官方文档：https://www.elastic.co/guide/en/elasticsearch/reference/master/index.html
中文文档：https://www.elastic.co/guide/cn/elasticsearch/guide/current/index.html

1.3 Elasticsearch-head

1.3.1 概览界面

image.png

1.3.2 索引界面

image.png

1.3.3 数据浏览界面

image.png

1.3.4 基本查询界面

image.png

1.3.5 复合查询界面

image.png

1.4 测试介绍

1.4.1 接口地址

http://localhost:9200/spring-boot-elasticsearch-sample-phone/_search

1.4.2 提交方法

POST

1.4.3参数格式

JSON

1.4.4 Content-Type

application/json; charset=UTF-8

1.4.5 测试工具

image.png

1.4.6 测试索引

https://github.com/fengwenyi/spring-boot-elasticsearch-sample

1.4.7 测试数据

手机信息数据源，共 1253670 条数据，是从京东抓取的，耗时一天
点击下载：phone-info.json

2 基础需求

2.1 排序

{
    "query": {
        "match_all": {}
    },
    "sort": {
        "createTimeStamp": {
            "order": "desc"
        }
    }
}

响应示例片段

{
    "took": 7,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "RU8FM3MB3aBfAxkrRLZS",
                "_score": null,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "Redmi 红米7A 小米手机 老人机 磨砂黑 3+32G",
                    "ad": "【顺丰快递】【假一赔十】今日下单可送精美礼品",
                    "price": 619,
                    "imgUrl": "//img10.360buyimg.com/n7/jfs/t1/99921/22/11777/109099/5e3a8ec6E1af36352/a32b3017b2429c62.jpg",
                    "memory": "3GB运存",
                    "storage": "32GB",
                    "screen": "5.45英寸",
                    "createTimeStamp": 1594288850000,
                    "createTimeString": "2020-07-09 18:00:50,000"
                },
                "sort": [
                    1594288850000
                ]
            }
        ]
    }
}

2.1.1 升序

asc 或者 ASC

2.1.2 降序

desc 或者 DESC

2.2 分页

{
    "query": {
        "match_all": {}
    },
    "from": 1,
    "size": 1
}

响应示例

{
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 1.0,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "7j1PL3MB3aBfAxkrf0nz",
                "_score": 1.0,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "荣耀Play3 6.39英寸魅眼全视屏 4000mAh大电池 真4800万AI三摄 畅玩全网通 幻夜黑 全网通6G+64G",
                    "ad": "荣耀Play3 6.39英寸魅眼全视屏 4000mAh大电池 真4800万AI三摄 畅玩全网通 幻夜黑 全网通6G+64G",
                    "price": 999.0,
                    "imgUrl": "//img13.360buyimg.com/n7/jfs/t1/126334/20/1159/208111/5eba565cE6065f0bc/4184f6b681990d1d.png",
                    "memory": "6GB运存",
                    "storage": "64GB",
                    "screen": "6.39 英寸",
                    "createTimeStamp": 1594226606065,
                    "createTimeString": "2020-07-09 00:43:26,065"
                }
            }
        ]
    }
}

2.2.1 from

从第几个开始查询，最开始是0

2.2.2 size

要查几个结果

3 搜索关键字

3.1 match_all

搜索的分值都是1.0

"max_score": 1.0

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

响应示例片段

{
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 1,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "8z1PL3MB3aBfAxkrq0l2",
                "_score": 1,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "飞利浦E212A 翻盖按键超长待机 移动版双卡双待老人手机 学生备用功能机 飞利浦手机 深锖色（深蓝色）",
                    "ad": "咨询客服-领取优惠-下单立省-现货速发，15天价保，买贵补差价",
                    "price": 268,
                    "imgUrl": "//img10.360buyimg.com/n7/jfs/t1/24002/31/1438/337790/5c120bbeE6b9e6e12/befe00624e9a62a2.jpg",
                    "memory": "2GB以下运存",
                    "storage": "8GB以下",
                    "screen": "2.8英寸",
                    "createTimeStamp": 1594226617204,
                    "createTimeString": "2020-07-09 00:43:37,204"
                }
            }
        ]
    }
}

3.2 match_none

{
    "query": {
        "match_none": {}
    }
}

响应示例

{
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 0,
            "relation": "eq"
        },
        "max_score": null,
        "hits": []
    }
}

3.3 match

指定字段，根据字段的关键字进行搜索

{
    "query": {
        "match": {
            "name": "小米"
        }
    }
}

响应示例片段

{
    "took": 20,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 6.0416183,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "sjwvL3MB3aBfAxkrLKVH",
                "_score": 6.0416183,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "小米（MI） 小米Max3 手机 黑色（现货） 全网通6GB+128GB",
                    "ad": "【京东物流、现货急速发】送:本店质保一年+运费险小米Play到手价1158",
                    "price": 1599,
                    "imgUrl": "//img12.360buyimg.com/n7/jfs/t1/105432/6/3249/74410/5dde4fd1E9c28713b/f2aea9f8bf1672a7.jpg",
                    "memory": "6GB运存",
                    "storage": "128GB",
                    "screen": "6.9英寸",
                    "createTimeStamp": 1594224487494,
                    "createTimeString": "2020-07-09 00:08:07,494"
                }
            }
        ]
    }
}

3.4 query_string

全文搜索

{
    "query": {
        "query_string": {
            "query": "小米"
        }
    }
}

响应示例片段

{
    "took": 43,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 11.336194,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "mTwuL3MB3aBfAxkr3qO_",
                "_score": 11.336194,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "小米9 Pro 5G 骁龙855Plus 30W无线闪充 8GB+256GB 钛银黑 双卡全网通 全面屏拍照智能新品游戏手机",
                    "ad": "小米，小米手机，小米9pro5g自营，小米9pro，小米5g版，小米9品质好物选小米，京东选购更省钱",
                    "price": 3799,
                    "imgUrl": "//img14.360buyimg.com/n7/jfs/t1/84314/2/11219/125539/5d89b1c9Ec781523e/cd769d2bd022de2a.jpg",
                    "memory": "8GB运存",
                    "storage": "256GB",
                    "screen": "6.39英寸",
                    "createTimeStamp": 1594224467645,
                    "createTimeString": "2020-07-09 00:07:47,645"
                }
            }
        ]
    }
}

3.4.1 and

{
    "query": {
        "query_string": {
            "query": "小米 and 红米"
        }
    }
}

响应示例片段

{
    "took": 50,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 21.420961,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "MjwtL3MB3aBfAxkrM5ii",
                "_score": 21.420961,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "Redmi K30 Pro 5G先锋 骁龙865旗舰处理器 弹出式超光感全面屏 索尼6400万高清四摄 4700mAh长续航 33W闪充 8GB+128GB 天际蓝 游戏智能手机【优享】",
                    "ad": "王一博同款k30pro,小米,xiaomi,小米手机,红米,redmi,红米手机,redmik30pro,k30pro,小米k30pro,小米5G,红米5G新品",
                    "price": 3399,
                    "imgUrl": "//img10.360buyimg.com/n7/jfs/t1/110595/15/10135/430668/5e79b705E69c06b1d/3d098ac4c305cf78.jpg",
                    "memory": "8GB运存",
                    "storage": "128GB",
                    "screen": "6.67英寸",
                    "createTimeStamp": 1594224358305,
                    "createTimeString": "2020-07-09 00:05:58,305"
                }
            }
        ]
    }
}

3.4.2 or

{
    "query": {
        "query_string": {
            "query": "小米 or 华为"
        }
    }
}

响应示例片段

{
    "took": 53,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 11.336194,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "mTwuL3MB3aBfAxkr3qO_",
                "_score": 11.336194,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "小米9 Pro 5G 骁龙855Plus 30W无线闪充 8GB+256GB 钛银黑 双卡全网通 全面屏拍照智能新品游戏手机",
                    "ad": "小米，小米手机，小米9pro5g自营，小米9pro，小米5g版，小米9品质好物选小米，京东选购更省钱",
                    "price": 3799,
                    "imgUrl": "//img14.360buyimg.com/n7/jfs/t1/84314/2/11219/125539/5d89b1c9Ec781523e/cd769d2bd022de2a.jpg",
                    "memory": "8GB运存",
                    "storage": "256GB",
                    "screen": "6.39英寸",
                    "createTimeStamp": 1594224467645,
                    "createTimeString": "2020-07-09 00:07:47,645"
                }
            },
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "yDwuL3MB3aBfAxkrv6LX",
                "_score": 11.323852,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "华为 Mate20 X 全网通智能手机 幻影银（6+128）",
                    "ad": "送：原装耳机+小钢炮蓝牙音箱+钢化膜+保护壳！华为p30、华为p30Pro华为mate20Pro",
                    "price": 3588,
                    "imgUrl": "//img14.360buyimg.com/n7/jfs/t24652/329/2253404779/295465/198e1b99/5bc7f1ecNc23ec763.jpg",
                    "memory": "6GB运存",
                    "storage": "128GB",
                    "screen": "7.2英寸",
                    "createTimeStamp": 1594224459734,
                    "createTimeString": "2020-07-09 00:07:39,734"
                }
            }
        ]
    }
}

3.5 match_phrase

如果我们并不想那样进行分割，那我们换一个关键字 match_phrase

{
    "query": {
        "match_phrase": {
            "name": "小米红米"
        }
    }
}

响应示例片段

{
    "took": 42,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 1336,
            "relation": "eq"
        },
        "max_score": 10.831314,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "GjwvL3MB3aBfAxkr06nd",
                "_score": 10.831314,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "小米红米Note8pro 手机 电光灰 8G+128G",
                    "ad": "小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！",
                    "price": 1599,
                    "imgUrl": "//img11.360buyimg.com/n7/jfs/t1/74883/5/13866/102693/5db3b32eEe950fcbd/62ae450227788db6.jpg",
                    "memory": "6GB运存",
                    "storage": "128GB",
                    "screen": "6.53英寸",
                    "createTimeStamp": 1594224530395,
                    "createTimeString": "2020-07-09 00:08:50,395"
                }
            }
        ]
    }
}

3.6 term

主要用于数字匹配。

举例：查询价格为1999的手机

{
    "query": {
        "term": {
            "price": 1999
        }
    }
}

响应示例片段

{
    "took": 15,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 1,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "_z1PL3MB3aBfAxkrrEkR",
                "_score": 1,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "华为 nova5i手机 后置AI四摄 全面屏 前置2400万高清 全网通双卡双待4G 幻夜黑 全网通8+128",
                    "ad": "华为（HUAWEI） nova 5i",
                    "price": 1999,
                    "imgUrl": "//img11.360buyimg.com/n7/jfs/t1/72502/14/4150/92863/5d2561a5Ed843b841/74dece57677911e3.jpg",
                    "storage": "128GB",
                    "createTimeStamp": 1594226617360,
                    "createTimeString": "2020-07-09 00:43:37,360"
                }
            }
        ]
    }
}

3.7 range

范围查询

举例：查询价格在1000-2000之间的手机

{
    "query": {
        "range": {
            "price": {
                "gte": 1000,
                "lte": 2000
            }
        }
    }
}

响应示例片段

{
    "took": 31,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 1,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "8j1PL3MB3aBfAxkrq0lp",
                "_score": 1,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "小米 Redmi 红米K30 极速版 5G手机 深海微光 6GB+128GB",
                    "ad": "5G双模，120Hz流速屏，骁龙768G，前置挖孔双摄，索尼6400万后置四摄，30W快充！K30i新品",
                    "price": 1599,
                    "imgUrl": "//img12.360buyimg.com/n7/jfs/t1/111819/3/6275/81916/5eba1a81Ee5a49643/cb43bd5ca9139ded.jpg",
                    "memory": "6GB运存",
                    "storage": "128GB",
                    "screen": "6.67英寸",
                    "createTimeStamp": 1594226617192,
                    "createTimeString": "2020-07-09 00:43:37,192"
                }
            }
        ]
    }
}

3.7.1 gt

大于

3.7.2 lt

小于

3.7.3 gte

大于等于

3.7.4 lte

小于等于

3.8 filter

在查询过程中，只判断文档是否满足条件，只有Yes或者No。

举例：查询价格为1999的手机

{
    "query": {
        "bool": {
            "filter": {
                "term": {
                    "price": 1999
                }
            }
        }
    }
}

响应示例片段

{
    "took": 5,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 0.0,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "_z1PL3MB3aBfAxkrrEkR",
                "_score": 0.0,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "华为 nova5i手机 后置AI四摄 全面屏 前置2400万高清 全网通双卡双待4G 幻夜黑 全网通8+128",
                    "ad": "华为（HUAWEI） nova 5i",
                    "price": 1999.0,
                    "imgUrl": "//img11.360buyimg.com/n7/jfs/t1/72502/14/4150/92863/5d2561a5Ed843b841/74dece57677911e3.jpg",
                    "storage": "128GB",
                    "createTimeStamp": 1594226617360,
                    "createTimeString": "2020-07-09 00:43:37,360"
                }
            }
        ]
    }
}

3.9 multi_match

3.9.1 query

要查询的关键字

3.9.2 fileds

要查询的字段

3.9.3 type

 best_fields

最佳字段。best_fields 类型是默认值，可以不指定。

most_fields

多数字段。多数字段匹配成功的得分之和，字段匹配越多，得分越高

cross_fields

cross_fields指的是一个唯一标识，跨域了多个字段，比如人的标识是名字，一个建筑的标识是地址，姓名跨域散落在多个field中，比如first_name和last_name，一个地址也可以散落在多个字段中，比如country,province,city中。

3.9.4 operator

operator使用and，是要返回两者同时匹配成功的结果。

3.9.5 tie_breaker

tie_breaker是将其它匹配的查询子句考虑进来也是可能的。通过指定tie_breaker参数将其它每个匹配的子句的分值乘以tie_breaker，以达到取得最佳匹配查询子句的_score。

示例：

{
    "query": {
        "multi_match": {
            "query": "一加",
            "fields": [
                "name",
                "ad"
            ],
            "type": "cross_fields",
            "operator": "and"
        }
    }
}

响应示例片段：

{
    "took": 16,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 83,
            "relation": "eq"
        },
        "max_score": 16.650242,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "OjwtL3MB3aBfAxkrDpfE",
                "_score": 16.650242,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "一加 OnePlus 8 5G旗舰 90Hz高清柔性屏 骁龙865 180g轻薄手感 12GB+256GB 青空 超清超广角拍照游戏手机",
                    "ad": "一加 8",
                    "price": 4599.0,
                    "imgUrl": "//img11.360buyimg.com/n7/jfs/t1/120981/4/3752/79431/5ed5aba3Ead96f265/23e94e5f9fa168d7.jpg",
                    "memory": "12GB运存",
                    "storage": "256GB",
                    "createTimeStamp": 1594224348866,
                    "createTimeString": "2020-07-09 00:05:48,866"
                }
            }
        ]
    }
}

要想了解更多，可以看官方文档：Elasticsearch权威指南：multi_match 查询

4 复合查询

4.1 constant_score

固定分数查询。支持filter查询，不支持match查询。

举例，查询分数为10的小米手机

{
    "query":{
        "constant_score":{
            "filter":{
                "match":{
                    "name":"小米"
                }
            },
            "boost":10
        }
        
    }
}

响应示例片段

{
    "took": 4,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 10,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "8j1PL3MB3aBfAxkrq0lp",
                "_score": 10,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "小米 Redmi 红米K30 极速版 5G手机 深海微光 6GB+128GB",
                    "ad": "5G双模，120Hz流速屏，骁龙768G，前置挖孔双摄，索尼6400万后置四摄，30W快充！K30i新品",
                    "price": 1599,
                    "imgUrl": "//img12.360buyimg.com/n7/jfs/t1/111819/3/6275/81916/5eba1a81Ee5a49643/cb43bd5ca9139ded.jpg",
                    "memory": "6GB运存",
                    "storage": "128GB",
                    "screen": "6.67英寸",
                    "createTimeStamp": 1594226617192,
                    "createTimeString": "2020-07-09 00:43:37,192"
                }
            }
        ]
    }
}

4.2 bool

主要与其他关键字组合使用。

4.3 should

or的关系

{
    "query": {
        "bool": {
            "should": [
                {
                    "match": {
                        "name": "咨询"
                    }
                },
                {
                    "match": {
                        "name": "实惠"
                    }
                }
            ]
        }
    }
}

响应示例片段

{
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 104,
            "relation": "eq"
        },
        "max_score": 49.01896,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "AjwuL3MB3aBfAxkroaJ_",
                "_score": 49.01896,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "华为HUAWEI nova 6 SE [下单-200，享碎屏险服务，分期0首付，咨询享实惠]手机 绮境森林（咨询省20） 8GB+128GB",
                    "ad": "咨询客服享优惠，赠钢化膜+手机壳+碎屏险+数据线+挂绳nova65G火热优惠中，详情猛戳",
                    "price": 1999.0,
                    "imgUrl": "//img12.360buyimg.com/n7/jfs/t1/87035/6/16675/136341/5e7df172Ec4e4ffd9/4944e5128f4cab11.jpg",
                    "memory": "8GB运存",
                    "storage": "128GB",
                    "screen": "6.4英寸",
                    "createTimeStamp": 1594224451966,
                    "createTimeString": "2020-07-09 00:07:31,966"
                }
            }
        ]
    }
}

4.4 must

and的关系。

示例

{
    "query": {
        "bool": {
            "must": [
                {
                    "match": {
                        "name": "咨询"
                    }
                },
                {
                    "match": {
                        "name": "实惠"
                    }
                }
            ]
        }
    }
}

响应示例片段

{
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 11,
            "relation": "eq"
        },
        "max_score": 49.01896,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "AjwuL3MB3aBfAxkroaJ_",
                "_score": 49.01896,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "华为HUAWEI nova 6 SE [下单-200，享碎屏险服务，分期0首付，咨询享实惠]手机 绮境森林（咨询省20） 8GB+128GB",
                    "ad": "咨询客服享优惠，赠钢化膜+手机壳+碎屏险+数据线+挂绳nova65G火热优惠中，详情猛戳",
                    "price": 1999.0,
                    "imgUrl": "//img12.360buyimg.com/n7/jfs/t1/87035/6/16675/136341/5e7df172Ec4e4ffd9/4944e5128f4cab11.jpg",
                    "memory": "8GB运存",
                    "storage": "128GB",
                    "screen": "6.4英寸",
                    "createTimeStamp": 1594224451966,
                    "createTimeString": "2020-07-09 00:07:31,966"
                }
            }
        ]
    }
}

4.5 must_not

{
    "query": {
        "bool": {
            "must_not": {
                "query_string": {
                    "query": "小米 or 华为 or 苹果 or 荣耀 or 红米 or 手机 or vivo or 三星 or iPhone or 一加"
                }
            }
        }
    }
}

响应示例片段：

{
    "took": 268,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 11,
            "relation": "eq"
        },
        "max_score": 0.0,
        "hits": [
            {
                "_index": "spring-boot-elasticsearch-sample-phone",
                "_type": "_doc",
                "_id": "ZTwtL3MB3aBfAxkrFJcJ",
                "_score": 0.0,
                "_source": {
                    "_class": "com.fengwenyi.spring_boot_elasticsearch_sample.entity.PhoneEntity",
                    "name": "金立 Gionee K6 8+128GB 梦幻蓝 4350mAh大电池 6.2英寸水滴屏 微Q8开 全网通4G 双卡双待",
                    "ad": "【评价享好礼】金立K6，4350mAh大电池|6.2英寸水滴屏|8+128GB大内存|评价返E卡！金立K3低至699元！",
                    "price": 899.0,
                    "imgUrl": "//img10.360buyimg.com/n7/jfs/t1/107655/18/18582/180279/5ec226c4Ebd488e23/7cbd62adba1590b4.jpg",
                    "memory": "8GB运存",
                    "storage": "128GB",
                    "screen": "6.2英寸",
                    "createTimeStamp": 1594224350216,
                    "createTimeString": "2020-07-09 00:05:50,216"
                }
            }
        ]
    }
}

Blog Link

Erwin Feng Blog：https://www.yuque.com/fengwenyi/pvaq8o
博客长期更新，感兴趣，就点点关注，支持一下吧！

文章标签：
检索分析服务 Elasticsearch版
iOS开发
测试技术
人工智能
索引
5G
数据格式
JSON
关键词：
检索分析服务 Elasticsearch版dsl
检索分析服务 Elasticsearch版querydsl
检索分析服务 Elasticsearch版query
检索分析服务 Elasticsearch版query dsl
相关实践学习
使用阿里云Elasticsearch体验信息检索加速
通过创建登录阿里云Elasticsearch集群，使用DataWorks将MySQL数据同步至Elasticsearch，体验多条件检索效果，简单展示数据同步和信息检索加速的过程和操作。
ElasticSearch 入门精讲
ElasticSearch是一个开源的、基于Lucene的、分布式、高扩展、高实时的搜索与数据分析引擎。根据DB-Engines的排名显示，Elasticsearch是最受欢迎的企业搜索引擎，其次是Apache Solr（也是基于Lucene）。 ElasticSearch的实现原理主要分为以下几个步骤： 用户将数据提交到Elastic Search 数据库中 通过分词控制器去将对应的语句分词，将其权重和分词结果一并存入数据 当用户搜索数据时候，再根据权重将结果排名、打分 将返回结果呈现给用户 Elasticsearch可以用于搜索各种文档。它提供可扩展的搜索，具有接近实时的搜索，并支持多租户。
冯文议
目录
相关文章
程序员半支烟
|
Web App开发 自然语言处理 API
巧记Elasticsearch常用DSL语法
记知识先记轮廓，关于DSL语法的轮廓，记住以下3句话即可：1.索引、文档和查询。2.Match、Term和Bool。3.还有翻页和聚合
程序员半支烟
257 0
巧记Elasticsearch常用DSL语法
程序员小海绵
|
2月前
|
JSON 自然语言处理 算法
ElasticSearch基础2——DSL查询文档,黑马旅游项目查询功能
DSL查询文档、RestClient查询文档、全文检索查询、精准查询、复合查询、地理坐标查询、分页、排序、高亮、黑马旅游案例
程序员小海绵
67 0
ElasticSearch基础2——DSL查询文档,黑马旅游项目查询功能
不吃核桃
|
4月前
|
存储 数据库 索引
面试题ES问题之动态映射的定义如何解决
面试题ES问题之动态映射的定义如何解决
不吃核桃
38 1
T-OPEN
|
6月前
|
SQL Java 关系型数据库
spring data elasticsearch 打印sql（DSL）语句
spring data elasticsearch 打印sql（DSL）语句
T-OPEN
446 0
阿甘兄
|
JSON 自然语言处理 数据格式
分布式系列教程（33） -ElasticSearch DSL语言查询与过滤
分布式系列教程（33） -ElasticSearch DSL语言查询与过滤
阿甘兄
198 0
BookSea
|
存储 JSON 物联网
【Elasticsearch】学好Elasticsearch系列-Query DSL 1
【Elasticsearch】学好Elasticsearch系列-Query DSL
BookSea
111 0
山河亦问安
|
6月前
|
自然语言处理 索引
Elasticsearch之常用DSL语句
mapping是对索引库中文档的约束
山河亦问安
127 1
陶然同学
|
6月前
|
JSON 自然语言处理 算法
【Elasticsearch】DSL查询文档
【Elasticsearch】DSL查询文档
陶然同学
401 0
Jast
|
6月前
|
Java 索引
ElasticSearch DSL操作
ElasticSearch DSL操作
Jast
112 1
飞翔的佩奇
|
6月前
dsl语句查询elasticsearch集群节点分布和资源使用情况
dsl语句查询elasticsearch集群节点分布和资源使用情况
飞翔的佩奇
154 0

热门文章

最新文章

  • 1
    ElasticSearch容器化从0到1实践（一）
  • 2
    （ElasticsSearch学习）歌词检索Demo的实现：二. 搭建spring boot+spring data+jest+elasticsearch环境，实现歌词的全文检索
  • 3
    ElasticSearch的工作机制
  • 4
    Elasticsearch Java API(九)--删除文档的field以及field的属性
  • 5
    Python编程：elasticsearch库操作Elasticsearch
  • 6
    实战 | Elasticsearch打造知识库检索系统
  • 7
    elasticsearch 特殊字段
  • 8
    第 22 章 Elasticsearch API
  • 9
    elasticsearch6.8.2设置集群认证
  • 10
    logstash-input-jdbc实现mysql 与elasticsearch实时同步深入详解
  • 1
    docker desktop安装es并连接elasticsearch-head:5
    223
  • 2
    【Elasticsearch】elasticsearch.yml配置文件解读，ES配置详解
    188
  • 3
    datax-elasticsearch 同步踩坑记录
    181
  • 4
    【Elasticsearch】Elasticsearch倒排索引详解
    172
  • 5
    【Elasticsearch】Elasticsearch索引创建与管理详解
    467
  • 6
    数据处理神器Elasticsearch_Pipeline：原理、配置与实战指南
    176
  • 7
    【Python】已解决：elasticsearch.exceptions.RequestError: TransportError(400, ‘search_phase_execution_exc
    262
  • 8
    使用Elasticsearch实现全文搜索的最佳实践
    85
  • 9
    Elasticsearch 常用查询语句大全
    96
  • 10
    使用Elasticsearch实现全文搜索的最佳实践
    69

    • 相关课程

    更多
  • Kibana Lens 入门
  • Elasticsearch实战进阶营
  • ElasticSearch 最新快速入门教程
  • ElasticSearch 入门精讲

    • 相关电子书

    更多
  • 阿里云Elasticsearch体系架构与特性解析
  • 开源与云：Elasticsearch应用剖析
  • 《Elasticsearch全观测解决方案》

    • 相关实验场景

    更多
  • 基于Elasticsearch向量检索的以文搜图
  • 利用Elasticsearch实现地理位置查询
  • 使用检索分析服务Elasticsearch版实现基础检索
  • 使用阿里云Elasticsearch体验信息检索加速
  • 使用阿里云Elasticsearch快速搭建可观测系统
    • 下一篇
    手把手教你白嫖阿里云服务器(免费领服务器)