ElasticSearch 聚合查询之指标聚合

• max min sum avg

{
  "query": {
    "bool": {
      "must": [
        {
          "wildcard": {
            "countryEn": {
              "value": "L*"
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "maxAge": {
      "max": {
        "field": "age"
      }
    },
    "minAge":{
      "min": {
        "field": "age"
      }
    },
    "countAge":{
      "value_count": {
        "field": "age"
      }
    },
    "avgAge":{
      "avg": {
        "field": "age"
      }
    }
  }
}

• Cardinality 值去重计数

{
  "query": {
    "bool": {
      "must": [
        {
          "wildcard": {
            "countryEn": {
              "value": "L*"
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "counAget": {
      "cardinality": {
        "field": "age"
      }
    }
  }
}

• stats 统计count max min avg sum 5个值

{
  "query": {
    "bool": {
      "must": [
        {
          "wildcard": {
            "countryEn": {
              "value": "L*"
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "statsAge": {
      "stats": {
        "field": "age"
      }
    }
  }
}

• Extended stats ⽐比stats多4个统计结果: 平⽅方和、⽅方差、标准差、平均值加/减两个标准差的区间

{
  "query": {
    "bool": {
      "must": [
        {
          "wildcard": {
            "countryEn": {
              "value": "L*"
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "extendStatsAge": {
      "extended_stats": {
        "field": "age"
      }
    }
  }
}

• Percentiles 占⽐比百分位对应的值统计

{
  "query": {
    "bool": {
      "must": [
        {
          "wildcard": {
            "countryEn": {
              "value": "L*"
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "pecentAge": {
      "percentiles": {
        "field": "age",
        "percents": [
20, 50, 75
]
      }
    }
  }
}