{"id":1105,"date":"2023-03-12T11:42:42","date_gmt":"2023-03-12T03:42:42","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=1105"},"modified":"2023-04-29T11:24:36","modified_gmt":"2023-04-29T03:24:36","slug":"elasticsearch-7-search-aggregation-query-indicator-aggregation","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/03\/12\/elasticsearch-7-search-aggregation-query-indicator-aggregation\/","title":{"rendered":"ElasticSearch 7 \u641c\u7d22\uff0810\uff09\u805a\u5408\u67e5\u8be2\u6307\u6807\u805a\u5408"},"content":{"rendered":"

ES\u805a\u5408\u5206\u6790\u662f\u4ec0\u4e48<\/p>\n

    \n
  1. \u805a\u5408\u5206\u6790\u662f\u6570\u636e\u5e93\u4e2d\u91cd\u8981\u7684\u529f\u80fd\u7279\u6027\uff0c\u5b8c\u6210\u5bf9\u4e00\u4e2a\u67e5\u8be2\u7684\u6570\u636e\u96c6\u4e2d\u6570\u636e\u7684\u805a\u5408\u8ba1\u7b97\uff0c\u5982\uff1a\u627e\u51fa\u67d0\u5b57\u6bb5\uff08\u6216\u8ba1\u7b97\u8868\u8fbe\u5f0f\u7684\u7ed3\u679c\uff09\u7684\u6700\u5927\u503c\u3001\u6700\u5c0f\u503c\uff0c\u8ba1\u7b97\u548c\u3001\u5e73\u5747\u503c\u7b49\u3002ES\u4f5c\u4e3a\u641c\u7d22\u5f15\u64ce\u517c\u6570\u636e\u5e93\uff0c\u540c\u6837\u63d0\u4f9b\u4e86\u5f3a\u2f24\u7684\u805a\u5408\u5206\u6790\u80fd\u529b<\/li>\n
  2. \u5bf9\u4e00\u4e2a\u6570\u636e\u96c6\u6c42\u6700\u5927\u3001\u6700\u5c0f\u3001\u548c\u3001\u5e73\u5747\u503c\u7b49\u6307\u6807\u7684\u805a\u5408\uff0c\u5728ES\u4e2d\u79f0\u4e3a\u6307\u6807\u805a\u5408<\/strong> <\/li>\n
  3. \u800c\u5173\u7cfb\u578b\u6570\u636e\u5e93\u4e2d\u9664\u4e86\u6709\u805a\u5408\u51fd\u6570\u5916\uff0c\u8fd8\u53ef\u4ee5\u5bf9\u67e5\u8be2\u51fa\u7684\u6570\u636e\u884c\u5206\u7ec4group by<\/code>\uff0c\u518d\u5728\u7ec4\u4e0a\u8fdb\u884c\u6307\u6807\u805a\u5408\u3002\u5728ES\u4e2d\u79f0\u4e3a\u6876\u805a\u5408<\/strong><\/li>\n<\/ol>\n

    <\/p>\n

    max min sum avg \u6307\u6807\u805a\u5408\u67e5\u8be2 GET\/POST<\/h3>\n
      \n
    • \u8bf7\u6c42<\/li>\n<\/ul>\n
      localhost:9200\/nba\/_search<\/code><\/pre>\n
        \n
      • \u8bf7\u6c42\u4f53<\/li>\n<\/ul>\n
        {\n  \/\/ \u8bed\u4e49: \u67e5\u8be2\u706b\u7bad\u961f\u7403\u5458\u5e73\u5747\u5e74\u9f84\n  "query": {\n    "term": {\n      "teamNameEn": "Rockets"\n    }\n  },\n  "aggs": { \/\/ aggs \u4ee3\u8868\u4f7f\u7528\u805a\u5408\u51fd\u6570\n    "avgAge": { \/\/ avgAge\u662f\u81ea\u5b9a\u4e49\u7684\uff0c\u56e0\u4e3a\u662f\u67e5\u5e74\u5e74\u9f84\u5e73\u5747\u6240\u4ee5\u8d77\u540davgAge\n      "avg": { \/\/ avg \u5e73\u5747\n        "field": "age"\n      }\n    }\n  }, \n  "size": 0 \/\/ \u4e0d\u770b\u6570\u636e\u53ea\u770b\u6307\u6807\u805a\u5408\n}<\/code><\/pre>\n
          \n
        • \u54cd\u5e94<\/li>\n<\/ul>\n
          {\n  "took" : 1,\n  "timed_out" : false,\n  "_shards" : {\n    "total" : 1,\n    "successful" : 1,\n    "skipped" : 0,\n    "failed" : 0\n  },\n  "hits" : {\n    "total" : {\n      "value" : 21,\n      "relation" : "eq"\n    },\n    "max_score" : null,\n    "hits" : [ ]\n  },\n  "aggregations" : {\n    "avgAge" : {\n      "value" : 26.761904761904763 \/\/ \u5e73\u5747\u5e74\u9f84\n    }\n  }\n}<\/code><\/pre>\n
          value_count \u6307\u6807\u805a\u5408\u67e5\u8be2 GET\/POST<\/h3>\n
          \u7edf\u8ba1\u975e\u7a7a\u5b57\u6bb5\u7684\u6587\u6863\u6570<\/p>\n
            \n
          • \u8bf7\u6c42<\/li>\n<\/ul>\n
            localhost:9200\/nba\/_search<\/code><\/pre>\n
              \n
            • \u8bf7\u6c42\u4f53<\/li>\n<\/ul>\n
              {\n  \/\/ \u8bed\u4e49: \u67e5\u8be2\u706b\u7bad\u961f\u4e2d\u7403\u5458\u6253\u7403\u65f6\u95f4\u4e0d\u4e3a\u7a7a\u7684\u6570\u91cf\n  "query": {\n    "term": {\n      "teamNameEn": "Rockets"\n    }\n  },\n  "aggs": {\n    "countPlayerYear": {\n      "value_count": {\n        "field": "playYear"\n      }\n    }\n  }, \n  "size": 0\n}<\/code><\/pre>\n
                \n
              • \u54cd\u5e94<\/li>\n<\/ul>\n
                {\n  "took" : 4,\n  "timed_out" : false,\n  "_shards" : {\n    "total" : 1,\n    "successful" : 1,\n    "skipped" : 0,\n    "failed" : 0\n  },\n  "hits" : {\n    "total" : {\n      "value" : 21,\n      "relation" : "eq"\n    },\n    "max_score" : null,\n    "hits" : [ ]\n  },\n  "aggregations" : {\n    "countPlayerYear" : {\n      "value" : 21\n    }\n  }\n}<\/code><\/pre>\n
                _count \u6307\u6807\u805a\u5408\u67e5\u8be2\uff08\u4e25\u683c\u6765\u8bf4\u4e0d\u5c5e\u4e8e\u805a\u5408\uff09 GET\/POST<\/h3>\n
                \u67e5\u8be2\u706b\u7bad\u961f\u6709\u591a\u5c11\u6587\u6863\uff0c\u4e5f\u5c31\u662f\u6709\u591a\u5c11\u7403\u5458<\/p>\n
                  \n
                • \u8bf7\u6c42<\/li>\n<\/ul>\n
                  localhost:9200\/nba\/_count<\/code><\/pre>\n
                    \n
                  • \u8bf7\u6c42\u4f53<\/li>\n<\/ul>\n
                    {\n  "query": {\n    "term": {\n      "teamNameEn": "Rockets"\n    }\n  }\n}<\/code><\/pre>\n
                      \n
                    • \u54cd\u5e94<\/li>\n<\/ul>\n
                      {\n    "count": 21,\n    "_shards": {\n        "total": 1,\n        "successful": 1,\n        "skipped": 0,\n        "failed": 0\n    }\n}<\/code><\/pre>\n
                      cardinality \u6307\u6807\u805a\u5408\u67e5\u8be2 GET\/POST<\/h3>\n
                        \n
                      • \n
                        Cardinality \u503c\u53bb\u91cd\u8ba1\u7b97<\/p>\n<\/li>\n
                      • \n
                        \u8bf7\u6c42<\/p>\n<\/li>\n<\/ul>\n
                        localhost:9200\/nba\/_search<\/code><\/pre>\n
                          \n
                        • \u8bf7\u6c42\u4f53<\/li>\n<\/ul>\n
                          {\n  \/\/ \u8bed\u4e49: \u67e5\u8be2\u706b\u7bad\u961f\u4e2d\u5e74\u9f84\u4e0d\u540c\u7684\u6570\u91cf\n  "query": {\n    "term": {\n      "teamNameEn": "Rockets"\n    }\n  },\n  "aggs": {\n    "countAge": { \/\/ \u81ea\u5b9a\u4e49\u540d\u5b57\n      "cardinality": { \/\/ \u53bb\u6389\u76f8\u540c\u7684\u53ea\u4fdd\u7559\u4e00\u4e2a\u503c\n        "field": "age"\n      }\n    }\n  },\n  "size": 0\n}<\/code><\/pre>\n
                            \n
                          • \u54cd\u5e94<\/li>\n<\/ul>\n
                            {\n  "took" : 1,\n  "timed_out" : false,\n  "_shards" : {\n    "total" : 1,\n    "successful" : 1,\n    "skipped" : 0,\n    "failed" : 0\n  },\n  "hits" : {\n    "total" : {\n      "value" : 21,\n      "relation" : "eq"\n    },\n    "max_score" : null,\n    "hits" : [ ]\n  },\n  "aggregations" : {\n    "countAge" : {\n      "value" : 13\n    }\n  }\n}<\/code><\/pre>\n
                            stats 5\u79cd\u6307\u6807\u805a\u5408\u67e5\u8be2 GET\/POST<\/h3>\n
                            stats<\/code>\u7edf\u8ba1count max min avg sum<\/code>5\u4e2a\u503c<\/p>\n
                              \n
                            • \u8bf7\u6c42<\/li>\n<\/ul>\n
                              localhost:9200\/nba\/_search<\/code><\/pre>\n
                                \n
                              • \u8bf7\u6c42\u4f53<\/li>\n<\/ul>\n
                                {\n  \/\/ \u8bed\u4e49: \u67e5\u8be2\u706b\u7bad\u7403\u5458\u7684\u5e74\u9f84status\n  "query": {\n    "term": {\n      "teamNameEn": "Rockets"\n    }\n  },\n  "aggs": {\n    "status": {\n      "stats": {\n        "field": "age"\n      }\n    }\n  },\n  "size": 0\n}<\/code><\/pre>\n
                                  \n
                                • \u54cd\u5e94<\/li>\n<\/ul>\n
                                  {\n  "took" : 1,\n  "timed_out" : false,\n  "_shards" : {\n    "total" : 1,\n    "successful" : 1,\n    "skipped" : 0,\n    "failed" : 0\n  },\n  "hits" : {\n    "total" : {\n      "value" : 21,\n      "relation" : "eq"\n    },\n    "max_score" : null,\n    "hits" : [ ]\n  },\n  "aggregations" : {\n    "status" : {\n      "count" : 21,\n      "min" : 21.0,\n      "max" : 37.0,\n      "avg" : 26.761904761904763,\n      "sum" : 562.0\n    }\n  }\n}\n<\/code><\/pre>\n
                                  extended status \u79cd\u6307\u6807\u805a\u5408\u67e5\u8be2 GET\/POST<\/h3>\n
                                  Extended stats<\/code>\u6bd4stats<\/code>\u591a4\u4e2a\u7edf\u8ba1\u7ed3\u679c\uff1a\u5e73\u65b9\u548c\u3001\u65b9\u5dee\u3001\u6807\u51c6\u5dee\u3001\u5e73\u5747\u503c\u52a0\u51cf\u4e24\u4e2a\u6807\u51c6\u5dee\u7684\u533a\u95f4<\/p>\n
                                    \n
                                  • \u8bf7\u6c42<\/li>\n<\/ul>\n
                                    localhost:9200\/nba\/_search<\/code><\/pre>\n
                                      \n
                                    • \u8bf7\u6c42\u4f53<\/li>\n<\/ul>\n
                                      {\n  \/\/ \u67e5\u51fa\u706b\u7bad\u961f\u7403\u5458\u7684\uf98e\u9f84Extend stats\n  "query": {\n    "term": {\n      "teamNameEn": "Rockets"\n    }\n  },\n  "aggs": {\n    "extendedStatsAge": {\n      "extended_stats": {\n        "field": "age"\n      }\n    }\n  },\n  "size": 0\n}<\/code><\/pre>\n
                                        \n
                                      • \u54cd\u5e94<\/li>\n<\/ul>\n
                                        {\n  "took" : 0,\n  "timed_out" : false,\n  "_shards" : {\n    "total" : 1,\n    "successful" : 1,\n    "skipped" : 0,\n    "failed" : 0\n  },\n  "hits" : {\n    "total" : {\n      "value" : 21,\n      "relation" : "eq"\n    },\n    "max_score" : null,\n    "hits" : [ ]\n  },\n  "aggregations" : {\n    "extendedStatsAge" : {\n      "count" : 21,\n      "min" : 21.0,\n      "max" : 37.0,\n      "avg" : 26.761904761904763,\n      "sum" : 562.0,\n      "sum_of_squares" : 15534.0,\n      "variance" : 23.5147392290249,\n      "std_deviation" : 4.84919985451465,\n      "std_deviation_bounds" : {\n        "upper" : 36.46030447093406,\n        "lower" : 17.063505052875463\n      }\n    }\n  }\n}<\/code><\/pre>\n
                                        percentiles \u79cd\u6307\u6807\u805a\u5408\u67e5\u8be2 GET\/POST<\/h3>\n
                                        Percentiles<\/code>\u5360\u6bd4\u767e\u5206\u4f4d\u5bf9\u5e94\u7684\u503c\u7edf\u8ba1\uff0c\u9ed8\u8ba4\u8fd4\u56de[ 1, 5, 25, 50, 75, 95, 99 ]<\/code>\u5206\u4f4d\u4e0a\u7684\u503c<\/p>\n
                                          \n
                                        • \u8bf7\u6c42<\/li>\n<\/ul>\n
                                          localhost:9200\/nba\/_search<\/code><\/pre>\n
                                            \n
                                          • \u8bf7\u6c42\u4f53<\/li>\n<\/ul>\n
                                            {\n    \/\/ \u8bed\u4e49: \u67e5\u51fa\u706b\u7bad\u7684\u7403\u5458\u7684\uf98e\u9f84\u5360\u6bd4\n  "query": {\n    "term": {\n      "teamNameEn": "Rockets"\n    }\n  },\n  "aggs": {\n    "percentilesAge": {\n      "percentiles": {\n        "field": "age",\n        \/\/ \u8fd9\u91cc\u53ef\u4ee5\u6307\u5b9a\uff0c\u4e0d\u4f7f\u7528\u9ed8\u8ba4\n        \/\/ "percents": [\n        \/\/   25,\n        \/\/   50,\n        \/\/   75\n        \/\/ ]\n      }\n    }\n  },\n  "size": 0\n}<\/code><\/pre>\n
                                              \n
                                            • \u54cd\u5e94<\/li>\n<\/ul>\n
                                              {\n  "took" : 1,\n  "timed_out" : false,\n  "_shards" : {\n    "total" : 1,\n    "successful" : 1,\n    "skipped" : 0,\n    "failed" : 0\n  },\n  "hits" : {\n    "total" : {\n      "value" : 21,\n      "relation" : "eq"\n    },\n    "max_score" : null,\n    "hits" : [ ]\n  },\n  "aggregations" : {\n    "percentilesAge" : {\n      "values" : {\n        "1.0" : 21.0,\n        "5.0" : 21.0,\n        "25.0" : 22.75, \/\/ \u5c0f\u4e8e22.75\u5c81\u7684 \u536025%\n        "50.0" : 25.0,\n        "75.0" : 30.25,\/\/ \u5c0f\u4e8e30.25\u5c81\u7684 \u536075%\n        "95.0" : 35.349999999999994,\n        "99.0" : 37.0\n      }\n    }\n  }\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
                                              ES\u805a\u5408\u5206\u6790\u662f\u4ec0\u4e48 \u805a\u5408\u5206\u6790\u662f\u6570\u636e\u5e93\u4e2d\u91cd\u8981\u7684\u529f\u80fd\u7279\u6027\uff0c\u5b8c\u6210\u5bf9\u4e00\u4e2a\u67e5\u8be2\u7684\u6570\u636e\u96c6\u4e2d\u6570\u636e\u7684\u805a\u5408\u8ba1\u7b97\uff0c\u5982\uff1a\u627e\u51fa\u67d0\u5b57\u6bb5\uff08 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[301],"tags":[],"class_list":["post-1105","post","type-post","status-publish","format-standard","hentry","category-elasticsearch"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1105"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1105\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}