Aggregation in Elastic search

Aggregation

Each Aggregation makes buckets, it shows the number of documents


GET /vehicles/cars/_search
{
  "aggs": {
    "popular_cars" : { 
      "terms" : {
        "field" : "make.keyword"
      },
      "aggs" : {
        "avg_price": {
          "avg": {
            "field" : "price"
          }
        }
      }
    }
  },
  "sort" :[
    
    ]
  
  
}

Complete stats

GET /vehicles/cars/_search
{
  "size": 0,
  "query" :{
    "match": {"color": "red"}
  },
  "aggs": {
    "popular_cars" : { 
      "terms" : {
        "field" : "make.keyword"
      },
      "aggs" : {
        "stats_on_price": {
          "stats": {
            "field" : "price"
          }
        }
        
      }
    }
  }
  
  
  
}

gistfile1.txt

GET /vehicles/cars/_search
{
  "query" :{
    "match": {"color": "red"}
  },
  "aggs": {
    "popular_cars" : { 
      "terms" : {
        "field" : "make.keyword"
      },
      "aggs" : {
        "avg_price": {
          "avg": {
            "field" : "price"
          }
        },
        "max_price": {
          "max": {
            "field" : "price"
          }
        },
       "min_price": {
          "min": {
            "field" : "price"
          }
        }
      }
    }
  }
  
  
  
}

Nested Aggregations

GET /vehicles/cars/_search
{
  "size": 0,
  "query" :{
    "match": {"color": "red"}
  },
  "aggs": {
    "popular_cars" : { 
      "terms" : {
        "field" : "make.keyword"
        
      },
      "aggs" : {
        "sold_date_ranges": {
          
          "range": {
            "field" : "sold",
            "ranges": [
              { "from" : "2016-01-01", "to": "2016-05-18" },
              { "from" : "2016-05-08", "to": "2017-01-01" }
              ]
          },
        
        "aggs" :{
          "avg_price" :{
            "avg" : {
              "field": "price"
            }
          }
          
        }
        }
      }
    }
  }
  
  
  
}

Order with Aggregation

GET /vehicles/cars/_search
{
  "size": 0,
  "query" :{
    "match": {"color": "red"}
  },
  "aggs": {
    "popular_cars" : { 
      "terms" : {
        "field" : "make.keyword",
        "order": {"avg_price": "desc"}
        
      },
  
        "aggs" :{
          "avg_price" :{
            "avg" : {
              "field": "price"
            }
          }
        }
    }
  }
  
  
  
}