es聚合分页查询

关注

原创最新推荐文章于 2026-09-07 13:25:07 发布 1.3k 阅读 AI 写同款· GEO 优化 ›

【ElasticSearch笔记】使用Python生成ES DSL语句将传统的JSON DSL语句，映射为Python类、对象操作，使其两者相互转换互通，减少手动编写JSON DSL语句的繁琐，提高可维护性。阅读详情

GET /zhongyou_news_log/_search
{
  "aggs": {
    "time": {
      "date_histogram": {
        "field": "sendTime",
        "interval": "day"
      },
      "aggs": {
        "r_bucket_sort": {
          "bucket_sort": {
            "sort": {
              "_key": {
                "order": "desc"
              }
            },
            "from": 0,
            "size": 10
          }
        }
      }
    }
  },
  "size": 0
}

"aggs": {
            "pv_count": {
              "value_count": {
                "field": "scene.pid"
              }
            },
            "r_bucket_sort": {
              "bucket_sort": {
                "sort": {
                  "pv_count": {
                    "order": "desc"
                  }
                },
                "from": 10,
                "size": 10
              }
            }
          }

java代码

GET /zhongyou_news_log/_search
{
  "aggs": {
    "time": {
      "date_histogram": {
        "field": "sendTime",
        "interval": "day",
        "min_doc_count": 1
      },
      "aggs": {
        "domainUrlMain": {
          "terms": {
            "field": "domainUrlMain"
          },
          "aggs": {
            "sendStatus": {
              "terms": {
                "field": "sendStatus",
                "size": 10
              }
            }
          }
        },
        "r_bucket_sort": {
          "bucket_sort": {
            "sort": {
              "_key": {
                "order": "desc"
              }
            }
            
          
          }
        }
      }
    }
  },
  "size": 0
}

 DateHistogramAggregationBuilder sendTime = AggregationBuilders.dateHistogram("sendTime").field("sendTime")
                .dateHistogramInterval(DateHistogramInterval.DAY).format("yyyy-MM-dd")
                .minDocCount(1)
                .order(BucketOrder.key(false));
        AggregationBuilder domainUrlMain = AggregationBuilders.terms("domainUrlMain").field("domainUrlMain");
        AggregationBuilder sendStatus = AggregationBuilders.terms("sendStatus").field("sendStatus");
        sendTime.subAggregation(domainUrlMain);
        domainUrlMain.subAggregation(sendStatus);