Elasticsearch按热门点击聚合中的字段排序

kyvafyod  于 2023-11-17  发布在  ElasticSearch
关注(0)|答案(1)|浏览(180)

我试图在搜索查询Elasticsearch中通过top_hits参数对数据进行排序，但不知何故，它并没有影响任何东西。有人可以帮助我吗？
所以我试着使用sort，就像有些人说的那样：

  1. {
  2.     "size" : 0,
  3.     "from" : 0,
  4.     "aggs": {
  5.         "by_filter": {
  6.             "filter": {
  7.                 "bool": {
  8.                     "must": [
  9.                     {
  10.                         "range": {
  11.                             "published_at": {
  12.                                 "gte": "2019-08-01 00:00:00",
  13.                                 "lte": "2023-10-30 23:59:59"
  14.                             }
  15.                         }
  16.                     },
  17.                     {
  18.                         "match": {
  19.                             "status": "published"
  20.                         }
  21.                     }
  22.                     ]
  23.                 }
  24.             },
  25.             "aggs": {
  26.                 "by_created": {
  27.                     "terms": {
  28.                         "field": "created_by.id",
  29.                         "size": 10
  30.                     },
  31.                     "aggs" : {
  32.                         "count_data": {
  33.                             "terms": {
  34.                                 "field": "created_by.id"
  35.                             }
  36.                         },
  37.                         "hits": {
  38.                             "top_hits": {
  39.                                 "sort": [                         <---- the sort query that I found
  40.                                     {
  41.                                         "created_by.id": {
  42.                                             "order": "desc"
  43.                                         }
  44.                                     }
  45.                                 ],
  46.                                 "_source":["created_by.id"],
  47.                                 "size": 1
  48.                             }
  49.                         }
  50.                     }
  51.                 }
  52.             }
  53.         }
  54.     }
  55. }

字符串
但结果并没有改变

  1. "aggregations": {
  2.     "by_filter": {
  3.         "doc_count": 21,
  4.         "by_created": {
  5.             "doc_count_error_upper_bound": 0,
  6.             "sum_other_doc_count": 3,
  7.             "buckets": [
  8.                 {
  9.                     "key": 34,
  10.                     "doc_count": 3,
  11.                     "hits": {
  12.                         "hits": {
  13.                             "total": {
  14.                                 "value": 3,
  15.                                 "relation": "eq"
  16.                             },
  17.                             "max_score": null,
  18.                             "hits": [
  19.                                 {
  20.                                     "_index": "re_article",
  21.                                     "_id": "53822",
  22.                                     "_score": null,
  23.                                     "_source": {
  24.                                         "created_by": {
  25.                                             "id": 34
  26.                                         }
  27.                                     },
  28.                                     "sort": [                <--- I think this is the result of the sort
  29.                                         34
  30.                                     ]
  31.                                 }
  32.                             ]
  33.                         }
  34.                     },
  35.                     "count_data": {
  36.                         "doc_count_error_upper_bound": 0,
  37.                         "sum_other_doc_count": 0,
  38.                         "buckets": [
  39.                             {
  40.                                 "key": 34,
  41.                                 "doc_count": 3
  42.                             }
  43.                         ]
  44.                     }
  45.                 },
  46.                 {
  47.                     "key": 52,
  48.                     "doc_count": 3,
  49.                     "hits": {
  50.                         "hits": {
  51.                             "total": {
  52.                                 "value": 3,
  53.                                 "relation": "eq"
  54.                             },
  55.                             "max_score": null,
  56.                             "hits": [
  57.                                 {
  58.                                     "_index": "re_article",
  59.                                     "_id": "338610",
  60.                                     "_score": null,
  61.                                     "_source": {
  62.                                         "created_by": {
  63.                                             "id": 52
  64.                                         }
  65.                                     },
  66.                                     "sort": [
  67.                                         52
  68.                                     ]
  69.                                 }
  70.                             ]
  71.                         }
  72.                     },
  73.                     "count_data": {
  74.                         "doc_count_error_upper_bound": 0,
  75.                         "sum_other_doc_count": 0,
  76.                         "buckets": [
  77.                             {
  78.                                 "key": 52,
  79.                                 "doc_count": 3
  80.                             }
  81.                         ]
  82.                     }
  83.                 }
  84.             ]
  85.         }
  86.     }
  87. }

