美文网首页
ES电商网站商品管理:多种搜索方式

ES电商网站商品管理:多种搜索方式

作者: WinnXUDONG | 来源:发表于2018-04-03 23:43 被阅读0次

1、query string search

搜索全部商品:GET /ecommerce/product/_search

took:耗费了几毫秒
timed_out:是否超时,这里是没有
_shards:数据拆成了5个分片,所以对于搜索请求,会打到所有的primary shard(或者是它的某个replica shard也可以)
hits.total:查询结果的数量,3个document
hits.max_score:score的含义,就是document对于一个search的相关度的匹配分数,越相关,就越匹配,分数也高
hits.hits:包含了匹配搜索的document的详细数据

#返回值
{
  "took": 6,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 3,
    "max_score": 1,
    "hits": [
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "2",
        "_score": 1,
        "_source": {
          "name": "jiajieshi yagao",
          "desc": "youxiao fangzhu",
          "price": 25,
          "producer": "jiajieshi producer",
          "tags": [
            "fangzhu"
          ]
        }
      },
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "1",
        "_score": 1,
        "_source": {
          "name": "gaolujie yagao",
          "desc": "gaoxiao meibai",
          "price": 30,
          "producer": "gaolujie producer",
          "tags": [
            "meibai",
            "fangzhu"
          ]
        }
      },
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "3",
        "_score": 1,
        "_source": {
          "name": "zhonghua yagao",
          "desc": "caoben zhiwu",
          "price": 40,
          "producer": "zhonghua producer",
          "tags": [
            "qingxin"
          ]
        }
      }
    ]
  }
}

query string search的由来,因为search参数都是以http请求的query string来附带的

#搜索商品名称中包含yagao的商品,而且按照售价降序排序:
GET /ecommerce/product/_search?q=name:yagao&sort=price:desc

适用于临时的在命令行使用一些工具,比如curl,快速的发出请求,来检索想要的信息;但是如果查询请求很复杂,是很难去构建的
在生产环境中,几乎很少使用query string search

2、query DSL

DSL:Domain Specified Language,特定领域的语言

http request body:请求体,可以用json的格式来构建查询语法,比较方便,可以构建各种复杂的语法,比query string search肯定强大多了

#查询所有商品
GET /ecommerce/product/_search
{
  "query": {
    "match_all": {}
  }
}
#返回值与 GET /ecommerce/product/_search 相同

#查询名称包含yagao的商品,同时按照价格降序排序
GET /ecommerce/product/_search
{
  "query": {
    "match": {
      "name":"yagao"
    }
  },
  "sort": [
    {
      "price": "desc"
    }
  ]
}

#分页查询商品,总共3条商品,假设每页就显示1条商品,现在显示第2页,所以就查出来第2个商品
GET /ecommerce/product/_search
{
  "query": {
    "match_all": {}
  },
  "from": 1,  //从第几条数据开始
  "size": 1  //查询多少条数据
}

#指定要查询出来商品的名称和价格字段就可以
GET /ecommerce/product/_search
{
  "query": {
    "match_all": {}
  },
  "_source": ["name","price"]
}

3、query filter(对数据进行过滤)

#搜索商品名称包含yagao,而且售价大于25元的商品(这里是有两个查询条件)
GET /ecommerce/product/_search
{
    "query" : {
        "bool" : {  //多条件查询
            "must" : {  //必须满足
                "match" : {
                    "name" : "yagao" 
                }
            },
            "filter" : {  //过滤
                "range" : {  //范围过滤
                    "price" : { "gt" : 25 }  //大于25 
                }
            }
        }
    }
}

4、full-text search(全文检索)

#添加一条数据
PUT /ecommerce/product/4
{
  "name":"special yagao",
  "desc":"special meibai",
  "price":50,
  "producer":"special yagao producer",
  "tags":["meibai"]
}

#全文检索
GET  /ecommerce/product/_search
{
  "query": {
    "match": {
      "producer": "yagao producer"
    }
  }
}
#过程
producer这个字段,会先被拆解,建立倒排索引

special     4
yagao       4
producer    1,2,3,4
gaolujie    1
zhognhua    3
jiajieshi   2

