Aggregation on query in Elasticsearch

Question

i have index in es and this is the corresponding mapping :

'''

 GET /vid_detect2/_mapping
            
        {

            "properties": {
                "date":{"type":"date"},
                "time":{ "type": "text",
                         "fielddata": true},
                "frame_id": {"type":"integer"},
                "camera_id":{"type":"integer"},
                "path":{"type":"text"},
                "objects" : {"type": "nested", 
                             "properties": {
                                            "class":    { "type": "text" ,"fielddata":true },
                                            "confidence": { "type": "float"  },
                                             "coordinates":{ "type": "nested" ,
                                                             "properties": { "x" :{"type":"float"},
                                                                             "y" :{"type":"float"},
                                                                             "w" :{"type":"float"},
                                                                             "h" :{"type":"float"}
                                                             }  }
        
                                            }
                
            }
        
    }
}'''

I want to run following query first :

 "query": {
 "bool": {
  "must": [
   {
     "nested": {
    "path": "objects", 
    "query": {
      "bool": {
        "must": [ 
          { "match": { "objects.class": "person" }}
        
        ]
}}}}
]
 }}

and then aggregate the returned results with respect to camera_id and further aggregate those aggregated results with date histogram. Please help.

Val · Accepted Answer · 2020-07-20 10:01:16Z

1

Good start! You can now simply add an aggregation section to achieve what you want:

{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "objects",
            "query": {
              "bool": {
                "must": [
                  {
                    "match": {
                      "objects.class": "person"
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "camera": {
      "terms": {
        "field": "camera_id"
      },
      "aggs": {
        "histo": {
          "date_histogram": {
            "field": "date",
            "interval": "day"
          }
        }
      }
    }
  }
}

answered Jul 20, 2020 at 10:01

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

Raghvendra Tiwari Over a year ago

I am trying to create Tag cloud in Kibana on field "objects.class" but i am not able to find "object.class" field in visualize=>create=>tagcloud=>field. I tried to change the mapping as well by adding on "class": { "type": "text" ,"fields" : { "keyword" : { "type" : "keyword", "ignore_above" : 256 } } Please help .

Val Over a year ago

You should create a new question with your new need

Collectives™ on Stack Overflow

Aggregation on query in Elasticsearch

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related