How to aggregate array keys in Elastic?

Question

Is it possible to aggregate the keys of fields of Elastic documents? I read through the Elastic aggregation documentation and tried some coding, but didn't succeed.

Existing documents:

{ 
    "analysis": {         
      "v1": {"a":1, "b":2}
    }
}          


{ 
    "analysis": {         
      "v1": {"a":3, "b":4}
    }
}          


{ 
    "analysis": {         
      "v2": {"a":5, "b":6}
    }
}          


{ 
    "analysis": {         
      "v1": {"a":7, "b":8},
      "v2": {"a":9, "b":10},
    }
}

Expected outcome of the aggregation is the count of keys:

{
    "v1": 3,
    "v2": 2
}

Updated source JSON

Currently there is no dedicated mapping, documents are just inserted individually and everything else is Elastic magic. Should I do a mapping? And yes, I want to aggregate the (key) names of the non-leaf nodes. I updated the source JSON. — Mike
– Mike, Commented Apr 26, 2016 at 12:51

Andrei Stefan · Accepted Answer · 2016-04-26 15:46:36Z

1

Try this:

GET /your_index_name/your_type_name/_search
{
  "size": 0,
  "aggs": {
    "v1": {
      "filter": {
        "exists": {
          "field": "analysis.v1"
        }
      }
    },
    "v2": {
      "filter": {
        "exists": {
          "field": "analysis.v2"
        }
      }
    }
  }
}

answered Apr 26, 2016 at 15:46

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

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

1 Comment

Mike Over a year ago

Okay, so I have to manually include every existing version of the analysis. Not perfect, as we have a lot of versions (e.g. v2_3_4), but it's a good start.

Collectives™ on Stack Overflow

How to aggregate array keys in Elastic?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related