Elasticsearch - Scenario Based  Question - Sibling Aggregation

Task

Given "flights" index

1. Group airlines by field called AIRLINE.
2. Find Average Flight AIR_TIME Duration By AIRLINE
3. Find the Maximum Average Flight AIR_TIME Duration By AIRLINE

Dataset

GET flights/_search
{
  "size": 0,
  "aggs": {
    "unique_airlines": {
      "cardinality": {
        "field": "AIRLINE"
      }
    }
  }
}

Solution

GET flights/_search
{
  "size": 0,
  "aggs": {
    "group_flights_by_airline": {
      "terms": {
        "field": "AIRLINE",
        "size": 14
      },
      "aggs": {
        "avg_flight_duration_by_airtime": {
          "avg": {
            "field": "AIR_TIME"
          }
        }
      }
    },
    "max_avg_flight_duration_by_airtime": {
      "max_bucket": {
        "buckets_path": "group_flights_by_airline>avg_flight_duration_by_airtime"
      }
    }
  }
}

Solution

THANKS

FOR

WATCHING

Elasticsearch-Scenario-Based-Question-Sibling-Aggregation

By Deepak Dubey

Elasticsearch-Scenario-Based-Question-Sibling-Aggregation

  • 698