内部查询的弹性查询排序结果应为布尔查询 [英] Elastic search sorting results of individual queries inside should bool query

问题描述

我有一个Elastic Search服务器设置，用于存储要用于公司搜索的公司名称，其工作方式是:

I have a Elastic Search server setup where am storing company names to be used for for company search, the way it works is:

在公司名称中，空格和点将被删除并存储在ES的trimmedcompanyname字段中，

From company name, spaces and dots will be removed and stored in ES in a field called trimmedcompanyname,

{
          "companyName" : "RECKON INFOSYSTEM PRIVATE LIMITED",
          "trimmedCompanyName" : "reckoninfosystemprivatelimited",
          "id" : "1079"
}

现在，当搜索进入我的服务器时，我会删除空格和点，然后向ES服务器发出请求.查询格式的ES请求为:

now when search comes to my server i remove the spaces and dots and then make request to ES server. The ES request in query format is:

GET /_search
{
   "from": 0,"size":1000,
    "query": {
      "bool": {
      "should": [
        {
          "wildcard": {
            "trimmedCompanyName.keyword": {
              "value": "infosys*"
            }
          }
        },
        {
          "wildcard": {
            "trimmedCompanyName.keyword": {
              "value": "*infosys*"
            }
          }
        }
      ]
    }
    }
}

现在，结果为

[
      {
        "_source" : {
          "companyName" : "INFOSYS LIMITED",
          "trimmedCompanyName" : "infosyslimited"
        }
      ,
      {
        "_source" : {
          "companyName" : "INFOSYSTEM BPO LIMITED",
          "trimmedCompanyName" : "infosysbpolimited"
        }
      },
      {
        "_source" : {
          "companyName" : "INFOSYS ASIC SYSTEMS",
          "trimmedCompanyName" : "infosysasicsystems"
        }
      },
      {
        "_source" : {
          "companyName" : "SUMEDH INFOSYSTEMS PRIVATE LIMITED",
          "trimmedCompanyName" : "sumedhinfosystemsprivatelimited"
        }
      },
      {
        "_source" : {
          "companyName" : "ASSURE INFOSYSTEMS PRIVATE LIMITED",
          "trimmedCompanyName" : "assureinfosystemsprivatelimited"
        }
      },
      {
        "_source" : {
          "companyName" : "IMBIBE INFOSYSTEM PRIVATE LIMITED",
          "trimmedCompanyName" : "imbibeinfosystemprivatelimited"
        }
      },
      {
        "_source" : {
          "companyName" : "GOOFY INFOSYSTEM PRIVATE LIMITED",
          "trimmedCompanyName" : "goofyinfosystemprivatelimited"
        }
      },
      {
        "_source" : {
          "companyName" : "DHRUV INFOSYSTEMS PRIVATE LIMITED",
          "trimmedCompanyName" : "dhruvinfosystemsprivatelimited"
        }
      }
 ]

但是我希望结果为

[
      {
        "_source" : {
          "companyName" : "INFOSYS ASIC SYSTEMS",
          "trimmedCompanyName" : "infosysasicsystems"
        }
      },
      {
        "_source" : {
          "companyName" : "INFOSYSTEM BPO LIMITED",
          "trimmedCompanyName" : "infosysbpolimited"
        }
      },
      {
        "_source" : {
          "companyName" : "INFOSYS LIMITED",
          "trimmedCompanyName" : "infosyslimited"
        }
      ,
      {
        "_source" : {
          "companyName" : "ASSURE INFOSYSTEMS PRIVATE LIMITED",
          "trimmedCompanyName" : "assureinfosystemsprivatelimited"
        }
      },
      {
        "_source" : {
          "companyName" : "DHRUV INFOSYSTEMS PRIVATE LIMITED",
          "trimmedCompanyName" : "dhruvinfosystemsprivatelimited"
        }
      },
      {
        "_source" : {
          "companyName" : "GOOFY INFOSYSTEM PRIVATE LIMITED",
          "trimmedCompanyName" : "goofyinfosystemprivatelimited"
        }
      },
      {
        "_source" : {
          "companyName" : "IMBIBE INFOSYSTEM PRIVATE LIMITED",
          "trimmedCompanyName" : "imbibeinfosystemprivatelimited"
        }
      },
      {
        "_source" : {
          "companyName" : "SUMEDH INFOSYSTEMS PRIVATE LIMITED",
          "trimmedCompanyName" : "sumedhinfosystemsprivatelimited"
        }
      }
  ]

即结果，各个通配符查询的o/p必须在它们之间进行排序，但是第一个通配符查询的o/p应该在第二个通配符查询的o/p之前.有人可以帮我吗?

i.e. in the result, o/p of individual wildcard queires must be sorted among themselves but o/p of first wildcard query should precede o/p from second wildcard query. Can someone please help me with this?

推荐答案

我找到了解决方案，对搜索结果以及trimmedcompanyname进行了排序.我的最终查询是:

I got the solution, sorting on search score as well as trimmedcompanyname. My final query is:

GET /_search
{
   "from": 0,"size":1000,
    "query": {
      "bool": {
      "should": [
        {
          "wildcard": {
            "trimmedCompanyName.keyword": {
              "value": "infosys*"
            }
          }
        },
        {
          "wildcard": {
            "trimmedCompanyName.keyword": {
              "value": "*infosys*"
            }
          }
        }
      ]
    }
    },
      "sort": [
    {
      "_score": {
        "order": "desc"
      }
    },
    {
      "trimmedCompanyName.keyword": {"order": "asc"}
    }
  ]
}

希望有帮助！

这篇关于内部查询的弹性查询排序结果应为布尔查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！