Elasticsearch的学习笔记（三）

博主： Kilig
发布时间：2022 年 04 月 27 日
2114 次浏览
暂无评论
16112字数
分类：学习

条件查询

查询指定字段

查询所有数据，只显示字段title和price

请求体：

{
    "query":{
        "match_all":{}
    },
    "_source":["title","price"]
}

返回结果：

{
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 9,
            "relation": "eq"
        },
        "max_score": 1,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "kq3nZIAB6CX3m_v3APT6",
                "_score": 1,
                "_source": {
                    "price": 3999,
                    "title": "小米手机"
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "k63tZIAB6CX3m_v3vfQI",
                "_score": 1,
                "_source": {
                    "price": 3999,
                    "title": "小米手机"
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "l636ZIAB6CX3m_v3q_R5",
                "_score": 1,
                "_source": {
                    "price": 1999,
                    "title": "华为手机"
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "ma37ZIAB6CX3m_v3BvQc",
                "_score": 1,
                "_source": {
                    "price": 1999,
                    "title": "华为手机"
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "n60KZYAB6CX3m_v3q_Tc",
                "_score": 1,
                "_source": {
                    "price": 3999,
                    "title": "小米手机"
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oK0KZYAB6CX3m_v3rfQs",
                "_score": 1,
                "_source": {
                    "price": 3999,
                    "title": "小米手机"
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oa0KZYAB6CX3m_v3rvS_",
                "_score": 1,
                "_source": {
                    "price": 3999,
                    "title": "小米手机"
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oq0KZYAB6CX3m_v3sPQR",
                "_score": 1,
                "_source": {
                    "price": 3999,
                    "title": "小米手机"
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "o60KZYAB6CX3m_v3sfT8",
                "_score": 1,
                "_source": {
                    "price": 3999,
                    "title": "小米手机"
                }
            }
        ]
    }
}

分页查询

请求体：

{
    "query":{
        "match_all":{}
    },
    "from":0,
    "size":2
}

返回结果：

{
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 9,
            "relation": "eq"
        },
        "max_score": 1,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "kq3nZIAB6CX3m_v3APT6",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "k63tZIAB6CX3m_v3vfQI",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            }
        ]
    }
}

查询排序

按价格的从高到低排序

请求体：

{
    "query":{
        "match_all":{}
    },
    "sort":[
        {
            "price":{
                "order":"desc"
            }
        }
    ]
}

返回结果：

{
    "took": 13,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 9,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "kq3nZIAB6CX3m_v3APT6",
                "_score": null,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                },
                "sort": [
                    3999
                ]
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "k63tZIAB6CX3m_v3vfQI",
                "_score": null,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                },
                "sort": [
                    3999
                ]
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "n60KZYAB6CX3m_v3q_Tc",
                "_score": null,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                },
                "sort": [
                    3999
                ]
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oK0KZYAB6CX3m_v3rfQs",
                "_score": null,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                },
                "sort": [
                    3999
                ]
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oa0KZYAB6CX3m_v3rvS_",
                "_score": null,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                },
                "sort": [
                    3999
                ]
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oq0KZYAB6CX3m_v3sPQR",
                "_score": null,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                },
                "sort": [
                    3999
                ]
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "o60KZYAB6CX3m_v3sfT8",
                "_score": null,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                },
                "sort": [
                    3999
                ]
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "l636ZIAB6CX3m_v3q_R5",
                "_score": null,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                },
                "sort": [
                    1999
                ]
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "ma37ZIAB6CX3m_v3BvQc",
                "_score": null,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                },
                "sort": [
                    1999
                ]
            }
        ]
    }
}

多条件查询

查询小米的牌子，价格为3999元的手机。

请求体：

{
    "query":{
        "bool":{
            "must":[{  //must表示必须满足(相当于and)，should表示可以满足（相当于or）
                "match":{
                    "category":"小米"
                }
            },{
                "match":{
                    "price":3999.00
                }
            }]
        }
    }
}

返回结果：

{
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 7,
            "relation": "eq"
        },
        "max_score": 1.9979823,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "kq3nZIAB6CX3m_v3APT6",
                "_score": 1.9979823,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "k63tZIAB6CX3m_v3vfQI",
                "_score": 1.9979823,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "n60KZYAB6CX3m_v3q_Tc",
                "_score": 1.9979823,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oK0KZYAB6CX3m_v3rfQs",
                "_score": 1.9979823,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oa0KZYAB6CX3m_v3rvS_",
                "_score": 1.9979823,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oq0KZYAB6CX3m_v3sPQR",
                "_score": 1.9979823,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "o60KZYAB6CX3m_v3sfT8",
                "_score": 1.9979823,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            }
        ]
    }
}

