elasticsearch - 我正在寻找与以下查询等效的ElasticSearch-

Question

SELECT sender
FROM julymonth
WHERE recipient IN ('x', 'y')
GROUP BY sender;

在这里，发件人和收件人是列名，而julymonth是表名。

Answer 1

成像您的结构，就是这样:

POST /julymonth/_search
{
  "query": {
    "filtered": {
      "filter": {
        "terms": {
          "recipient": [
            "x",
            "y"
          ]
        }
      }
    }
  },
  "aggs": {
    "senders": {
      "terms": {
        "field": "sender",
        "size": 0
      }
    }
  }
}

查询部分将按收件人

过滤您的文档

Aggs将从您过滤的文档中创建唯一的发件人列表