在术语查询中查询/筛选已入库的文档？

Question

我有一些共享属性的数据，假设我有这些文档：

{
   session: "session-1",
   status: "New",
},
{
  session: "session-1",
  title: "My session",
},
{
   session: "session-1",
   message: "hi there",
},
{
   session: "session-2",
   status: "Closed",
},
{
   session: "session-2",
   message: "hi!",
},

如果我做一个聚合：

body: {
  aggs: {
    sessions: {
      field: "session",
    },
  },
},

我得到两个存储桶，里面有3个和2个文档：

"aggregations": {
    "sessions": {
      "doc_count_error_upper_bound": 0,   
      "sum_other_doc_count": 0,           
      "buckets": [                        
        {
          "key": "session-1",
          "doc_count": 3
        },
        {
          "key": "session-2",
          "doc_count": 2
        },
      ]
    }
  }

我可以以某种方式对存储桶运行筛选器或查询吗？

body: {
  aggs: {
    sessions: {
      field: "session",
    },
    aggs: {
      filter_docs: { bool: must [{ match: { message: "hi" } }, { match: { status: "New" } }],
    }
  },
},

我知道我可以对所有文档应用query，但我希望能够在子文档中进行更复杂的过滤(即过滤出同时包含message: hi和status: New的buckets )。

Answer 1

因为上面显示的示例中没有同时包含message: hi和status: New的文档。

添加了一个使用filter aggregation过滤同时包含message: Hi和session: session-1的文档的工作示例。

{
  "size": 0,
  "aggs": {
    "filtererd": {
      "filter": {
        "bool": {
          "must": [
            {
              "match": {
                "message": "hi"
              }
            },
            {
              "match": {
                "session.keyword": "session-1"
              }
            }
          ]
        }
      },
      "aggs": {
        "top_filter": {
          "top_hits": {}
        }
      }
    }
  }
}

搜索结果将是

"aggregations": {
    "filtererd": {
      "doc_count": 1,
      "top_filter": {
        "hits": {
          "total": {
            "value": 1,
            "relation": "eq"
          },
          "max_score": 1.0,
          "hits": [
            {
              "_index": "66714173",
              "_type": "_doc",
              "_id": "3",
              "_score": 1.0,
              "_source": {
                "session": "session-1",
                "message": "hi there"
              }
            }
          ]
        }
      }
    }
  }

如果要过滤terms aggregation的结果，则为

搜索查询：

{
  "size": 0,
  "aggs": {
    "genres": {
      "terms": {
        "field": "session"
      },
      "aggs": {
        "filtererd": {
          "filter": {
            "bool": {
              "must": [
                {
                  "match": {
                    "message": "hi"
                  }
                }
              ]
            }
          }
        }
      }
    }
  }
}

搜索结果将为

"aggregations": {
    "genres": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": "session-1",
          "doc_count": 3,
          "filtererd": {
            "doc_count": 1             // note this
          }
        },
        {
          "key": "session-2",
          "doc_count": 2,
          "filtererd": {
            "doc_count": 1
          }
        }
      ]
    }