条件查询列子2

查询小米和华为的牌子，价格大于3000元的手机。

查询范围可以使用以下4个：

gt 大于
gte 大于或等于
lt 小于
lte 小于或等于

must表示必须满足(相当于and)，should表示可以满足（相当于or）

请求体：

{
    "query":{
        "bool":{
            "should":[
                {
                    "match":{
                        "category":"小米"
                    }
                },
                {
                    "match":{
                        "category":"华为"
                    }
                }
            ],
            "filter":{
                "range":{
                    "price":{
                        "gt":3000
                    }
                }
            }
        }
    }
}

返回结果：

{
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 7,
            "relation": "eq"
        },
        "max_score": 0.99798226,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "kq3nZIAB6CX3m_v3APT6",
                "_score": 0.99798226,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "k63tZIAB6CX3m_v3vfQI",
                "_score": 0.99798226,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "n60KZYAB6CX3m_v3q_Tc",
                "_score": 0.99798226,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oK0KZYAB6CX3m_v3rfQs",
                "_score": 0.99798226,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oa0KZYAB6CX3m_v3rvS_",
                "_score": 0.99798226,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oq0KZYAB6CX3m_v3sPQR",
                "_score": 0.99798226,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "o60KZYAB6CX3m_v3sfT8",
                "_score": 0.99798226,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            }
        ]
    }
}

全文检索

这功能像搜索引擎那样，如品牌输入“小华”，返回结果带回品牌有“小米”和华为的。

请求体：

{
    "query":{
        "match":{
            "category" : "小华"
        }
    }
}

返回结果：

{
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 9,
            "relation": "eq"
        },
        "max_score": 0.93430924,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "l636ZIAB6CX3m_v3q_R5",
                "_score": 0.93430924,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "ma37ZIAB6CX3m_v3BvQc",
                "_score": 0.93430924,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "kq3nZIAB6CX3m_v3APT6",
                "_score": 0.49899113,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "k63tZIAB6CX3m_v3vfQI",
                "_score": 0.49899113,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "n60KZYAB6CX3m_v3q_Tc",
                "_score": 0.49899113,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oK0KZYAB6CX3m_v3rfQs",
                "_score": 0.49899113,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oa0KZYAB6CX3m_v3rvS_",
                "_score": 0.49899113,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oq0KZYAB6CX3m_v3sPQR",
                "_score": 0.49899113,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "o60KZYAB6CX3m_v3sfT8",
                "_score": 0.49899113,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            }
        ]
    }
}

完全匹配

{
    "query":{
        "match_phrase":{
            "category" : "为"
        }
    }
}

返回结果：

{
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 2,
            "relation": "eq"
        },
        "max_score": 0.93430924,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "l636ZIAB6CX3m_v3q_R5",
                "_score": 0.93430924,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "ma37ZIAB6CX3m_v3BvQc",
                "_score": 0.93430924,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                }
            }
        ]
    }
}

高亮查询

请求体：

{
    "query":{
        "match_phrase":{
            "category" : "为"
        }
    },
    "highlight":{
        "fields":{
            "category":{}//<----高亮这字段
        }
    }
}

返回结果：

{
    "took": 19,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 2,
            "relation": "eq"
        },
        "max_score": 0.93430924,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "l636ZIAB6CX3m_v3q_R5",
                "_score": 0.93430924,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                },
                "highlight": {
                    "category": [
                        "华<em>为</em>"
                    ]
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "ma37ZIAB6CX3m_v3BvQc",
                "_score": 0.93430924,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                },
                "highlight": {
                    "category": [
                        "华<em>为</em>" //<------高亮一个为字。
                    ]
                }
            }
        ]
    }
}

聚合查询

分组查询

类似与关系型数据库中的 group by，当然还有很多其他的聚合，例如取最大值max、平均值avg等等。

接下来按price字段进行分组：

请求体：

{
    "aggs":{//聚合操作
        "price_group":{//名称，随意起名
            "terms":{//分组
                "field":"price"//分组字段
            }
        }
    }
}

返回结果：

