elasticsearch - 嵌套的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.
    ]
  }
}

如您所见，不存在某个匹配项(实际上有很多)，因为没有订单包含所请求的订单号。

这是 documenttype1的映射:

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

最后，这是用于阐明 custom_internal_code分析器的设置，如上图所示:

{
   "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

要进行精确搜索，请使用termquery [1]并让orderNumber not_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