elastic-Search Aggregation [python]

Question

I indexed the post and community models,

post = Index('posts')
post.settings(
    number_of_shards=1,
    number_of_replicas=0
)

@post.doc_type
class PostDocument(DocType):
    community = fields.ObjectField(properties={
        'id': fields.IntegerField(),
        'description': fields.TextField(),
        'name': fields.StringField(),
    })

I want to search posts and aggregate the communities
(returns communities of the posts in the result)

I may need to use aggregation, I had difficulties while implementing it, the documentation was not clear for me.

q = Q("multi_match", query=query, fields=['title', 'content'])
document.query(q)
document.aggs.bucket('per_tag', 'terms', field='community')

You need to aggregate on a leaf field (e.g. community.id), not on an object field. Can you try that? — Val
– Val, Commented Jun 26, 2019 at 13:44
@Val I try it, it works but not giving me the result I want, could u help plz ? ``` q = Q("multi_match", query=query, fields=['title', 'content']) document.query(q) document.aggs.bucket('per_tag', 'terms', field='community__id') response = document.execute() return response.aggregations.per_tag.buckets ``` — Aymane Max
– Aymane Max, Commented Jun 27, 2019 at 12:02
not giving me the result I want it's hard to know what you expect if you don't explain it ;-) Please show some sample data and what results you expect, it'll be much easier for everyone — Val
– Val, Commented Jun 27, 2019 at 12:23
@Val I want to return a list of Community object not only the IDs — Aymane Max
– Aymane Max, Commented Jun 30, 2019 at 12:44

josemlp · Accepted Answer · 2019-06-26 14:18:40Z

1

I think you need change the aggregation to something similar to:

document.aggs.bucket('per_tag', 'terms', field='community__id')

Because community is a complex objects, and elasticsearch only can do aggregation with simple fields. (keyword or integer)

answered Jun 26, 2019 at 14:18

josemlp

5063 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

elastic-Search Aggregation [python]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related