blocks|key|4306959|text|在elasticsearch中，无法对聚合进行分页。如果指定了size，查询将不会给出准确的结果。因此，进行排序和分页的唯一方法是指定大小为0并返回所有文档，然后将所有结果累加到一个列表中以供进一步操作，从而获得所需的结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4306960|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In elasticsearch, it's not possible to paginate an aggregation. The query will not give accurate results if size is specified. So, the only way to do sorting and pagination is to give size 0 and return all the documents and then, get the required results by accumulating all the results in a list for further operation.

blocks|key|4307075|text|我认为Composite+Aggregation可能会解决您的问题，因为它允许在聚合结果中进行分页。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4307076|请参考this+doc|4307077|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/guide/en/elasticsearch/reference/master/search-aggregations-bucket-composite-aggregation.html^0|3|L|0|3|8|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@$9|T|A|U|1|V]]|E|$]]|$1|H|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

I think <code>Composite Aggregation</code> might solve your problem, as it allows pagination within aggregated results.

Please refer to <a href="https://www.elastic.co/guide/en/elasticsearch/reference/master/search-aggregations-bucket-composite-aggregation.html" rel="noreferrer">this doc</a>

blocks|key|2195182|text|在v6.1及更高版本中，ElasticSearch支持Bucket+Sort+Aggregation。它允许聚合结果中的"sort“、"size”和"from“参数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2195183|请参考this+doc|2195184|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/guide/en/elasticsearch/reference/master/search-aggregations-pipeline-bucket-sort-aggregation.html^0|R|N|0|3|8|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@$9|T|A|U|1|V]]|E|$]]|$1|H|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

ElasticSearch supports <code>Bucket Sort Aggregation</code> in v6.1 and later. It allows "sort", "size" and "from" parameters within aggregated results.

Please refer to <a href="https://www.elastic.co/guide/en/elasticsearch/reference/master/search-aggregations-pipeline-bucket-sort-aggregation.html" rel="noreferrer">this doc</a>

blocks|key|4307273|text|是的，这是可能的分页%2B排序%2B搜索弹性搜索Open+link。Elasticsearch在v6.X及更高版本中支持Bucket+Sort+Aggregation。此bucket_sort使用terms/date_histogram存储桶中的所有记录，并应用于此存储桶。因此，对于这种情况，我们必须将存储桶大小保持得足够大或大于存储桶记录，以便在存储桶中保留所有可能的记录。示例如下...|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4307274|{
++++"aggs":+{
++++++++"aggs1":+{
++++++++++++"terms":+{
++++++++++++++++"field":+"field_name.keyword",
++++++++++++++++//+We+can+do+sort+here+also
++++++++++++++++"size":+1000000++//+Keep+this+size+big+integer.+This+keep+all+possible+result+in+bucket
++++++++++++},
++++++++++++"aggs":+{
++++++++++++++++"bucket_sort":+{
++++++++++++++++++++"bucket_sort":+{+++++++++++++++++++++++++++++++++
++++++++++++++++++++++++"sort":+[{
++++++++++++++++++++++++++++"_key":+{
++++++++++++++++++++++++++++++++"order":+"asc"
++++++++++++++++++++++++++++}
++++++++++++++++++++++++}],
++++++++++++++++++++++++//+This+"from"+and+"size"+use+above+terms+bucket+size.+it+applies+over+available+bucket+data+[This+one+give+actual+result]
++++++++++++++++++++++++//+Bellow+is+standard+pagination+as+we+do
++++++++++++++++++++++++"from":+0,
++++++++++++++++++++++++"size":+10
++++++++++++++++++++}
++++++++++++++++}
++++++++++++}
++++++++}
++++},
++++"size":+0
}|code-block|syntax|javascript|4307275|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-sort-aggregation.html^0|1K|N|29|B|K|9|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|F|3|G|5|H|7|10|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Yes it is possible pagination + sorting + searching elasticsearch <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-sort-aggregation.html" rel="nofollow noreferrer">Open link</a>. Elasticsearch supports Bucket Sort Aggregation in in v6.X and later. This bucket_sort uses all records in terms/date_histogram bucket and apply over that. So for this case we have to keep bucket size big enough or more than bucket records so that it keep all possible records in bucket. Example as follows...

<pre><code>{
 "aggs": {
 "aggs1": {
 "terms": {
 "field": "field_name.keyword",
 // We can do sort here also
 "size": 1000000 // Keep this size big integer. This keep all possible result in bucket
 },
 "aggs": {
 "bucket_sort": {
 "bucket_sort": { 
 "sort": [{
 "_key": {
 "order": "asc"
 }
 }],
 // This "from" and "size" use above terms bucket size. it applies over available bucket data [This one give actual result]
 // Bellow is standard pagination as we do
 "from": 0,
 "size": 10
 }
 }
 }
 }
 },
 "size": 0
}
</code></pre>