yagao producer 分解为 yagao和producer
#结果
{
  "took": 2,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 4,
    "max_score": 0.70293105,  //匹配分数
    "hits": [
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "4",
        "_score": 0.70293105,
        "_source": {
          "name": "special yagao",
          "desc": "special meibai",
          "price": 50,
          "producer": "special yagao producer",
          "tags": [
            "meibai"
          ]
        }
      },
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "1",
        "_score": 0.25811607,
        "_source": {
          "name": "gaolujie yagao",
          "desc": "gaoxiao meibai",
          "price": 30,
          "producer": "gaolujie producer",
          "tags": [
            "meibai",
            "fangzhu"
          ]
        }
      },
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "3",
        "_score": 0.25811607,
        "_source": {
          "name": "zhonghua yagao",
          "desc": "caoben zhiwu",
          "price": 40,
          "producer": "zhonghua producer",
          "tags": [
            "qingxin"
          ]
        }
      },
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "2",
        "_score": 0.1805489,
        "_source": {
          "name": "jiajieshi yagao",
          "desc": "youxiao fangzhu",
          "price": 25,
          "producer": "jiajieshi producer",
          "tags": [
            "fangzhu"
          ]
        }
      }
    ]
  }
}

5、phrase search(短语搜索)

跟全文检索相对应,相反,全文检索会将输入的搜索串拆解开来,去倒排索引里面去一一匹配,只要能匹配上任意一个拆解后的单词,就可以作为结果返回

phrase search,要求输入的搜索串,必须在指定的字段文本中,完全包含一模一样的,才可以算匹配,才能作为结果返回

GET  /ecommerce/product/_search
{
  "query": {
    "match_phrase": {
      "producer": "yagao producer"
    }
  }
}
#返回
{
  "took": 27,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 1,
    "max_score": 0.70293105,
    "hits": [
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "4",
        "_score": 0.70293105,
        "_source": {
          "name": "special yagao",
          "desc": "special meibai",
          "price": 50,
          "producer": "special yagao producer",
          "tags": [
            "meibai"
          ]
        }
      }
    ]
  }
}

6、highlight search(高亮搜索结果)

#实操
GET /ecommerce/product/_search
{
  "query": {
    "match_phrase": {
      "producer": "yagao producer"
    }
  },
  "highlight": {  //高亮
    "fields": {
      "producer":{}
    }
  }
}

#返回
{
  "took": 27,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 1,
    "max_score": 0.70293105,
    "hits": [
      {
        "_index": "ecommerce",
        "_type": "product",
        "_id": "4",
        "_score": 0.70293105,
        "_source": {
          "name": "special yagao",
          "desc": "special meibai",
          "price": 50,
          "producer": "special yagao producer",
          "tags": [
            "meibai"
          ]
        },
        "highlight": {
          "producer": [
            "special <em>yagao</em> <em>producer</em>"
          ]
        }
      }
    ]
  }
}

相关文章

  • ES电商网站商品管理:多种搜索方式

    1、query string search 搜索全部商品:GET /ecommerce/product/_sear...

  • 电商随想

    1.电商的商品列表 2.电商的搜索(es) 3.电商的促销规则 4.电商的购物车 5.电商的订单 6.电商的支付 ...

  • SPU&SKU

    现在最常见的购物方式就是网购,淘宝,京东也是我们常打开的购物网站。为了用户能更好搜索商品,选购商品,程序员设计电商...

  • ElasticSearch入门实战1

    document数据格式 电商网站商品管理案例背景介绍 简单的集群管理 商品的CRUD操作(document cu...

  • web整合Solr

    1..Solr案例实战 1.1.需求 使用Solr实现电商网站中商品信息搜索功能,可以根据关键字、分类、价格搜索商...

  • 电商网站的商品详情页系统架构

    电商网站的商品详情页系统架构 小型电商网站的商品详情页系统架构 小型电商网站的页面展示采用页面全量静态化的思想。数...

  • MySQL数据同步到ES的4种解决方案

    一、背景 大家应该都在各种电商网站检索过商品,检索商品一般都是通过什么实现呢?搜索引擎Elasticsearch。...

  • laravel 电商课程学习总结

    1. 课程内容总览 1.1 功能模块概述 电商分为电商网站和电商后台管理系统两部分,包括了用户模块、商品模块、购物...

  • 电商后台:实例解读商品管理系统

    商品是电商平台的关键,那么怎么通过商品管理系统将商品呈现到用户面前呢? 作者近期正在研究电商后台系统之商品管理系统...

  • 浅谈电商商品系统

    前言 电商商品系统,是电商基础系统之一,承载了商品在电商系统中的生命周期管理。本篇我们来简单拆解一下电商商品系统应...

网友评论

      本文标题:ES电商网站商品管理:多种搜索方式

      本文链接:https://www.haomeiwen.com/subject/jjhhhftx.html