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
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+unsubscr...@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.
>
--
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+unsubscr...@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.
