elasticsearch - Elasticsearch 查询，仅返回最独特的结果

Question

尝试在 Elasticsearch 上运行字词查询，却想不出如何将返回值限制为仅唯一结果？
假设这是查询。

"query": {
    "bool": {
        "must": [{
            "terms": {
                "id": [
                    "1",
                    "2",
                    "3",
                ],
                "boost": 1.0
            }
        }],
        "adjust_pure_negative": true,
        "boost": 1.0
    }
},
"aggs": {
    "top-results": {
        "terms": {
            "field": "id"
        },
        "aggs": {
            "test": {
                "top_hits": {
                    "size": 1
                }
            }
        }
    }
} 

理想情况下，我只希望返回3个结果，每个结果都与ID 1、2或3相匹配，但是此查询返回的结果要多得多。

Answer 1

为了模仿您的情况，在Elasticsearch中推了一组5张薪水不同的员工记录。因此，我正在尝试获取列出的每个薪水(最高记录)的薪水。

GET /employee/_doc/_search
{
  "query": {
    "bool": {
          "should": [
            { "match": { "salary": 90000 }},
            { "match": { "salary": 80000 }} 
          ]
    }
  },
  "size" : 0,
  "aggs": {
    "salaries": {
      "terms": {
        "field":   "salary",      
        "order": { "top_score": "desc" } 
      },
      "aggs": {
        "top_score": { "max":      { "script":  "_score"           }}, 
        "salary-num": { "top_hits": { "size": 1 }}   
      }
    }
  }
}

输出

{
...
  "aggregations" : {
    "salaries" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : 80000,
          "doc_count" : 2,
          "top_score" : {
            "value" : 1.0
          },
          "salary-num" : {
            "hits" : {
              "total" : {
                "value" : 2,
                "relation" : "eq"
              },
              "max_score" : 1.0,
              "hits" : [
                {
                  "_index" : "employee",
                  "_type" : "_doc",
                  "_id" : "2",
                  "_score" : 1.0,
                  "_source" : {
                    "id" : 10,
                    "name" : "Lydia",
                    "dept" : "HR",
                    "salary" : 80000
                  }
                }
              ]
            }
          }
        },
        {
          "key" : 90000,
          "doc_count" : 1,
          "top_score" : {
            "value" : 1.0
          },
          "salary-num" : {
            "hits" : {
              "total" : {
                "value" : 1,
                "relation" : "eq"
              },
              "max_score" : 1.0,
              "hits" : [
                {
                  "_index" : "employee",
                  "_type" : "_doc",
                  "_id" : "3",
                  "_score" : 1.0,
                  "_source" : {
                    "id" : 20,
                    "name" : "Flora",
                    "dept" : "Accounts",
                    "salary" : 90000
                  }
                }
              ]
            }
          }
        }
      ]
    }
  }
}