Elasticsearch聚合分析

桃扇骨 2023-01-15 02:16 88阅读 0赞

# 求Rockets队的平均年龄
    post nba/_search
    {
      "query": {
        "term": {
          "teamNameEn": {
            "value": "Rockets"
          }
        }
      },
      "aggs": {
        "avgAge": {
          "avg": {
            "field": "age"
          }
        }
      },
      "size": 0
    }
    
    #求出打球时间不为空的球员数量
    POST /nba/_search
    {
      "query": {
        "term": {
          "teamNameEn": {
            "value": "Rockets"
          }
        }
      },
      "aggs": {
        "countPlayerYear": {
          "value_count": {
            "field": "playYear"
          }
        }
      },
      "size": 0
    }
    
    # 求出Rockets球员的数量
    POST nba/_count
    {
      "query": {
        "term": {
          "teamNameEn": {
            "value": "Rockets"
          }
        }
      }
    }
    
    # 求按age去重后的文档数量
    post nba/_search
    {
      "query":{
        "term": {
          "teamNameEn": {
            "value": "Rockets"
          }
        }
      },
      "size":0,
      "aggs":{
        "aggCard":{
          "cardinality": {
            "field": "age"
          }
        }
      }
    }
    
    # 按age进行统计分析
    post nba/_search
    {
      "query": {
        "term": {
          "teamNameEn": {
            "value": "Rockets"
          }
        }
      },
      "aggs": {
        "statsAge": {
          "stats": {
            "field": "age"
          }
        }
      },
      "size": 0
    }
    
    # Rockets队根据年龄分组，取3个分组
    post nba/_search
    {
      "query": {
        "term": {
          "teamNameEn": {
            "value": "Rockets"
          }
        }
      },
      "aggs": {
        "aggsAge": {
          "terms": {
            "field": "age",
            "size": 3
          }
        }
      },
      "size": 0
    }
    
    
    # Rockets队根据年龄分组，按age倒序排列取前3个分组
    post nba/_search
    {
      "query": {
        "term": {
          "teamNameEn": {
            "value": "Rockets"
          }
        }
      },
      "aggs": {
        "aggsAge": {
          "terms": {
            "field": "age",
            "size": 3,
            "order":{
              "_key":"desc"
            }
          }
        }
      },
      "size": 0
    }
    
    # Rockets队根据年龄分组，按文档数倒序排列取前3个分组
    post nba/_search
    {
      "query": {
        "term": {
          "teamNameEn": {
            "value": "Rockets"
          }
        }
      },
      "aggs": {
        "aggsAge": {
          "terms": {
            "field": "age",
            "size": 3,
            "order":{
              "_count":"desc"
            }
          }
        }
      },
      "size": 0
    }
    
    #按球队进行分组，按每组中的平均年龄倒序排列
    post nba/_search
    {
      "aggs": {
        "aggsTeamName": {
          "terms": {
            "field": "teamNameEn",
            "size": 30,
            "order": {
              "avgAge": "desc"
            }
          },
          "aggs": {
            "avgAge": {
              "avg": {
                "field": "age"
              }
            }
          }
        }
      },
      "size": 0
    }
    
    # 对分组进行筛选Lakers、Rockets队
    post nba/_search
    {
      "aggs": {
        "aggsTeamName": {
          "terms": {
            "field": "teamNameEn",
            "include": [
              "Lakers",
              "Rockets",
              "Warriors"
            ],
            "exclude": [
              "Warriors"
            ],
            "size": 30,
            "order": {
              "avgAge": "desc"
            }
          },
          "aggs": {
            "avgAge": {
              "avg": {
                "field": "age"
              }
            }
          }
        }
      },
      "size": 0
    }
    
    # 对分组进行筛选Lakers、Rockets队
    post nba/_search
    {
      "aggs": {
        "aggsTeamName": {
          "terms": {
            "field": "teamNameEn",
            "include": "Lakers|Ro.*|Warriors.*",
            "exclude": "Warriors",
            "size": 30,
            "order": {
              "avgAge": "desc"
            }
          },
          "aggs": {
            "avgAge": {
              "avg": {
                "field": "age"
              }
            }
          }
        }
      },
      "size": 0
    }
    
    # 按年龄段进行分组
    post nba/_search
    {
      "aggs": {
        "ageRange": {
          "range": {
            "field": "age",
            "ranges": [
              {
                "to": 20
              },
              {
                "from": 20,
                "to": 35
              },
              {
                "from": 35
              }
            ]
          }
        }
      },
      "size": 0
    }
    
    # 按年龄段进行分组对key取别名
    post nba/_search
    {
      "aggs": {
        "ageRange": {
          "range": {
            "field": "age",
            "ranges": [
              {
                "to": 20,
                "key": "A"
              },
              {
                "from": 20,
                "to": 35,
                "key": "B"
              },
              {
                "from": 35,
                "key": "C"
              }
            ]
          }
        }
      },
      "size": 0
    }
    
    # 按球员的出生年月进行分组
    post nba/_search
    {
      "aggs": {
        "birthDayRange": {
          "date_range": {
            "field": "birthDay",
            "format": "MM-yyy",
            "ranges": [
              {
                "to": "01-1989"
              },
              {
                "from": "01-1989",
                "to": "01-1999"
              },
              {
                "from": "01-1999",
                "to": "01-2009"
              },
              {
                "from": "01-2009"
              }
            ]
          }
        }
      },
      "size": 0
    }
    
    # 按年对出生日期生成时间柱状图
    POST /nba/_search
    {
     "aggs": {
     "birthday_aggs": {
     "date_histogram": {
     "field": "birthDay",
     "format": "yyyy",
     "interval": "year"
     }
     }
     },
     "size": 0
    }