blocks|key|5724359|text|partition支持对聚合结果进行分页。官方文档中的这一部分非常有用。https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#_filtering_values_with_partitions|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5724360|{
+++"size":+0,
+++"aggs":+{
++++++"expired_sessions":+{
+++++++++"terms":+{
++++++++++++"field":+"account_id",
++++++++++++"include":+{
+++++++++++++++"partition":+0,
+++++++++++++++"num_partitions":+20
++++++++++++},
++++++++++++"size":+10000,
++++++++++++"order":+{
+++++++++++++++"last_access":+"asc"
++++++++++++}
+++++++++},
+++++++++"aggs":+{
++++++++++++"last_access":+{
+++++++++++++++"max":+{
++++++++++++++++++"field":+"access_date"
+++++++++++++++}
++++++++++++}
+++++++++}
++++++}
+++}
}|code-block|syntax|javascript|5724361|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#_filtering_values_with_partitions^0|0|9|10|43|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Paging aggregation results is supported using <code>partition</code>. This section in the official docs is very helpful.
<a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#_filtering_values_with_partitions" rel="nofollow noreferrer">https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#_filtering_values_with_partitions</a>

<pre><code>{
 "size": 0,
 "aggs": {
 "expired_sessions": {
 "terms": {
 "field": "account_id",
 "include": {
 "partition": 0,
 "num_partitions": 20
 },
 "size": 10000,
 "order": {
 "last_access": "asc"
 }
 },
 "aggs": {
 "last_access": {
 "max": {
 "field": "access_date"
 }
 }
 }
 }
 }
}
</code></pre>

blocks|key|1717202|text|在elasticsearch中，没有精确的解决方案。You+may+use+filtering+with+partition+options但应用的分区程序可能会破坏您的排序结果。ES对给定字段执行分区操作，从请求的分区返回存储桶。因此，您的结果以分区排序结束。(您需要使用其他分区号发出后续请求，以便从所有分区收集数据。)|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1717203|我的建议是，正如您在问题中提到的那样，为每个术语指定一个更高的尺寸值。|1717204|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/guide/en/elasticsearch/reference/5.2/search-aggregations-bucket-terms-aggregation.html#_filtering_values_with_partitions^0|26|B|2W|6|Q|18|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@$9|U|A|V|1|W]]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

In elasticsearch, there is no accurate solution for it. <a href="https://www.elastic.co/guide/en/elasticsearch/reference/5.2/search-aggregations-bucket-terms-aggregation.html#_filtering_values_with_partitions" rel="nofollow noreferrer">You may use filtering with partition options</a> but applied partitioner can break your sorted result. ES performs partition operation over a given field and returns buckets from requested partition. So your result end up with partition ordered.(you need to make subsequent request with other partition number to gather data from all partitions.) 

My suggestion is give a higher size value for each term as you mentioned in your question.

blocks|key|2195157|text|你可以使用一个变通的方法。假设您希望以字段f1的升序显示每页10条记录，然后为每页存储该字段的最后一个值(第10，20...)并在搜索查询中使用大于和排序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2195158|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can use a work around. Suppose you want to show 10 records per page in ascending order of a field f1, then store the last value of that field for each page(10th, 20th ...) and use greater than and sort in the search query.

blocks|key|4307187|text|如果有人也在为同样的问题而苦苦挣扎，这里有一个适用于我的PHP+and+Elastica+(http://elastica.io/)解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4307188|function+addAggregationFields($oAgg){
++++$oAggField+=+new+Stats('costs');
++++$oAggField->setField('costs');
++++$oAgg->addAggregation($oAggField);
++++return+$oAgg;
}
function+addAggregationFilters($oAggFilter){
++++$oFilters+=+new+\Elastica\Query\Terms();
++++$oFilters->setTerms("user_id",+[3,7]);
++++$oAggFilter->setFilter($oFilters);
++++return+$oAggFilter;
}


$iItemsInPage+=+100;
$iPage++++++++=+0;
$sGoupBy+=+"created_date";

$oStore+=+new+Store();
$oStore->setConfiguration(new+SearchConfiguration());
$oIndex+=+$oStore->getIndex("report_*");

$oAggFilter+=+new+Filter('cardinality');
$oAggFilter+=+addAggregationFilters($oAggFilter);

$oAgg+=+new+Cardinality('cardinality');
$oAgg->setField($sGoupBy);
$oAggFilter->addAggregation($oAgg);

$oCardinalityQuery+=+new+Query();
$oCardinalityQuery->setSize(0);
$oCardinalityQuery->addAggregation($oAggFilter);
$resultSet+=+$oIndex->search($oCardinalityQuery)->getAggregations();

if(isset($resultSet['cardinality']))+{
++++$iCardinality+=+$resultSet['cardinality']['cardinality']['value'];
++++if(0+!=+$resultSet['cardinality']['cardinality']['value'])+{
++++++++$iPages+=+ceil($iCardinality+/+$iItemsInPage);
++++}+else+{
++++++++$iPages+=+1;
++++}
}

$oAggFilter+=+new+Filter('aggregation_result');
$oAggFilter+=+addAggregationFilters($oAggFilter);

