嵌套的ElasticSearch查询导致项目过多

Question

下面嵌套的ElasticSearch查询返回一些不应该命中的结果。许多结果不包含请求的订单号，但仍然列出了。我没有得到所有的文档，所以查询肯定会在某种程度上减少结果集。

{
  "query": {
    "nested": {
      "path": "orders",
      "query": {
        "match": {
          "orderNumber": "242347"
        }
      }      
    }
  }
}

查询结果（截断）：

{
  "took":0,
  "timed_out":false,
  "_shards": {
    "total":1,
    "successful":1,
    "failed":0
  },
  "hits": {
    "total":60,
    "max_score":9.656103,
    "hits":[
      {
        "_index": "index1",
        "_type":"documenttype1",
        "_id":"mUmudQrVSC6rn68ujDJ8iA",
        "_score":9.656103,
        "_source" : {
          "documentId": 12093894,
          "orders": [
          {
            "customerId": 129048669,
            "orderNumber": "242347", // <-- CORRECT HIT ON ORDER
          },
          {
            "customerId": 229405848,
            "orderNumber": "431962"
          }
          ]
        }
      },
      {
        "_index":"index1",
        "_type":"documenttype1",
        "_id":"9iO5QBCpT_6kmH3CoBTdWw",
        "_score":9.656103, 
        "_source" : {
          "documentId": 43390283,
          // <-- ORDER ISN'T HERE BUT THE DOCUMENT IS HIT NEVERTHELESS!
          "orders": [
          {
            "customerId": 229405848,
            "orderNumber": "431962"
          },
          {
            "customerId": 129408979,
            "orderNumber": "142701"
          }
          ]
        }
      }
      // Left out 58 more results most of which do not contain
      // the requested order number.
    ]
  }
}

正如您所看到的，有一个点击（实际上，有相当多的点击）不应该出现，因为没有一个订单包含请求的订单号。

这是文档类型1的映射：

{
   "index1":{
      "properties":{
         "documentId":{
            "type":"integer"
         },
         "orders":{
            "type":"nested",
            "properties":{
               "customerId":{
                  "type":"integer"
               },
               "orderNumber":{
                  "type":"string",
                  "analyzer":"custom_internal_code"
               }
            }
         }
      }
   }
}

最后，以下是澄清上述映射中所述的自定义\u内部\u代码分析器的设置：

{
   "index1":{
      "settings":{
         "index.analysis.analyzer.custom_internal_code.filter.1":"asciifolding",
         "index.analysis.analyzer.custom_internal_code.type":"custom",
         "index.analysis.analyzer.custom_internal_code.filter.0":"lowercase",
         "index.analysis.analyzer.custom_internal_code.tokenizer":"keyword",
      }
   }
}

Answer 1

似乎应该使用布尔查询而不是匹配。

但是如果只想筛选记录，则应该使用嵌套筛选而不是查询。它工作得更快，因为你不必计算分数。

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-nested-filter.html

{
  "query": {
    "filtered": {
      "query": {
        "match_all": {}
      },
      "filter": {
        "nested": {
          "path": "orders",
          "filter": {
            "bool": {
              "must": [
                {
                  "term": {
                    "orderNumber": "242347"
                  }
                }
              ]
            }
          },
          "_cache": true
        }
      }
    }
  }
}

Answer 2

对于一个精确的搜索使用termQuery[1]和orderNumbernot_analyzed[2]。

[1]http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-term-query.html#query-dsl-term-query

[2] http://www.elasticsearch.org/guide/en/elasticsearch/guide/current/mapping-intro.html#_literal_index_literal