elasticsearch multiple key documents for aggregation

Question

Our elastic search document currently has following fields: Id, cityId.

It's very easy to aggregate if each document's city field has only 1 cityid i.e. cityid = 1.

But how can we aggregate on cityid if some document have multiple cityid values?

For example, if some document has cityid as (1,2), this shouldn't be treated as a new cityid i.e. (1,2) but this document should consider cityid 1 and cityid 2 as separate keys while aggregation on cityid for these documents.

jhilden · Accepted Answer · 2017-10-25 20:00:34Z

1

If you store the cityid field as an array this will work perfectly. Example:

POST index1/type/
{
   "cityid": [1, 2] 
}

What won't work is if you store it like this:

POST index1/type/
{
   "cityid": "1,2" 
}

answered Oct 25, 2017 at 20:00

jhilden

12.5k5 gold badges56 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

elasticsearch multiple key documents for aggregation

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