$oAgg+=+new+\Elastica\Aggregation\Terms('terms');
$oAgg->setField($sGoupBy);
$oAgg->setParam("include",+array("partition"+=>+$iPage,+"num_partitions"+=>+$iPages));
$oAgg->setOrder('costs.sum',+'desc');

$oAgg->setSize($iItemsInPage);
$oAgg+=+$this->addAggregationFields($oAgg);
$oAggFilter->addAggregation($oAgg);

$oQuery+=+new+Query();
$oQuery->addAggregation($oAggFilter);
$oQuery->setSize(0);

$resultSet+=+$oIndex->search($oQuery)->getAggregations();|code-block|syntax|javascript|4307189|该过程在https://stackoverflow.com/a/54351245/2923963中进行了描述|4307190|entityMap|0|LINK|mutability|MUTABLE|url|http://elastica.io/|1|https://stackoverflow.com/a/54351245/2923963^0|1A|J|0|0|0|4|18|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|K|3|-4|5|6|7|13|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]]]

If someone also struggle with the same problem here is a PHP and Elastica (<a href="http://elastica.io/" rel="nofollow noreferrer">http://elastica.io/</a>) solution that works for me. 

<pre><code>function addAggregationFields($oAgg){
 $oAggField = new Stats('costs');
 $oAggField-&gt;setField('costs');
 $oAgg-&gt;addAggregation($oAggField);
 return $oAgg;
}
function addAggregationFilters($oAggFilter){
 $oFilters = new \Elastica\Query\Terms();
 $oFilters-&gt;setTerms("user_id", [3,7]);
 $oAggFilter-&gt;setFilter($oFilters);
 return $oAggFilter;
}


$iItemsInPage = 100;
$iPage = 0;
$sGoupBy = "created_date";

$oStore = new Store();
$oStore-&gt;setConfiguration(new SearchConfiguration());
$oIndex = $oStore-&gt;getIndex("report_*");

$oAggFilter = new Filter('cardinality');
$oAggFilter = addAggregationFilters($oAggFilter);

$oAgg = new Cardinality('cardinality');
$oAgg-&gt;setField($sGoupBy);
$oAggFilter-&gt;addAggregation($oAgg);

$oCardinalityQuery = new Query();
$oCardinalityQuery-&gt;setSize(0);
$oCardinalityQuery-&gt;addAggregation($oAggFilter);
$resultSet = $oIndex-&gt;search($oCardinalityQuery)-&gt;getAggregations();

if(isset($resultSet['cardinality'])) {
 $iCardinality = $resultSet['cardinality']['cardinality']['value'];
 if(0 != $resultSet['cardinality']['cardinality']['value']) {
 $iPages = ceil($iCardinality / $iItemsInPage);
 } else {
 $iPages = 1;
 }
}

$oAggFilter = new Filter('aggregation_result');
$oAggFilter = addAggregationFilters($oAggFilter);

$oAgg = new \Elastica\Aggregation\Terms('terms');
$oAgg-&gt;setField($sGoupBy);
$oAgg-&gt;setParam("include", array("partition" =&gt; $iPage, "num_partitions" =&gt; $iPages));
$oAgg-&gt;setOrder('costs.sum', 'desc');

$oAgg-&gt;setSize($iItemsInPage);
$oAgg = $this-&gt;addAggregationFields($oAgg);
$oAggFilter-&gt;addAggregation($oAgg);

$oQuery = new Query();
$oQuery-&gt;addAggregation($oAggFilter);
$oQuery-&gt;setSize(0);

$resultSet = $oIndex-&gt;search($oQuery)-&gt;getAggregations();
</code></pre>

The Process is described here <a href="https://stackoverflow.com/a/54351245/2923963">https://stackoverflow.com/a/54351245/2923963</a>

I need to do an aggregation + sorting + pagination in one of the indexes.

I learned about internal functionality of Elastic search,

I have 5 total shards, it will sort the individual shards and fetch the result, by default each shard will return in 10 records. Then the 50 records are sorted again and it will fetch the top 10 record since by default size is 10.

ouput:

The aggregated results are returned in separate field named as "aggregations".In order to do pagination in this aggregated data,size and from are not working.

So tired of doing termBuilder.size(500), now the logic was differs as per this link (<a href="http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html" rel="noreferrer">http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html</a>)

It leads to inaccuracy of data.

Can any one suggest me how to deal with aggregation + pagination.

Aggregation + sorting +pagination in elastic search

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我需要在其中一个索引中执行聚合+排序+分页。我了解了Elastic search的内部功能，我总共有5个分片，它将对单个分片进行排序并获取结果，默认情况下，每个分片将返回10条记录。然后再对这50条记录进行排序，它将获取前10条记录，因为默认大小是10。输出：聚合结果被返回在名为“aggregations”的单独字段中，以便在此聚合数据中进行分页，size和.In不起作用。我厌倦了做termBui

问弹性搜索中的聚合+排序+分页
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问弹性搜索中的聚合+排序+分页EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问弹性搜索中的聚合+排序+分页
EN