nested count aggregations in elasticsearch

Question

I have a type in elasticsearch where each user can post any number of posts(fields being "userid" and "post").Now I need the count of users who posted 0 post,1 post,2 posts and so on....how do I do it? I think it needs some nested aggregations implemented but I don't know how to proceed. Thanks in advance !

Please share the mapping of you index. GET /index/type/_mapping — Richa
– Richa, Commented Mar 22, 2016 at 7:14
It would probably be helpful if you shared your mapping and one or two sample documents. Also what kind of query you currently have. — Val
– Val, Commented Mar 22, 2016 at 7:14
{ "ESIndex": { "mappings": { "user_posts": { "properties": { "post": { "type": "string" }, "userid": { "type": "long" } } } } } } — K.Sudha Snigdha
– K.Sudha Snigdha, Commented Mar 22, 2016 at 8:20

mbudnik · Accepted Answer · 2016-03-22 11:11:44Z

1

The best way of doing this is to add a separate field to store the number of posts.

Scripts are not too efficient (values are getting re-evaluated each time a query executes) and you get the value indexed properly which makes queries and aggregations very fast. Of course you need to be sure you update this count each time you update the document.

edited Mar 22, 2016 at 11:11

answered Mar 22, 2016 at 10:50

mbudnik

2,11715 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Richa · Accepted Answer · 2016-03-22 09:22:31Z

0

You can use script in aggregation:

POST index_name/type_name/_search
{
"aggs": {
  "group By Post Count": {
     "terms": {
         "script" : "doc['post'].size()"
       }
     }
   }
 }

Make sure you enable scriptig

Hope this helps you.

edited Mar 22, 2016 at 9:22

answered Mar 22, 2016 at 7:13

Richa

7,6796 gold badges30 silver badges36 bronze badges

1 Comment

K.Sudha Snigdha Over a year ago

It does not return any error but it does not return the expected results either

Collectives™ on Stack Overflow

nested count aggregations in elasticsearch

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related