Aggregation buckets, with an additional key:value inside

Elastic Stack Elasticsearch
1

Hey everyone,

These aggregations are working out great, but I need to return more than
one value in the bucket so we can use them in our API. The basic idea is
that we aggregate all of the category id's, but we also want the
category_name to be included in that same bucket for ease of use.

Mapping:
"categories" : {
"properties" : {
"category_name" : {
"analyzer" : "keyword",
"type" : "string"
},
"category_id" : {
"type" : "integer"
},
"parent_id" : {
"type" : "integer"
}
}
}

Aggs:
aggs: {
categories: {
terms: {
size: 130,
field: "categories.category_id"
}
},

Returns (actual):

"category_stats": [
{
"category_id": 58,
"offer_count": 48885
},
{
"category_id": 1008,
"offer_count": 44530
},

...

Returns (desired):

"category_stats": [
{
"category_name": "Car Rental",
"category_id": 58,
"offer_count": 48885
},
{
"category_name": "Fast Food",
"category_id": 1008,
"offer_count": 44530
},

...

--
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/055d0c2b-f4ba-455b-883f-587c09b61582%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

I maintain a mapping on the client side to due the lookups. Thankfully my
taxonomy is static (but somewhat large). There is a PR to do server-side
mappings, but I don't think it would apply to aggregations and is quite old.

An alternative solution would be to create compound values such as
"48885:Car Rental" and decompose the value on the client side, but this
would create a string aggregation, which could have slower performance.

Cheers,

Ivan

On Fri, Oct 24, 2014 at 5:50 PM, Cody Stringham cs.negativ@gmail.com
wrote:

Hey everyone,

These aggregations are working out great, but I need to return more than
one value in the bucket so we can use them in our API. The basic idea is
that we aggregate all of the category id's, but we also want the
category_name to be included in that same bucket for ease of use.

Mapping:
"categories" : {
"properties" : {
"category_name" : {
"analyzer" : "keyword",
"type" : "string"
},
"category_id" : {
"type" : "integer"
},
"parent_id" : {
"type" : "integer"
}
}
}

Aggs:
aggs: {
categories: {
terms: {
size: 130,
field: "categories.category_id"
}
},

Returns (actual):

"category_stats": [
{
"category_id": 58,
"offer_count": 48885
},
{
"category_id": 1008,
"offer_count": 44530
},

...

Returns (desired):

"category_stats": [
{
"category_name": "Car Rental",
"category_id": 58,
"offer_count": 48885
},
{
"category_name": "Fast Food",
"category_id": 1008,
"offer_count": 44530
},

...

--
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/055d0c2b-f4ba-455b-883f-587c09b61582%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/055d0c2b-f4ba-455b-883f-587c09b61582%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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/CALY%3DcQB-Asuq5igGP-mJQ7RGv4t2CjsjryBGSTPDn0EAb-vfZw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.