Can aggregation return the documents in each bucket?

Elastic Stack Elasticsearch
1

It seems aggregation will return the count of documents for each bucket.

Can I also retrieve the documents within each bucket that matched that
bucket criteria?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

Hi,

Unfortunately, this is not possible, aggregations cannot return whole
documents today.

On Wed, Mar 19, 2014 at 1:07 AM, Erich Lin elin@onekingslane.com wrote:

It seems aggregation will return the count of documents for each bucket.

Can I also retrieve the documents within each bucket that matched that
bucket criteria?

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40googlegroups.comhttps://groups.google.com/d/msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j54QLzGup4xTfjoYBf21vKd31g2OBBsjREYs0NuPfg3Ag%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

3

Is there any work around to this problem? How can I know which documents
belonged to the bucket? Can it at least return id of the document?

On Thursday, March 20, 2014 9:25:55 PM UTC+11, Adrien Grand wrote:

Hi,

Unfortunately, this is not possible, aggregations cannot return whole
documents today.

On Wed, Mar 19, 2014 at 1:07 AM, Erich Lin <el...@onekingslane.com<javascript:>

wrote:

It seems aggregation will return the count of documents for each bucket.

Can I also retrieve the documents within each bucket that matched that
bucket criteria?

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40googlegroups.comhttps://groups.google.com/d/msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/2e469e40-25c2-46b3-9f0e-79b1b6544423%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

4

Hi,

if you want total number of document you can use _all.

Thanks,
Sumit

5

A work-around could be to run a terms aggregation on the _uid field in
order to get the uids back. But beware that this will require loading
field data for the _uid field, which can be quite expensive.

On Wed, Apr 23, 2014 at 8:37 AM, Pratikshya Kuinkel
prati.ekshya@gmail.comwrote:

Is there any work around to this problem? How can I know which documents
belonged to the bucket? Can it at least return id of the document?

On Thursday, March 20, 2014 9:25:55 PM UTC+11, Adrien Grand wrote:

Hi,

Unfortunately, this is not possible, aggregations cannot return whole
documents today.

On Wed, Mar 19, 2014 at 1:07 AM, Erich Lin el...@onekingslane.comwrote:

It seems aggregation will return the count of documents for each bucket.

Can I also retrieve the documents within each bucket that matched that
bucket criteria?

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%
40googlegroups.comhttps://groups.google.com/d/msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/2e469e40-25c2-46b3-9f0e-79b1b6544423%40googlegroups.comhttps://groups.google.com/d/msgid/elasticsearch/2e469e40-25c2-46b3-9f0e-79b1b6544423%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j4dM2EsqegWDb64mMaaQbK%3DoFukXQqds4xwR2nHbRTSWA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

6

Hi,

Is that limitation still true in versions 1.3.4 or 1.4.0?

Nicolas F

Le vendredi 25 avril 2014 12:27:28 UTC+2, Adrien Grand a écrit :

A work-around could be to run a terms aggregation on the _uid field in
order to get the uids back. But beware that this will require loading
field data for the _uid field, which can be quite expensive.

On Wed, Apr 23, 2014 at 8:37 AM, Pratikshya Kuinkel <prati....@gmail.com
<javascript:>> wrote:

Is there any work around to this problem? How can I know which documents
belonged to the bucket? Can it at least return id of the document?

On Thursday, March 20, 2014 9:25:55 PM UTC+11, Adrien Grand wrote:

Hi,

Unfortunately, this is not possible, aggregations cannot return whole
documents today.

On Wed, Mar 19, 2014 at 1:07 AM, Erich Lin el...@onekingslane.com
wrote:

It seems aggregation will return the count of documents for each bucket.

Can I also retrieve the documents within each bucket that matched that
bucket criteria?

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/2e469e40-25c2-46b3-9f0e-79b1b6544423%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/2e469e40-25c2-46b3-9f0e-79b1b6544423%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/a581aa2b-4eae-49db-baeb-07b64ee26ce1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

7

It is not really a limitation but rather a design decision: there is no
limit on the number of documents that can fall into a bucket so we cannot
have an option to return them all. However we have a top_hits aggregation
that can return some of the documents that fell into the bucket:

On Thu, Oct 2, 2014 at 11:40 AM, Nicolas F nicolas.frelat@gmail.com wrote:

Hi,

Is that limitation still true in versions 1.3.4 or 1.4.0?

Nicolas F

Le vendredi 25 avril 2014 12:27:28 UTC+2, Adrien Grand a écrit :

A work-around could be to run a terms aggregation on the _uid field in
order to get the uids back. But beware that this will require loading
field data for the _uid field, which can be quite expensive.

On Wed, Apr 23, 2014 at 8:37 AM, Pratikshya Kuinkel prati....@gmail.com
wrote:

Is there any work around to this problem? How can I know which documents
belonged to the bucket? Can it at least return id of the document?

On Thursday, March 20, 2014 9:25:55 PM UTC+11, Adrien Grand wrote:

Hi,

Unfortunately, this is not possible, aggregations cannot return whole
documents today.

On Wed, Mar 19, 2014 at 1:07 AM, Erich Lin el...@onekingslane.com
wrote:

It seems aggregation will return the count of documents for each
bucket.

Can I also retrieve the documents within each bucket that matched that
bucket criteria?

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40goo
glegroups.com
https://groups.google.com/d/msgid/elasticsearch/0e5c1001-e3bb-4345-849e-3b77816411d8%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/2e469e40-25c2-46b3-9f0e-79b1b6544423%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/2e469e40-25c2-46b3-9f0e-79b1b6544423%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/a581aa2b-4eae-49db-baeb-07b64ee26ce1%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/a581aa2b-4eae-49db-baeb-07b64ee26ce1%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7uS2Ctn3h8w5_qz1ZYf63b5Fsg49EMtCyQGwxUoagpsA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

8

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-metrics-top-hits-aggregation.html#search-aggregations-metrics-top-hits-aggregation

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/60104d1a-cf68-4b09-babe-4524e5c58d5f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.