返回多术语不同值

Question

在弹性搜索索引中，我试图通过来自字段companyName和字段productName的两个不同的顶级字段值进行查询，按generatedDate字段排序，并包括domainModelId字段。

下面的SQL查询显示了所有现有值的结果，我通过generatedDate突出显示了两个唯一的文档行(在本例中);

{
    "query": "SELECT companyName, productName, generatedDate FROM nextware_domain_metaservices_domainmodel ORDER BY generatedDate DESC"
} 

响应如下：

我尝试了以下方法

{
  "size":0,
  "aggs": 
  {
    "companies": 
    {
        "terms": 
        {
            "field": "companyName.keyword"
        },
        "aggs": 
        {
            "products": 
            {
                "terms": 
                {
                    "field": "productName.keyword"
                }
            }
        }
     }
   }
}

这将返回正确的存储桶，如下所示;

 "aggregations": {
    "companies": {
        "doc_count_error_upper_bound": 0,
        "sum_other_doc_count": 0,
        "buckets": [
            {
                "key": "NextWare",
                "doc_count": 18,
                "products": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": [
                        {
                            "key": "ProductPortal",
                            "doc_count": 16
                        },
                        {
                            "key": "Domain",
                            "doc_count": 2
                        }
                    ]
                }
            }
        ]
    }
}

如何包含domainModelId的值？没有第二个查询的Id字段？

Answer 1

包含< code>domainModelId的值。Id，您需要使用top_hits聚合

添加包含索引数据、搜索查询和搜索结果的工作示例

索引数据：

{
    "companyName":"NextWare",
    "productName":"Domain",
    "domainModelId.Id":"i"
}
{
    "companyName":"NextWare",
    "productName":"Domain",
    "domainModelId.Id":"c"
}
{
    "companyName":"NextWare",
    "productName":"ProductPortal",
    "domainModelId.Id":"a"
}
{
    "companyName":"NextWare",
    "productName":"ProductPortal",
    "domainModelId.Id":"b"
}
{
    "companyName":"NextWare",
    "productName":"ProductPortal",
    "domainModelId.Id":"d"
}
{
    "companyName":"NextWare",
    "productName":"ProductPortal",
    "domainModelId.Id":"e"
}
{
    "companyName":"NextWare",
    "productName":"ProductPortal",
    "domainModelId.Id":"f"
}
{
    "companyName":"NextWare",
    "productName":"ProductPortal",
    "domainModelId.Id":"g"
}
{
    "companyName":"NextWare",
    "productName":"ProductPortal",
    "domainModelId.Id":"h"
}

搜索查询：

{
  "size": 0,
  "aggs": {
    "companies": {
      "terms": {
        "field": "companyName.keyword"
      },
      "aggs": {
        "products": {
          "terms": {
            "field": "productName.keyword"
          },
          "aggs": {
            "top_ids": {
              "top_hits": {
                "_source": {
                  "includes": [
                    "domainModelId.Id"
                  ]
                },
                "size": 10
              }
            }
          }
        }
      }
    }
  }
}

搜索结果：

"aggregations": {
    "companies": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": "NextWare",
          "doc_count": 9,
          "products": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": "ProductPortal",
                "doc_count": 7,
                "top_ids": {
                  "hits": {
                    "total": {
                      "value": 7,
                      "relation": "eq"
                    },
                    "max_score": 1.0,
                    "hits": [
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "1",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "a"
                        }
                      },
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "2",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "b"
                        }
                      },
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "4",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "d"
                        }
                      },
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "5",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "e"
                        }
                      },
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "6",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "f"
                        }
                      },
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "7",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "g"
                        }
                      },
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "8",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "h"
                        }
                      }
                    ]
                  }
                }
              },
              {
                "key": "Domain",
                "doc_count": 2,
                "top_ids": {
                  "hits": {
                    "total": {
                      "value": 2,
                      "relation": "eq"
                    },
                    "max_score": 1.0,
                    "hits": [
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "3",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "c"
                        }
                      },
                      {
                        "_index": "67049816",
                        "_type": "_doc",
                        "_id": "9",
                        "_score": 1.0,
                        "_source": {
                          "domainModelId.Id": "i"
                        }
                      }
                    ]
                  }
                }
              }
            ]
          }
        }
      ]
    }
  }