ElasticSearch 聚合查询

朱雀 2023-07-18 06:28 176阅读 0赞

价格总和：

1,使用aggs   2,自己起个名字price\_of\_sum  3,求和sum   4，filed要求和的字段

GET /lib5/items/_search
    {
      "aggs": {
        "price_of_sum": {
          "sum": {
            "field": "price"
          }
        }
      }
    }

聚合查询结果：

{
      "took" : 414,
      "timed_out" : false,
      "_shards" : {
        "total" : 5,
        "successful" : 5,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : {
        "total" : 5,
        "max_score" : 1.0,
        "hits" : [
          {
            "_index" : "lib5",
            "_type" : "items",
            "_id" : "5",
            "_score" : 1.0,
            "_source" : {
              "price" : null,
              "itemID" : "ID100127"
            }
          },
          {
            "_index" : "lib5",
            "_type" : "items",
            "_id" : "2",
            "_score" : 1.0,
            "_source" : {
              "price" : 50,
              "itemID" : "ID100124"
            }
          },
          {
            "_index" : "lib5",
            "_type" : "items",
            "_id" : "4",
            "_score" : 1.0,
            "_source" : {
              "price" : 30,
              "itemID" : "ID100125"
            }
          },
          {
            "_index" : "lib5",
            "_type" : "items",
            "_id" : "1",
            "_score" : 1.0,
            "_source" : {
              "price" : 40,
              "itemID" : "ID100123"
            }
          },
          {
            "_index" : "lib5",
            "_type" : "items",
            "_id" : "3",
            "_score" : 1.0,
            "_source" : {
              "price" : 25,
              "itemID" : "ID100124"
            }
          }
        ]
      },
      "aggregations" : {
        "price_of_sum" : {
          "value" : 145.0
        }
      }
    }

发现好多信息，但是我们并不关系我只想看聚合结果，只需要加一个 "size": 0

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 1][]

#练习 对有唱歌兴趣的用户按年龄分组
    GET /lib4/user/_search
    {
      "query": {
        "match": {
          "interests": "唱歌"
        }
      },
      "aggs": {
        "age_of_group": {
          "terms": {
            "field": "age"
          }
        }
      }
      
    }

#2.9聚合查询
    #(1)sum
    GET /lib5/items/_search 
    { 
      "size":0, 
      "aggs":{ 
        "price_of_sum":{ 
          "sum":{ "field": "price" }
        }
      }
    }
    
    #(2)min
    GET /lib5/items/_search 
    {
      "size":0, 
      "aggs":{
        "price_of_min":{
          "min":{ "field": "price" }
        }
      }
    }
    
    #(3)max
    GET /lib5/items/_search
    { 
      "size":0, 
      "aggs":{
        "price_of_max":{ 
          "max":{ "field": "price"}
        }
      }
    }
    
    #(4)avg
    GET /lib5/items/_search 
    { 
      "size" :0,
      "aggs":{ 
        "price_of_avg":{
          "avg":{"field": "price" }
        }
      }
    }
    
    #(5)cardinality:求基数
    GET /lib5/items/_search 
    { 
      "size" :0, 
      "aggs":{
        "price_of_cardi": {
          "cardinality":{ "field": "price" }
        }
      }
    }
    
    #(6)terms:分组
    GET /lib5/items/_search
    { 
      "size":0,
      "aggs":{
        "price_group_by":{
          "terms":{ "field": "price" }
        }
      }
    }
    
    #对那些有唱歌兴趣的用户按年龄分组
    GET /lib3/user/_search 
    { 
      "query":{
        "match":{"interests": "changge" }
      }, 
      "size":0, 
      "aggs":{ 
        "age_group_by":{
          "terms":{
            "field": "age", 
            "order":{"avg_of_age": "desc" }
          }, 
          "aggs":{
            "avg_of_age":{
              "avg":{ "field": "age"}
            }
          }
        }
      }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70]: /images/20230528/7b74bdfa0dcb4762abf49fac647279eb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 1]: /images/20230528/a36d19e8708144b598abb3e8917a442f.png