{
    "took": 11,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 9,
            "relation": "eq"
        },
        "max_score": 1,
        "hits": [
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "kq3nZIAB6CX3m_v3APT6",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "k63tZIAB6CX3m_v3vfQI",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "l636ZIAB6CX3m_v3q_R5",
                "_score": 1,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "ma37ZIAB6CX3m_v3BvQc",
                "_score": 1,
                "_source": {
                    "title": "华为手机",
                    "category": "华为",
                    "images": "http://www.gulixueyuan.com/hw.jpg",
                    "price": 1999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "n60KZYAB6CX3m_v3q_Tc",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oK0KZYAB6CX3m_v3rfQs",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oa0KZYAB6CX3m_v3rvS_",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "oq0KZYAB6CX3m_v3sPQR",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            },
            {
                "_index": "shopping",
                "_type": "_doc",
                "_id": "o60KZYAB6CX3m_v3sfT8",
                "_score": 1,
                "_source": {
                    "title": "小米手机",
                    "category": "小米",
                    "images": "http://www.gulixueyuan.com/xm.jpg",
                    "price": 3999
                }
            }
        ]
    },
    "aggregations": {
        "price_group": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": 3999,
                    "doc_count": 7
                },
                {
                    "key": 1999,
                    "doc_count": 2
                }
            ]
        }
    }
}

上面返回结果会附带原始数据的。若不想要不附带原始数据的结果，可以使用下面的方式：
请求体：

{
    "aggs":{
        "price_group":{
            "terms":{
                "field":"price"
            }
        }
    },
    "size":0
}

返回结果：

{
    "took": 4,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 9,
            "relation": "eq"
        },
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "price_group": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": 3999,
                    "doc_count": 7
                },
                {
                    "key": 1999,
                    "doc_count": 2
                }
            ]
        }
    }
}

平均值

所有手机价格求平均值。

请求体：

{
    "aggs":{
        "price_avg":{//名称，随意起名
            "avg":{//求平均
                "field":"price"
            }
        }
    },
    "size":0
}

返回结果：

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

最后修改：2022 年 04 月 27 日

如果觉得我的文章对你有用，请随意赞赏

发表评论取消回复
使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

评论 *

私密评论

名称 *

🎲

邮箱 *

地址

hhhh
SQLSTATE[HY000] [1049] Unknown ...
hhhh
后台一直卡在登录界面是怎么回事
DoNotKnow
该评论仅登录用户及评论双方可见
赵姐商业
你写得非常清晰明了，让我很容易理解你的观点。
宇哲
bbs怎么不做了？

Elasticsearch的学习笔记（三）

Kilig • 2022 年 04 月 27 日