型
我所期望的是桶先显示键52，然后是34，像这样：

  1. "aggregations": {
  2.     "by_filter": {
  3.         "doc_count": 21,
  4.         "by_created": {
  5.             "doc_count_error_upper_bound": 0,
  6.             "sum_other_doc_count": 3,
  7.             "buckets": [
  8.                 {
  9.                     "key": 52,
  10.                     "doc_count": 3,
  11.                     "hits": {
  12.                         "hits": {
  13.                             "total": {
  14.                                 "value": 3,
  15.                                 "relation": "eq"
  16.                             },
  17.                             "max_score": null,
  18.                             "hits": [
  19.                                 {
  20.                                     "_index": "re_article",
  21.                                     "_id": "338610",
  22.                                     "_score": null,
  23.                                     "_source": {
  24.                                         "created_by": {
  25.                                             "id": 52
  26.                                         }
  27.                                     }
  28.                                 }
  29.                             ]
  30.                         }
  31.                     },
  32.                     "count_data": {
  33.                         "doc_count_error_upper_bound": 0,
  34.                         "sum_other_doc_count": 0,
  35.                         "buckets": [
  36.                             {
  37.                                 "key": 52,
  38.                                 "doc_count": 3
  39.                             }
  40.                         ]
  41.                     }
  42.                 },
  43.                 {
  44.                     "key": 34,
  45.                     "doc_count": 3,
  46.                     "hits": {
  47.                         "hits": {
  48.                             "total": {
  49.                                 "value": 3,
  50.                                 "relation": "eq"
  51.                             },
  52.                             "max_score": null,
  53.                             "hits": [
  54.                                 {
  55.                                     "_index": "re_article",
  56.                                     "_id": "53822",
  57.                                     "_score": null,
  58.                                     "_source": {
  59.                                         "created_by": {
  60.                                             "id": 34
  61.                                         }
  62.                                     }
  63.                                 }
  64.                             ]
  65.                         }
  66.                     },
  67.                     "count_data": {
  68.                         "doc_count_error_upper_bound": 0,
  69.                         "sum_other_doc_count": 0,
  70.                         "buckets": [
  71.                             {
  72.                                 "key": 34,
  73.                                 "doc_count": 3
  74.                             }
  75.                         ]
  76.                     }
  77.                 }
  78.             ]
  79.         }
  80.     }
  81. }

型
我想我选错了一个例子，因为在top_hits结果中有一个新的“sort”字段，但不是我真正想要的

elasticsearch

1条答案

按热度按时间
qvk1mo1f

qvk1mo1f1#

你很接近了，你只需要将"order"移动到你真正想要排序的聚合中，并稍微改变一下语法。如果你想对by_created聚合中的键排序，你需要将"order"添加到那个聚合中，top_hits中的"order"将对hits排序：

  1. {
  2.     "size" : 0,
  3.     "from" : 0,
  4.     "aggs": {
  5.         "by_filter": {
  6.             "filter": {
  7.                 "bool": {
  8.                     "must": [
  9.                     {
  10.                         "range": {
  11.                             "published_at": {
  12.                                 "gte": "2019-08-01 00:00:00",
  13.                                 "lte": "2023-10-30 23:59:59"
  14.                             }
  15.                         }
  16.                     },
  17.                     {
  18.                         "match": {
  19.                             "status": "published"
  20.                         }
  21.                     }
  22.                     ]
  23.                 }
  24.             },
  25.             "aggs": {
  26.                 "by_created": {
  27.                     "terms": {
  28.                         "field": "created_by.id",
  29.                         "size": 10,
  30.                         "order": {                      <--- try applying it here
  31.                           "_key": "desc"
  32.                         }
  33.                     },
  34.                     "aggs" : {
  35.                         "count_data": {
  36.                             "terms": {
  37.                                 "field": "created_by.id"
  38.                             }
  39.                         },
  40.                         "hits": {
  41.                             "top_hits": {
  42.                                 "sort": [                         <---- the sort query that I found
  43.                                     {
  44.                                         "created_by.id": {
  45.                                             "order": "desc"
  46.                                         }
  47.                                     }
  48.                                 ],
  49.                                 "_source":["created_by.id"],
  50.                                 "size": 1
  51.                             }
  52.                         }
  53.                     }
  54.                 }
  55.             }
  56.         }
  57.     }
  58. }

字符串
你可以在terms聚合文档中找到更多的选项。如果你需要对其他聚合进行排序，你可能会发现bucket_sort aggregation很有用。

展开查看全部
赞(0）分享  回复(0）举报  2023-11-17
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com