<h2>条件查询</h2>查询指定字段<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote>查询所有数据，只显示字段title和price请求体：<pre><code class="lang-html">{
 &quot;query&quot;:{
 &quot;match_all&quot;:{}
 },
 &quot;_source&quot;:[&quot;title&quot;,&quot;price&quot;]
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 3,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 9,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: 1,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;kq3nZIAB6CX3m_v3APT6&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 3999,
 &quot;title&quot;: &quot;小米手机&quot;
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;k63tZIAB6CX3m_v3vfQI&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 3999,
 &quot;title&quot;: &quot;小米手机&quot;
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;l636ZIAB6CX3m_v3q_R5&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 1999,
 &quot;title&quot;: &quot;华为手机&quot;
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;ma37ZIAB6CX3m_v3BvQc&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 1999,
 &quot;title&quot;: &quot;华为手机&quot;
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;n60KZYAB6CX3m_v3q_Tc&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 3999,
 &quot;title&quot;: &quot;小米手机&quot;
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oK0KZYAB6CX3m_v3rfQs&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 3999,
 &quot;title&quot;: &quot;小米手机&quot;
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oa0KZYAB6CX3m_v3rvS_&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 3999,
 &quot;title&quot;: &quot;小米手机&quot;
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oq0KZYAB6CX3m_v3sPQR&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 3999,
 &quot;title&quot;: &quot;小米手机&quot;
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;o60KZYAB6CX3m_v3sfT8&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;price&quot;: 3999,
 &quot;title&quot;: &quot;小米手机&quot;
 }
 }
 ]
 }
}</code></pre>分页查询<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote>请求体：<pre><code class="lang-html">{
 &quot;query&quot;:{
 &quot;match_all&quot;:{}
 },
 &quot;from&quot;:0,
 &quot;size&quot;:2
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 2,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 9,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: 1,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;kq3nZIAB6CX3m_v3APT6&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;k63tZIAB6CX3m_v3vfQI&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 }
 ]
 }
}</code></pre>查询排序<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote>按价格的从高到低排序请求体：<pre><code class="lang-html">{
 &quot;query&quot;:{
 &quot;match_all&quot;:{}
 },
 &quot;sort&quot;:[
 {
 &quot;price&quot;:{
 &quot;order&quot;:&quot;desc&quot;
 }
 }
 ]
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 13,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 9,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: null,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;kq3nZIAB6CX3m_v3APT6&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 },
 &quot;sort&quot;: [
 3999
 ]
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;k63tZIAB6CX3m_v3vfQI&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 },
 &quot;sort&quot;: [
 3999
 ]
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;n60KZYAB6CX3m_v3q_Tc&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 },
 &quot;sort&quot;: [
 3999
 ]
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oK0KZYAB6CX3m_v3rfQs&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 },
 &quot;sort&quot;: [
 3999
 ]
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oa0KZYAB6CX3m_v3rvS_&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 },
 &quot;sort&quot;: [
 3999
 ]
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oq0KZYAB6CX3m_v3sPQR&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 },
 &quot;sort&quot;: [
 3999
 ]
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;o60KZYAB6CX3m_v3sfT8&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 },
 &quot;sort&quot;: [
 3999
 ]
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;l636ZIAB6CX3m_v3q_R5&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 },
 &quot;sort&quot;: [
 1999
 ]
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;ma37ZIAB6CX3m_v3BvQc&quot;,
 &quot;_score&quot;: null,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 },
 &quot;sort&quot;: [
 1999
 ]
 }
 ]
 }
}</code></pre>多条件查询<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote>查询小米的牌子，价格为3999元的手机。请求体：<pre><code class="lang-html">{
 &quot;query&quot;:{
 &quot;bool&quot;:{
 &quot;must&quot;:[{ //must表示必须满足(相当于and)，should表示可以满足（相当于or）
 &quot;match&quot;:{
 &quot;category&quot;:&quot;小米&quot;
 }
 },{
 &quot;match&quot;:{
 &quot;price&quot;:3999.00
 }
 }]
 }
 }
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 3,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 7,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: 1.9979823,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;kq3nZIAB6CX3m_v3APT6&quot;,
 &quot;_score&quot;: 1.9979823,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;k63tZIAB6CX3m_v3vfQI&quot;,
 &quot;_score&quot;: 1.9979823,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;n60KZYAB6CX3m_v3q_Tc&quot;,
 &quot;_score&quot;: 1.9979823,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oK0KZYAB6CX3m_v3rfQs&quot;,
 &quot;_score&quot;: 1.9979823,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oa0KZYAB6CX3m_v3rvS_&quot;,
 &quot;_score&quot;: 1.9979823,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oq0KZYAB6CX3m_v3sPQR&quot;,
 &quot;_score&quot;: 1.9979823,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;o60KZYAB6CX3m_v3sfT8&quot;,
 &quot;_score&quot;: 1.9979823,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 }
 ]
 }
}</code></pre>条件查询列子2<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote>查询小米和华为的牌子，价格大于3000元的手机。查询范围可以使用以下4个：<ul><li>gt 大于</li><li>gte 大于或等于</li><li>lt 小于</li><li>lte 小于或等于</li></ul>must表示必须满足(相当于and)，should表示可以满足（相当于or）请求体：<pre><code class="lang-html">{
 &quot;query&quot;:{
 &quot;bool&quot;:{
 &quot;should&quot;:[
 {
 &quot;match&quot;:{
 &quot;category&quot;:&quot;小米&quot;
 }
 },
 {
 &quot;match&quot;:{
 &quot;category&quot;:&quot;华为&quot;
 }
 }
 ],
 &quot;filter&quot;:{
 &quot;range&quot;:{
 &quot;price&quot;:{
 &quot;gt&quot;:3000
 }
 }
 }
 }
 }
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 2,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 7,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: 0.99798226,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;kq3nZIAB6CX3m_v3APT6&quot;,
 &quot;_score&quot;: 0.99798226,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;k63tZIAB6CX3m_v3vfQI&quot;,
 &quot;_score&quot;: 0.99798226,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;n60KZYAB6CX3m_v3q_Tc&quot;,
 &quot;_score&quot;: 0.99798226,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oK0KZYAB6CX3m_v3rfQs&quot;,
 &quot;_score&quot;: 0.99798226,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oa0KZYAB6CX3m_v3rvS_&quot;,
 &quot;_score&quot;: 0.99798226,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oq0KZYAB6CX3m_v3sPQR&quot;,
 &quot;_score&quot;: 0.99798226,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;o60KZYAB6CX3m_v3sfT8&quot;,
 &quot;_score&quot;: 0.99798226,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 }
 ]
 }
}</code></pre>全文检索<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote>这功能像搜索引擎那样，如品牌输入“小华”，返回结果带回品牌有“小米”和华为的。请求体：<pre><code class="lang-html">{
 &quot;query&quot;:{
 &quot;match&quot;:{
 &quot;category&quot; : &quot;小华&quot;
 }
 }
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 2,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 9,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: 0.93430924,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;l636ZIAB6CX3m_v3q_R5&quot;,
 &quot;_score&quot;: 0.93430924,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;ma37ZIAB6CX3m_v3BvQc&quot;,
 &quot;_score&quot;: 0.93430924,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;kq3nZIAB6CX3m_v3APT6&quot;,
 &quot;_score&quot;: 0.49899113,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;k63tZIAB6CX3m_v3vfQI&quot;,
 &quot;_score&quot;: 0.49899113,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;n60KZYAB6CX3m_v3q_Tc&quot;,
 &quot;_score&quot;: 0.49899113,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oK0KZYAB6CX3m_v3rfQs&quot;,
 &quot;_score&quot;: 0.49899113,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oa0KZYAB6CX3m_v3rvS_&quot;,
 &quot;_score&quot;: 0.49899113,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oq0KZYAB6CX3m_v3sPQR&quot;,
 &quot;_score&quot;: 0.49899113,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;o60KZYAB6CX3m_v3sfT8&quot;,
 &quot;_score&quot;: 0.49899113,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 }
 ]
 }
}</code></pre>完全匹配<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote><pre><code class="lang-html">{
 &quot;query&quot;:{
 &quot;match_phrase&quot;:{
 &quot;category&quot; : &quot;为&quot;
 }
 }
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 1,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 2,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: 0.93430924,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;l636ZIAB6CX3m_v3q_R5&quot;,
 &quot;_score&quot;: 0.93430924,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;ma37ZIAB6CX3m_v3BvQc&quot;,
 &quot;_score&quot;: 0.93430924,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 }
 }
 ]
 }
}</code></pre>高亮查询<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote>请求体：<pre><code class="lang-html">{
 &quot;query&quot;:{
 &quot;match_phrase&quot;:{
 &quot;category&quot; : &quot;为&quot;
 }
 },
 &quot;highlight&quot;:{
 &quot;fields&quot;:{
 &quot;category&quot;:{}//&lt;----高亮这字段
 }
 }
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 19,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 2,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: 0.93430924,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;l636ZIAB6CX3m_v3q_R5&quot;,
 &quot;_score&quot;: 0.93430924,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 },
 &quot;highlight&quot;: {
 &quot;category&quot;: [
 &quot;华&lt;em&gt;为&lt;/em&gt;&quot;
 ]
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;ma37ZIAB6CX3m_v3BvQc&quot;,
 &quot;_score&quot;: 0.93430924,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 },
 &quot;highlight&quot;: {
 &quot;category&quot;: [
 &quot;华&lt;em&gt;为&lt;/em&gt;&quot; //&lt;------高亮一个为字。
 ]
 }
 }
 ]
 }
}</code></pre><h2>聚合查询</h2>分组查询<blockquote>GET <a class="no-external-link" href="http://localhost:9200/shopping/_search" target="_blank">http://localhost:9200/shopping/_search</a></blockquote>类似与关系型数据库中的 group by，当然还有很多其他的聚合，例如取最大值max、平均值avg等等。接下来按price字段进行分组：请求体：<pre><code class="lang-html">{
 &quot;aggs&quot;:{//聚合操作
 &quot;price_group&quot;:{//名称，随意起名
 &quot;terms&quot;:{//分组
 &quot;field&quot;:&quot;price&quot;//分组字段
 }
 }
 }
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 11,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 9,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: 1,
 &quot;hits&quot;: [
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;kq3nZIAB6CX3m_v3APT6&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;k63tZIAB6CX3m_v3vfQI&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;l636ZIAB6CX3m_v3q_R5&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;ma37ZIAB6CX3m_v3BvQc&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;华为手机&quot;,
 &quot;category&quot;: &quot;华为&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/hw.jpg&quot;,
 &quot;price&quot;: 1999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;n60KZYAB6CX3m_v3q_Tc&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oK0KZYAB6CX3m_v3rfQs&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oa0KZYAB6CX3m_v3rvS_&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;oq0KZYAB6CX3m_v3sPQR&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 },
 {
 &quot;_index&quot;: &quot;shopping&quot;,
 &quot;_type&quot;: &quot;_doc&quot;,
 &quot;_id&quot;: &quot;o60KZYAB6CX3m_v3sfT8&quot;,
 &quot;_score&quot;: 1,
 &quot;_source&quot;: {
 &quot;title&quot;: &quot;小米手机&quot;,
 &quot;category&quot;: &quot;小米&quot;,
 &quot;images&quot;: &quot;http://www.gulixueyuan.com/xm.jpg&quot;,
 &quot;price&quot;: 3999
 }
 }
 ]
 },
 &quot;aggregations&quot;: {
 &quot;price_group&quot;: {
 &quot;doc_count_error_upper_bound&quot;: 0,
 &quot;sum_other_doc_count&quot;: 0,
 &quot;buckets&quot;: [
 {
 &quot;key&quot;: 3999,
 &quot;doc_count&quot;: 7
 },
 {
 &quot;key&quot;: 1999,
 &quot;doc_count&quot;: 2
 }
 ]
 }
 }
}</code></pre>上面返回结果会附带原始数据的。若不想要不附带原始数据的结果，可以使用下面的方式： 请求体：<pre><code class="lang-html">{
 &quot;aggs&quot;:{
 &quot;price_group&quot;:{
 &quot;terms&quot;:{
 &quot;field&quot;:&quot;price&quot;
 }
 }
 },
 &quot;size&quot;:0
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 4,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 9,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: null,
 &quot;hits&quot;: []
 },
 &quot;aggregations&quot;: {
 &quot;price_group&quot;: {
 &quot;doc_count_error_upper_bound&quot;: 0,
 &quot;sum_other_doc_count&quot;: 0,
 &quot;buckets&quot;: [
 {
 &quot;key&quot;: 3999,
 &quot;doc_count&quot;: 7
 },
 {
 &quot;key&quot;: 1999,
 &quot;doc_count&quot;: 2
 }
 ]
 }
 }
}</code></pre>平均值<blockquote>GET</blockquote>所有手机价格求平均值。请求体：<pre><code class="lang-html">{
 &quot;aggs&quot;:{
 &quot;price_avg&quot;:{//名称，随意起名
 &quot;avg&quot;:{//求平均
 &quot;field&quot;:&quot;price&quot;
 }
 }
 },
 &quot;size&quot;:0
}</code></pre>返回结果：<pre><code class="lang-html">{
 &quot;took&quot;: 2,
 &quot;timed_out&quot;: false,
 &quot;_shards&quot;: {
 &quot;total&quot;: 1,
 &quot;successful&quot;: 1,
 &quot;skipped&quot;: 0,
 &quot;failed&quot;: 0
 },
 &quot;hits&quot;: {
 &quot;total&quot;: {
 &quot;value&quot;: 9,
 &quot;relation&quot;: &quot;eq&quot;
 },
 &quot;max_score&quot;: null,
 &quot;hits&quot;: []
 },
 &quot;aggregations&quot;: {
 &quot;price_avg&quot;: {
 &quot;value&quot;: 3554.5555555555557
 }
 }
}</code></pre>

Elasticsearch的学习笔记（三）

条件查询

聚合查询

发表评论取消回复
使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

网站灯笼+春联源码

hello world！- 我的博客诞生啦~

left join关联查询一对多数据重复问题解决方案

PHP实现AES-128-ECB加密,Java解密！

PHP实现微信推送

五月，春未尽，夏初临

Mysql数据库通过cmd命令导入数据

Elasticsearch的学习笔记（一）

PHP实现微信推送

利用PHP通过周次去获取本周的起始和结束日期

Elasticsearch的学习笔记（三）

条件查询

聚合查询

发表评论 取消回复 使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

Elasticsearch的学习笔记（三）

发表评论取消回复
使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款