es 排序 聚合统计_es 聚合数据 聚合统计

\" : { "],[20,"\n","24:\"QKVd\"|36:177"],[20," \"\" : { "],[20,"\n","24:\"qq70\"|36:177"],[20,""],[20,"\n","24:\"EZTv\"|36:177"],[20," }"],[20,"\n","24:\"Ocmo\"|36:177"],[20," [,\"meta\" : { [] } ]? "],[20,"\n","24:\"pNIr\"|36:177"],[20," [,\"aggregations\" : { []+ } ]? "],[20,"\n","24:\"UFZF\"|36:177"],[20," }"],[20,"\n","24:\"yMjg\"|36:177"],[20," [,\"\" : { ... } ]*"],[20,"\n","24:\"cQiu\"|36:177"],[20,"}"],[20,"\n","24:\"cHkq\"|36:177"],[20,"\n","24:\"hvbC\""],[20," 说明：","0:\"%23ff0000\"|31:2|8:1"],[20,"\n","24:\"UACt\""],[20,"aggregations 也可简写为 aggs","0:\"%23ff0000\"|31:2|8:1"],[20,"\n","24:\"3QtL\""],[20," 3. 聚合分析的值来源","27:\"12\"|31:2"],[20,"\n","24:\"d8C9\"|32:3|linespacing:\"150\""],[20,"聚合计算的值可以取","31:2"],[20,"字段的值","31:2|8:1"],[20,"，也可是","31:2"],[20,"脚本计算的结果","31:2|8:1"],[20,"。","31:2"],[20,"\n","24:\"HZzc\""],[20,"二、指标聚合","27:\"16\"|31:2"],[20,"\n","24:\"W2mW\"|32:2|linespacing:\"150\""],[20,"1. max min sum avg","27:\"12\"|31:2"],[20,"\n","24:\"qK94\"|32:3|linespacing:\"150\""],[20,"示例1：查询所有客户中余额的最大值","31:2"],[20,"\n","24:\"g3SD\""],[20,"\n","24:\"bryQ\""],[20,"POST /bank/_search?"],[20,"\n","24:\"u1zI\"|36:177"],[20,"{"],[20,"\n","24:\"SxRe\"|36:177"],[20," \"size\": 0, "],[20,"\n","24:\"yHUS\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"ByGz\"|36:177"],[20," \"masssbalance\": {"],[20,"\n","24:\"nE4z\"|36:177"],[20," \"max\": {"],[20,"\n","24:\"9RMF\"|36:177"],[20," \"field\": \"balance\""],[20,"\n","24:\"Ikd2\"|36:177"],[20," }"],[20,"\n","24:\"VShd\"|36:177"],[20," }"],[20,"\n","24:\"1RUo\"|36:177"],[20," }"],[20,"\n","24:\"hqWh\"|36:177"],[20,"}"],[20,"\n","24:\"nY9g\"|36:177"],[20," 结果1：","31:2"],[20,"\n","24:\"S4sn\""],[20,"\n","24:\"pjIf\""],[20,"{"],[20,"\n","24:\"hGMJ\"|36:177"],[20," \"took\": 2080,"],[20,"\n","24:\"2iqk\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"3g2G\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"1dap\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"kcz5\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"S14v\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"g3D2\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"knn4\"|36:177"],[20," },"],[20,"\n","24:\"124i\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"thTk\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"C3xW\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"r8Lc\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"7Izi\"|36:177"],[20," },"],[20,"\n","24:\"UFNi\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"xrlX\"|36:177"],[20," \"masssbalance\": {"],[20,"\n","24:\"4PBX\"|36:177"],[20," \"value\": 49989"],[20,"\n","24:\"m9Uj\"|36:177"],[20," }"],[20,"\n","24:\"Qal4\"|36:177"],[20," }"],[20,"\n","24:\"ttim\"|36:177"],[20,"}"],[20,"\n","24:\"3vTH\"|36:177"],[20,"示例2：查询年龄为24岁的客户中的余额最大值","31:2"],[20,"\n","24:\"X9HC\""],[20,"\n","24:\"qqbp\""],[20,"POST /bank/_search?"],[20,"\n","24:\"0yhK\"|36:177"],[20,"{"],[20,"\n","24:\"1Nnb\"|36:177"],[20," \"size\": 2, "],[20,"\n","24:\"L7z1\"|36:177"],[20," \"query\": {"],[20,"\n","24:\"OveL\"|36:177"],[20," \"match\": {"],[20,"\n","24:\"X0CX\"|36:177"],[20," \"age\": 24"],[20,"\n","24:\"o9Yh\"|36:177"],[20," }"],[20,"\n","24:\"z6wY\"|36:177"],[20," },"],[20,"\n","24:\"TysR\"|36:177"],[20," \"sort\": ["],[20,"\n","24:\"vLQs\"|36:177"],[20," {"],[20,"\n","24:\"zUl9\"|36:177"],[20," \"balance\": {"],[20,"\n","24:\"jzt6\"|36:177"],[20," \"order\": \"desc\""],[20,"\n","24:\"GzrK\"|36:177"],[20," }"],[20,"\n","24:\"sKbn\"|36:177"],[20," }"],[20,"\n","24:\"hobF\"|36:177"],[20," ],"],[20,"\n","24:\"PZsN\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"Kdar\"|36:177"],[20," \"max_balance\": {"],[20,"\n","24:\"i4oC\"|36:177"],[20," \"max\": {"],[20,"\n","24:\"Xj8s\"|36:177"],[20," \"field\": \"balance\""],[20,"\n","24:\"EaZA\"|36:177"],[20," }"],[20,"\n","24:\"nPjr\"|36:177"],[20," }"],[20,"\n","24:\"hGSq\"|36:177"],[20," }"],[20,"\n","24:\"tq7Y\"|36:177"],[20,"}"],[20,"\n","24:\"kFt0\"|36:177"],[20,"\n","24:\"xg75\""],[20," 结果2：","31:2"],[20,"\n","24:\"V4JY\""],[20,"\n","24:\"zFSI\""],[20,"{"],[20,"\n","24:\"8nG4\"|36:177"],[20," \"took\": 5,"],[20,"\n","24:\"Tci9\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"2Cn8\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"K6UP\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"w3IF\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"fqvP\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"8kXv\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"zWbo\"|36:177"],[20," },"],[20,"\n","24:\"HaRU\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"rW8o\"|36:177"],[20," \"total\": 42,"],[20,"\n","24:\"qhaq\"|36:177"],[20," \"max_score\": null,"],[20,"\n","24:\"l5MJ\"|36:177"],[20," \"hits\": ["],[20,"\n","24:\"OPDl\"|36:177"],[20," {"],[20,"\n","24:\"cRYF\"|36:177"],[20," \"_index\": \"bank\","],[20,"\n","24:\"7SY4\"|36:177"],[20," \"_type\": \"_doc\","],[20,"\n","24:\"fCzs\"|36:177"],[20," \"_id\": \"697\","],[20,"\n","24:\"G5IW\"|36:177"],[20," \"_score\": null,"],[20,"\n","24:\"T3rI\"|36:177"],[20," \"_source\": {"],[20,"\n","24:\"XcfJ\"|36:177"],[20," \"account_number\": 697,"],[20,"\n","24:\"1WbQ\"|36:177"],[20," \"balance\": 48745,"],[20,"\n","24:\"bJP3\"|36:177"],[20," \"firstname\": \"Mallory\","],[20,"\n","24:\"MnYe\"|36:177"],[20," \"lastname\": \"Emerson\","],[20,"\n","24:\"schf\"|36:177"],[20," \"age\": 24,"],[20,"\n","24:\"nXJ4\"|36:177"],[20," \"gender\": \"F\","],[20,"\n","24:\"9A0k\"|36:177"],[20," \"address\": \"318 Dunne Court\","],[20,"\n","24:\"U6NC\"|36:177"],[20," \"employer\": \"Exoplode\","],[20,"\n","24:\"Lszf\"|36:177"],[20," \"email\": \"malloryemerson@exoplode.com\","],[20,"\n","24:\"xf82\"|36:177"],[20," \"city\": \"Montura\","],[20,"\n","24:\"ppCV\"|36:177"],[20," \"state\": \"LA\""],[20,"\n","24:\"fvSp\"|36:177"],[20," },"],[20,"\n","24:\"tAAk\"|36:177"],[20," \"sort\": ["],[20,"\n","24:\"IX1a\"|36:177"],[20," 48745"],[20,"\n","24:\"8DSh\"|36:177"],[20," ]"],[20,"\n","24:\"YkbH\"|36:177"],[20," },"],[20,"\n","24:\"mMJc\"|36:177"],[20," {"],[20,"\n","24:\"DYEa\"|36:177"],[20," \"_index\": \"bank\","],[20,"\n","24:\"isvh\"|36:177"],[20," \"_type\": \"_doc\","],[20,"\n","24:\"hBsb\"|36:177"],[20," \"_id\": \"917\","],[20,"\n","24:\"dcRz\"|36:177"],[20," \"_score\": null,"],[20,"\n","24:\"ezFw\"|36:177"],[20," \"_source\": {"],[20,"\n","24:\"Nwgg\"|36:177"],[20," \"account_number\": 917,"],[20,"\n","24:\"8sqM\"|36:177"],[20," \"balance\": 47782,"],[20,"\n","24:\"pXb5\"|36:177"],[20," \"firstname\": \"Parks\","],[20,"\n","24:\"AOXU\"|36:177"],[20," \"lastname\": \"Hurst\","],[20,"\n","24:\"30Ib\"|36:177"],[20," \"age\": 24,"],[20,"\n","24:\"fYCK\"|36:177"],[20," \"gender\": \"M\","],[20,"\n","24:\"DnZk\"|36:177"],[20," \"address\": \"933 Cozine Avenue\","],[20,"\n","24:\"qTZn\"|36:177"],[20," \"employer\": \"Pyramis\","],[20,"\n","24:\"8Uzy\"|36:177"],[20," \"email\": \"parkshurst@pyramis.com\","],[20,"\n","24:\"7diB\"|36:177"],[20," \"city\": \"Lindcove\","],[20,"\n","24:\"FYO8\"|36:177"],[20," \"state\": \"GA\""],[20,"\n","24:\"4edL\"|36:177"],[20," },"],[20,"\n","24:\"gRhs\"|36:177"],[20," \"sort\": ["],[20,"\n","24:\"nsNR\"|36:177"],[20," 47782"],[20,"\n","24:\"CRkP\"|36:177"],[20," ]"],[20,"\n","24:\"3lEA\"|36:177"],[20," }"],[20,"\n","24:\"Qbfw\"|36:177"],[20," ]"],[20,"\n","24:\"qUZT\"|36:177"],[20," },"],[20,"\n","24:\"HdKL\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"ayql\"|36:177"],[20," \"max_balance\": {"],[20,"\n","24:\"svoW\"|36:177"],[20," \"value\": 48745"],[20,"\n","24:\"FzLL\"|36:177"],[20," }"],[20,"\n","24:\"Rgeb\"|36:177"],[20," }"],[20,"\n","24:\"ulD3\"|36:177"],[20,"}"],[20,"\n","24:\"alH5\"|36:177"],[20,"\n","24:\"nKlA\""],[20," 示例3：值来源于脚本，查询所有客户的平均年龄是多少，并对平均年龄加10","31:2"],[20,"\n","24:\"4syh\""],[20,"\n","24:\"eAof\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"j7Zo\"|36:177"],[20,"{"],[20,"\n","24:\"cWkO\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"i1Jg\"|36:177"],[20," \"avg_age\": {"],[20,"\n","24:\"iEjs\"|36:177"],[20," \"avg\": {"],[20,"\n","24:\"ZpF5\"|36:177"],[20," \"script\": {"],[20,"\n","24:\"VX27\"|36:177"],[20," \"source\": \"doc.age.value\""],[20,"\n","24:\"S8sf\"|36:177"],[20," }"],[20,"\n","24:\"DhNc\"|36:177"],[20," }"],[20,"\n","24:\"5wf2\"|36:177"],[20," },"],[20,"\n","24:\"mslj\"|36:177"],[20," \"avg_age10\": {"],[20,"\n","24:\"pVBM\"|36:177"],[20," \"avg\": {"],[20,"\n","24:\"8Muu\"|36:177"],[20," \"script\": {"],[20,"\n","24:\"e0sx\"|36:177"],[20," \"source\": \"doc.age.value + 10\""],[20,"\n","24:\"eXJo\"|36:177"],[20," }"],[20,"\n","24:\"wgr7\"|36:177"],[20," }"],[20,"\n","24:\"VGyS\"|36:177"],[20," }"],[20,"\n","24:\"Wx3Z\"|36:177"],[20," }"],[20,"\n","24:\"a3X4\"|36:177"],[20,"}"],[20,"\n","24:\"abAz\"|36:177"],[20,"\n","24:\"S02c\""],[20," 结果3：","31:2"],[20,"\n","24:\"WBh5\""],[20,"\n","24:\"7iMh\""],[20,"{"],[20,"\n","24:\"TSR2\"|36:177"],[20," \"took\": 86,"],[20,"\n","24:\"0NFx\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"RJNp\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"nwz4\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"LNzs\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"hRk1\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"w7iE\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"GEUY\"|36:177"],[20," },"],[20,"\n","24:\"dl7l\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"kdok\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"k6iB\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"lMoc\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"EwRJ\"|36:177"],[20," },"],[20,"\n","24:\"C9ZE\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"NJ9x\"|36:177"],[20," \"avg_age\": {"],[20,"\n","24:\"yHoX\"|36:177"],[20," \"value\": 30.171"],[20,"\n","24:\"X3y4\"|36:177"],[20," },"],[20,"\n","24:\"j1gU\"|36:177"],[20," \"avg_age10\": {"],[20,"\n","24:\"aKmh\"|36:177"],[20," \"value\": 40.171"],[20,"\n","24:\"QxwM\"|36:177"],[20," }"],[20,"\n","24:\"tlKh\"|36:177"],[20," }"],[20,"\n","24:\"3H3E\"|36:177"],[20,"}"],[20,"\n","24:\"y96W\"|36:177"],[20,"\n","24:\"x7Xo\""],[20," 示例4：指定field，在脚本中用_value 取字段的值","31:2"],[20,"\n","24:\"73qJ\""],[20,"\n","24:\"v1h2\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"YdKj\"|36:177"],[20,"{"],[20,"\n","24:\"yaSt\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"jgUO\"|36:177"],[20," \"sum_balance\": {"],[20,"\n","24:\"j4mW\"|36:177"],[20," \"sum\": {"],[20,"\n","24:\"kHlr\"|36:177"],[20," \"field\": \"balance\","],[20,"\n","24:\"jCYW\"|36:177"],[20," \"script\": {"],[20,"\n","24:\"n9tm\"|36:177"],[20," \"source\": \"_value * 1.03\""],[20,"\n","24:\"KUtE\"|36:177"],[20," }"],[20,"\n","24:\"YMsQ\"|36:177"],[20," }"],[20,"\n","24:\"wFBp\"|36:177"],[20," }"],[20,"\n","24:\"nYgC\"|36:177"],[20," }"],[20,"\n","24:\"cyFL\"|36:177"],[20,"}"],[20,"\n","24:\"OIpc\"|36:177"],[20,"\n","24:\"iXEw\""],[20," 结果4：","31:2"],[20,"\n","24:\"rORz\""],[20,"\n","24:\"u45A\""],[20,"{"],[20,"\n","24:\"AvAD\"|36:177"],[20," \"took\": 165,"],[20,"\n","24:\"A2wY\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"kqBx\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"bvew\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"RylA\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"HIIP\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"wUb7\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"LK6m\"|36:177"],[20," },"],[20,"\n","24:\"7TMf\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"s1Cd\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"kHPI\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"DppR\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"qyrC\"|36:177"],[20," },"],[20,"\n","24:\"dGqR\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"ock4\"|36:177"],[20," \"sum_balance\": {"],[20,"\n","24:\"2O0E\"|36:177"],[20," \"value\": 26486282.11"],[20,"\n","24:\"aIGg\"|36:177"],[20," }"],[20,"\n","24:\"ZMnV\"|36:177"],[20," }"],[20,"\n","24:\"0nL2\"|36:177"],[20,"}"],[20,"\n","24:\"QRRp\"|36:177"],[20,"\n","24:\"tQTQ\""],[20," 示例5：为没有值字段指定值。如未指定，缺失该字段值的文档将被忽略。","31:2"],[20,"\n","24:\"UY6y\""],[20,"\n","24:\"QUVA\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"zeOl\"|36:177"],[20,"{"],[20,"\n","24:\"kbyj\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"sMDU\"|36:177"],[20," \"avg_age\": {"],[20,"\n","24:\"oNJO\"|36:177"],[20," \"avg\": {"],[20,"\n","24:\"K7Dc\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"ycuQ\"|36:177"],[20," \"missing\": 18"],[20,"\n","24:\"SaTg\"|36:177"],[20," }"],[20,"\n","24:\"jXQd\"|36:177"],[20," }"],[20,"\n","24:\"hPue\"|36:177"],[20," }"],[20,"\n","24:\"1asV\"|36:177"],[20,"}"],[20,"\n","24:\"b2eR\"|36:177"],[20,"\n","24:\"uH85\""],[20," 2. 文档计数 count","27:\"12\"|31:2"],[20,"\n","24:\"6TPs\"|32:3|linespacing:\"150\""],[20," 示例1：统计银行索引bank下年龄为24的文档数量","31:2"],[20,"\n","24:\"exlZ\""],[20,"\n","24:\"mAsn\""],[20,"POST /bank/_doc/_count"],[20,"\n","24:\"c9QS\"|36:177"],[20,"{"],[20,"\n","24:\"oojN\"|36:177"],[20," \"query\": {"],[20,"\n","24:\"r0rE\"|36:177"],[20," \"match\": {"],[20,"\n","24:\"lwmS\"|36:177"],[20," \"age\" : 24"],[20,"\n","24:\"ShLY\"|36:177"],[20," }"],[20,"\n","24:\"qQlR\"|36:177"],[20," }"],[20,"\n","24:\"ilcS\"|36:177"],[20,"}"],[20,"\n","24:\"R06A\"|36:177"],[20,"\n","24:\"r31q\""],[20," 结果1：","31:2"],[20,"\n","24:\"O6lt\""],[20,"{"],[20,"\n","24:\"gmDW\"|36:177"],[20," \"count\": 42,"],[20,"\n","24:\"zOPO\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"g9BI\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"ACks\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"c70W\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"Gtm7\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"vwh6\"|36:177"],[20," }"],[20,"\n","24:\"fWhV\"|36:177"],[20,"}"],[20,"\n","24:\"LYGI\"|36:177"],[20," 3. Value count 统计某字段有值的文档数","27:\"12\"|31:2"],[20,"\n","24:\"lCsb\"|32:3|linespacing:\"150\""],[20,"示例1：","31:2"],[20,"\n","24:\"kGan\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"PXOL\"|36:177"],[20,"{"],[20,"\n","24:\"6uwC\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"T8MG\"|36:177"],[20," \"age_count\": {"],[20,"\n","24:\"61Gy\"|36:177"],[20," \"value_count\": {"],[20,"\n","24:\"h1pQ\"|36:177"],[20," \"field\": \"age\""],[20,"\n","24:\"WQ2G\"|36:177"],[20," }"],[20,"\n","24:\"Mh89\"|36:177"],[20," }"],[20,"\n","24:\"Omfx\"|36:177"],[20," }"],[20,"\n","24:\"1dTP\"|36:177"],[20,"}"],[20,"\n","24:\"EICh\"|36:177"],[20,"\n","24:\"kaZr\""],[20," 结果1：","31:2"],[20,"\n","24:\"z5La\""],[20,"{"],[20,"\n","24:\"Ug6w\"|36:177"],[20," \"took\": 2022,"],[20,"\n","24:\"Pgmh\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"U4tj\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"n0fZ\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"t8GE\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"W1Bi\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"swgP\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"S3Yk\"|36:177"],[20," },"],[20,"\n","24:\"yPfP\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"JcwW\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"6lYx\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"yNuj\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"GgSp\"|36:177"],[20," },"],[20,"\n","24:\"njJK\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"hysv\"|36:177"],[20," \"age_count\": {"],[20,"\n","24:\"AS07\"|36:177"],[20," \"value\": 1000"],[20,"\n","24:\"fJpv\"|36:177"],[20," }"],[20,"\n","24:\"L3e4\"|36:177"],[20," }"],[20,"\n","24:\"wJT2\"|36:177"],[20,"}"],[20,"\n","24:\"Laa3\"|36:177"],[20," 4. cardinality  值去重计数","27:\"12\"|31:2"],[20,"\n","24:\"3n7X\"|32:3|linespacing:\"150\""],[20,"示例1","31:2"],[20,"\n","24:\"WYzn\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"rFmZ\"|36:177"],[20,"{"],[20,"\n","24:\"R3qI\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"6u8K\"|36:177"],[20," \"age_count\": {"],[20,"\n","24:\"9HcK\"|36:177"],[20," \"cardinality\": {"],[20,"\n","24:\"bm3H\"|36:177"],[20," \"field\": \"age\""],[20,"\n","24:\"3m40\"|36:177"],[20," }"],[20,"\n","24:\"HX5w\"|36:177"],[20," },"],[20,"\n","24:\"ls2s\"|36:177"],[20," \"state_count\": {"],[20,"\n","24:\"QSqO\"|36:177"],[20," \"cardinality\": {"],[20,"\n","24:\"GLKH\"|36:177"],[20," \"field\": \"state.keyword\""],[20,"\n","24:\"iVdA\"|36:177"],[20," }"],[20,"\n","24:\"qLUJ\"|36:177"],[20," }"],[20,"\n","24:\"QzBc\"|36:177"],[20," }"],[20,"\n","24:\"FhVd\"|36:177"],[20,"}"],[20,"\n","24:\"GuuK\"|36:177"],[20,"\n","24:\"G0ZV\""],[20," 说明：state的使用它的keyword版","0:\"%23ff0000\"|31:2|8:1"],[20,"\n","24:\"fd1i\""],[20," 结果1：","31:2"],[20,"\n","24:\"4tE5\""],[20,"\n","24:\"mGji\""],[20,"{"],[20,"\n","24:\"2exz\"|36:177"],[20," \"took\": 2074,"],[20,"\n","24:\"Oufd\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"W5ud\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"xcKv\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"Ee1Q\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"tTx8\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"MF3A\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"qKh1\"|36:177"],[20," },"],[20,"\n","24:\"cFZy\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"fZV6\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"IazR\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"kRwc\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"roaa\"|36:177"],[20," },"],[20,"\n","24:\"OwrY\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"P3uC\"|36:177"],[20," \"state_count\": {"],[20,"\n","24:\"WVUt\"|36:177"],[20," \"value\": 51"],[20,"\n","24:\"t1Ql\"|36:177"],[20," },"],[20,"\n","24:\"J463\"|36:177"],[20," \"age_count\": {"],[20,"\n","24:\"9MLr\"|36:177"],[20," \"value\": 21"],[20,"\n","24:\"g7gg\"|36:177"],[20," }"],[20,"\n","24:\"cslx\"|36:177"],[20," }"],[20,"\n","24:\"7ZsR\"|36:177"],[20,"}"],[20,"\n","24:\"6Rl2\"|36:177"],[20," 5. stats 统计 count max min avg sum 5个值","27:\"12\"|31:2"],[20,"\n","24:\"T6tj\"|32:3|linespacing:\"150\""],[20," 示例1：","31:2"],[20,"\n","24:\"KKAT\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"VI9T\"|36:177"],[20,"{"],[20,"\n","24:\"PefW\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"Iq0j\"|36:177"],[20," \"age_stats\": {"],[20,"\n","24:\"9fxI\"|36:177"],[20," \"stats\": {"],[20,"\n","24:\"LdHX\"|36:177"],[20," \"field\": \"age\""],[20,"\n","24:\"Npo7\"|36:177"],[20," }"],[20,"\n","24:\"CGeJ\"|36:177"],[20," }"],[20,"\n","24:\"wuue\"|36:177"],[20," }"],[20,"\n","24:\"Ou4o\"|36:177"],[20,"}"],[20,"\n","24:\"BxCf\"|36:177"],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"tH8f\""],[20," 结果1：","31:2"],[20,"\n","24:\"3jLY\""],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"HYbN\""],[20,"{"],[20,"\n","24:\"U8WC\"|36:177"],[20," \"took\": 7,"],[20,"\n","24:\"SeL2\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"1hPq\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"Db8Q\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"rgfA\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"4jK7\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"W8GG\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"7rA6\"|36:177"],[20," },"],[20,"\n","24:\"0tWK\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"fBCj\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"5oQF\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"P5RM\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"bwCX\"|36:177"],[20," },"],[20,"\n","24:\"rWyP\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"STY7\"|36:177"],[20," \"age_stats\": {"],[20,"\n","24:\"nEjE\"|36:177"],[20," \"count\": 1000,"],[20,"\n","24:\"FP5H\"|36:177"],[20," \"min\": 20,"],[20,"\n","24:\"FT0Z\"|36:177"],[20," \"max\": 40,"],[20,"\n","24:\"a1lv\"|36:177"],[20," \"avg\": 30.171,"],[20,"\n","24:\"97eR\"|36:177"],[20," \"sum\": 30171"],[20,"\n","24:\"inxZ\"|36:177"],[20," }"],[20,"\n","24:\"uM96\"|36:177"],[20," }"],[20,"\n","24:\"sO0M\"|36:177"],[20,"}"],[20,"\n","24:\"2Duv\"|36:177"],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"k4Vq\""],[20," 6. Extended stats","27:\"12\"|31:2"],[20,"\n","24:\"UvGq\"|32:3|linespacing:\"150\""],[20,"高级统计，比stats多4个统计结果： 平方和、方差、标准差、平均值加/减两个标准差的区间","31:2"],[20,"\n","24:\"httE\""],[20," 示例1：","31:2"],[20,"\n","24:\"yKiU\""],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"xm30\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"wDB0\"|36:177"],[20,"{"],[20,"\n","24:\"JI1r\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"rqbb\"|36:177"],[20," \"age_stats\": {"],[20,"\n","24:\"q9ei\"|36:177"],[20," \"extended_stats\": {"],[20,"\n","24:\"YGrG\"|36:177"],[20," \"field\": \"age\""],[20,"\n","24:\"jXUl\"|36:177"],[20," }"],[20,"\n","24:\"pEGF\"|36:177"],[20," }"],[20,"\n","24:\"HLVJ\"|36:177"],[20," }"],[20,"\n","24:\"Z8x6\"|36:177"],[20,"}"],[20,"\n","24:\"jMqm\"|36:177"],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"hPZP\""],[20," 结果1：","31:2"],[20,"\n","24:\"mnYH\""],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"uv4r\""],[20,"{"],[20,"\n","24:\"5trf\"|36:177"],[20," \"took\": 7,"],[20,"\n","24:\"eVwD\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"yw4l\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"vvG6\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"5zkG\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"1Ml9\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"3gaM\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"vbNB\"|36:177"],[20," },"],[20,"\n","24:\"Lmiu\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"nuw0\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"ehTL\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"Da4X\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"bPe2\"|36:177"],[20," },"],[20,"\n","24:\"QnUz\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"d4C1\"|36:177"],[20," \"age_stats\": {"],[20,"\n","24:\"hCIi\"|36:177"],[20," \"count\": 1000,"],[20,"\n","24:\"Aob0\"|36:177"],[20," \"min\": 20,"],[20,"\n","24:\"twBn\"|36:177"],[20," \"max\": 40,"],[20,"\n","24:\"0xY4\"|36:177"],[20," \"avg\": 30.171,"],[20,"\n","24:\"WimT\"|36:177"],[20," \"sum\": 30171,"],[20,"\n","24:\"UrBb\"|36:177"],[20," \"sum_of_squares\": 946393,"],[20,"\n","24:\"CHt1\"|36:177"],[20," \"variance\": 36.10375899999996,"],[20,"\n","24:\"6JR8\"|36:177"],[20," \"std_deviation\": 6.008640362012022,"],[20,"\n","24:\"B7gC\"|36:177"],[20," \"std_deviation_bounds\": {"],[20,"\n","24:\"o2CW\"|36:177"],[20," \"upper\": 42.18828072402404,"],[20,"\n","24:\"cdtD\"|36:177"],[20," \"lower\": 18.153719275975956"],[20,"\n","24:\"30Nz\"|36:177"],[20," }"],[20,"\n","24:\"H5qU\"|36:177"],[20," }"],[20,"\n","24:\"9aG4\"|36:177"],[20," }"],[20,"\n","24:\"LwkT\"|36:177"],[20,"}"],[20,"\n","24:\"u2TG\"|36:177"],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"HFml\""],[20," 7. Percentiles 占比百分位对应的值统计","27:\"12\"|31:2"],[20,"\n","24:\"oNX0\"|32:3|linespacing:\"150\""],[20,"对指定字段(脚本)的值按从小到大累计每个值对应的文档数的占比(占所有命中文档数的百分比)，返回指定占比比例对应的值。默认返回[ 1, 5, 25, 50, 75, 95, 99 ]分位上的值。如下中间的结果，可以理解为：占比为50%的文档的age值 <= 31，或反过来：age<=31的文档数占总命中文档数的50%","31:2"],[20,"\n","24:\"ltad\""],[20," 示例1：","31:2"],[20,"\n","24:\"BE3Y\""],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"K7HV\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"ehkB\"|36:177"],[20,"{"],[20,"\n","24:\"KMzg\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"jfMc\"|36:177"],[20," \"age_percents\": {"],[20,"\n","24:\"VlhB\"|36:177"],[20," \"percentiles\": {"],[20,"\n","24:\"VbDk\"|36:177"],[20," \"field\": \"age\""],[20,"\n","24:\"Yqd5\"|36:177"],[20," }"],[20,"\n","24:\"71Lt\"|36:177"],[20," }"],[20,"\n","24:\"Ibbi\"|36:177"],[20," }"],[20,"\n","24:\"snx0\"|36:177"],[20,"}"],[20,"\n","24:\"QsHx\"|36:177"],[20,"\n","24:\"Rybg\""],[20,"结果1：","31:2"],[20,"\n","24:\"4s6w\""],[20,"\n","24:\"K8yZ\""],[20,"{"],[20,"\n","24:\"pByZ\"|36:177"],[20," \"took\": 87,"],[20,"\n","24:\"hB25\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"3cR0\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"5Ee8\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"rVjo\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"p8bJ\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"t4KH\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"Fgef\"|36:177"],[20," },"],[20,"\n","24:\"mkPS\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"30wD\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"2NcD\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"R12o\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"E2ZV\"|36:177"],[20," },"],[20,"\n","24:\"ZsJf\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"EovF\"|36:177"],[20," \"age_percents\": {"],[20,"\n","24:\"rnAt\"|36:177"],[20," \"values\": {"],[20,"\n","24:\"53sK\"|36:177"],[20," \"1.0\": 20,"],[20,"\n","24:\"o4wP\"|36:177"],[20," \"5.0\": 21,"],[20,"\n","24:\"7VnH\"|36:177"],[20," \"25.0\": 25,"],[20,"\n","24:\"iuH9\"|36:177"],[20," \"50.0\": 31,"],[20,"\n","24:\"1F0g\"|36:177"],[20," \"75.0\": 35.00000000000001,"],[20,"\n","24:\"boKa\"|36:177"],[20," \"95.0\": 39,"],[20,"\n","24:\"5S4I\"|36:177"],[20," \"99.0\": 40"],[20,"\n","24:\"Eng8\"|36:177"],[20," }"],[20,"\n","24:\"6zEO\"|36:177"],[20," }"],[20,"\n","24:\"ZOVL\"|36:177"],[20," }"],[20,"\n","24:\"HAGG\"|36:177"],[20,"}"],[20,"\n","24:\"fK7K\"|36:177"],[20,"\n","24:\"LFQs\""],[20," 结果说明:","31:2"],[20,"\n","24:\"nsvT\""],[20,"占比为50%的文档的age值 <= 31，或反过来：age<=31的文档数占总命中文档数的50%","31:2"],[20,"\n","24:\"WSXQ\""],[20," 示例2：指定分位值","31:2"],[20,"\n","24:\"cVvI\""],[20,"\n","24:\"RE36\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"8EZe\"|36:177"],[20,"{"],[20,"\n","24:\"7VwT\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"bHEg\"|36:177"],[20," \"age_percents\": {"],[20,"\n","24:\"ypaa\"|36:177"],[20," \"percentiles\": {"],[20,"\n","24:\"K5LV\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"5hSo\"|36:177"],[20," \"percents\" : [95, 99, 99.9] "],[20,"\n","24:\"lOVr\"|36:177"],[20," }"],[20,"\n","24:\"vrYU\"|36:177"],[20," }"],[20,"\n","24:\"xg7Z\"|36:177"],[20," }"],[20,"\n","24:\"BjYF\"|36:177"],[20,"}"],[20,"\n","24:\"n0V8\"|36:177"],[20,"\n","24:\"vP40\""],[20," 结果2：","31:2"],[20,"\n","24:\"jKo2\""],[20,"\n","24:\"EokS\""],[20,"{"],[20,"\n","24:\"Z2RI\"|36:177"],[20," \"took\": 8,"],[20,"\n","24:\"andR\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"8WK9\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"28tB\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"v2mx\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"dsz4\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"8DPg\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"bnrJ\"|36:177"],[20," },"],[20,"\n","24:\"kQkt\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"SxrN\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"jY3t\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"ce2d\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"Jigt\"|36:177"],[20," },"],[20,"\n","24:\"Vvuf\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"JKmF\"|36:177"],[20," \"age_percents\": {"],[20,"\n","24:\"cmch\"|36:177"],[20," \"values\": {"],[20,"\n","24:\"pBvS\"|36:177"],[20," \"95.0\": 39,"],[20,"\n","24:\"ukha\"|36:177"],[20," \"99.0\": 40,"],[20,"\n","24:\"1tPX\"|36:177"],[20," \"99.9\": 40"],[20,"\n","24:\"X3ub\"|36:177"],[20," }"],[20,"\n","24:\"nNI1\"|36:177"],[20," }"],[20,"\n","24:\"TK9k\"|36:177"],[20," }"],[20,"\n","24:\"3NiS\"|36:177"],[20,"}"],[20,"\n","24:\"Vj8Y\"|36:177"],[20,"\n","24:\"LCUh\""],[20," 8. Percentiles rank 统计值小于等于指定值的文档占比","27:\"12\"|31:2"],[20,"\n","24:\"n9qn\"|32:3|linespacing:\"150\""],[20," 示例1：统计年龄小于25和30的文档的占比，和第7项相反","31:2"],[20,"\n","24:\"17sS\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"8ULi\"|36:177"],[20,"{"],[20,"\n","24:\"qi6O\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"gTPU\"|36:177"],[20," \"gge_perc_rank\": {"],[20,"\n","24:\"ED9q\"|36:177"],[20," \"percentile_ranks\": {"],[20,"\n","24:\"RrRN\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"G5om\"|36:177"],[20," \"values\": ["],[20,"\n","24:\"tOt3\"|36:177"],[20," 25,"],[20,"\n","24:\"nbdr\"|36:177"],[20," 30"],[20,"\n","24:\"PtZR\"|36:177"],[20," ]"],[20,"\n","24:\"sc1X\"|36:177"],[20," }"],[20,"\n","24:\"Spt8\"|36:177"],[20," }"],[20,"\n","24:\"upnS\"|36:177"],[20," }"],[20,"\n","24:\"0CK5\"|36:177"],[20,"}"],[20,"\n","24:\"l97t\"|36:177"],[20,"结果2：","31:2"],[20,"\n","24:\"Lwzp\""],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"r2ak\""],[20,"{"],[20,"\n","24:\"npB1\"|36:177"],[20," \"took\": 8,"],[20,"\n","24:\"5Qf2\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"BZju\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"CDdI\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"qMmh\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"wVqf\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"SctH\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"B9Ks\"|36:177"],[20," },"],[20,"\n","24:\"5Jx9\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"4f0v\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"nI1G\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"t4v2\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"uCIt\"|36:177"],[20," },"],[20,"\n","24:\"VJsC\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"9ShG\"|36:177"],[20," \"gge_perc_rank\": {"],[20,"\n","24:\"x9K9\"|36:177"],[20," \"values\": {"],[20,"\n","24:\"92ba\"|36:177"],[20," \"25.0\": 26.1,"],[20,"\n","24:\"xDYN\"|36:177"],[20," \"30.0\": 49.2"],[20,"\n","24:\"GIxF\"|36:177"],[20," }"],[20,"\n","24:\"BHE5\"|36:177"],[20," }"],[20,"\n","24:\"yTL8\"|36:177"],[20," }"],[20,"\n","24:\"avnn\"|36:177"],[20,"}"],[20,"\n","24:\"932K\"|36:177"],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"1yC6\""],[20," 结果说明：年龄小于25的文档占比为26.1%，年龄小于30的文档占比为49.2%，","31:2"],[20,"\n","24:\"z8OG\""],[20," 9. Geo Bounds aggregation 求文档集中的地理位置坐标点的范围","27:\"12\"|31:2"],[20,"\n","24:\"C5ew\"|32:3|linespacing:\"150\""],[20,"参考官网链接：","31:2"],[20,"\n","24:\"coyu\""],[20,"https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-geobounds-aggregation.html","16:\"https%3A%2F%2Fwww.elastic.co%2Fguide%2Fen%2Felasticsearch%2Freference%2Fcurrent%2Fsearch-aggregations-metrics-geobounds-aggregation.html\"|31:2"],[20,"\n","24:\"psz7\""],[20,"10. Geo Centroid aggregation  求地理位置中心点坐标值","27:\"12\"|31:2"],[20,"\n","24:\"0a2J\"|32:3|linespacing:\"150\""],[20,"参考官网链接：","31:2"],[20,"\n","24:\"sfTs\""],[20,"https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-geocentroid-aggregation.html","16:\"https%3A%2F%2Fwww.elastic.co%2Fguide%2Fen%2Felasticsearch%2Freference%2Fcurrent%2Fsearch-aggregations-metrics-geocentroid-aggregation.html\"|31:2"],[20,"\n","24:\"kqFG\""],[20,"三、桶聚合","27:\"16\"|31:2"],[20,"\n","24:\"O2ug\"|32:2|linespacing:\"150\""],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"OfX4\""],[20," ","31:2"],[20,"\n","24:\"Ibd1\""],[20,"1. Terms Aggregation  根据字段值项分组聚合 ","27:\"12\"|31:2"],[20,"\n","24:\"zESh\"|32:3|linespacing:\"150\""],[20," 示例1：","31:2"],[20,"\n","24:\"LNdw\""],[20,"\n","24:\"lg9c\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"6xCD\"|36:177"],[20,"{"],[20,"\n","24:\"9bo7\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"FOlx\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"EVF8\"|36:177"],[20," \"terms\": {"],[20,"\n","24:\"pBb5\"|36:177"],[20," \"field\": \"age\""],[20,"\n","24:\"vfwY\"|36:177"],[20," }"],[20,"\n","24:\"XK3M\"|36:177"],[20," }"],[20,"\n","24:\"UHIG\"|36:177"],[20," }"],[20,"\n","24:\"luhg\"|36:177"],[20,"}"],[20,"\n","24:\"PPp7\"|36:177"],[20,"\n","24:\"Bmqw\""],[20," 结果1：","31:2"],[20,"\n","24:\"NrSB\""],[20,"\n","24:\"VNgr\""],[20,"{"],[20,"\n","24:\"POvq\"|36:177"],[20," \"took\": 2000,"],[20,"\n","24:\"o0o0\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"bIYh\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"ymii\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"6F2Q\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"pB8b\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"gr7r\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"jLzQ\"|36:177"],[20," },"],[20,"\n","24:\"tj7w\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"x6Oh\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"19oD\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"Sw5c\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"TVIi\"|36:177"],[20," },"],[20,"\n","24:\"raBr\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"4PCJ\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"1SLr\"|36:177"],[20," \"doc_count_error_upper_bound\": 0,"],[20,"\n","24:\"7qQy\"|36:177"],[20," \"sum_other_doc_count\": 463,"],[20,"\n","24:\"vReI\"|36:177"],[20," \"buckets\": ["],[20,"\n","24:\"vrSh\"|36:177"],[20," {"],[20,"\n","24:\"iMjG\"|36:177"],[20," \"key\": 31,"],[20,"\n","24:\"WT1f\"|36:177"],[20," \"doc_count\": 61"],[20,"\n","24:\"bIEU\"|36:177"],[20," },"],[20,"\n","24:\"nf5X\"|36:177"],[20," {"],[20,"\n","24:\"xDCn\"|36:177"],[20," \"key\": 39,"],[20,"\n","24:\"ZFBl\"|36:177"],[20," \"doc_count\": 60"],[20,"\n","24:\"ysKO\"|36:177"],[20," },"],[20,"\n","24:\"Rmf3\"|36:177"],[20," {"],[20,"\n","24:\"wKCs\"|36:177"],[20," \"key\": 26,"],[20,"\n","24:\"hzYP\"|36:177"],[20," \"doc_count\": 59"],[20,"\n","24:\"PvT9\"|36:177"],[20," },"],[20,"\n","24:\"SaL0\"|36:177"],[20," {"],[20,"\n","24:\"DhWZ\"|36:177"],[20," \"key\": 32,"],[20,"\n","24:\"0hCS\"|36:177"],[20," \"doc_count\": 52"],[20,"\n","24:\"Zs6L\"|36:177"],[20," },"],[20,"\n","24:\"XZOV\"|36:177"],[20," {"],[20,"\n","24:\"Gzmx\"|36:177"],[20," \"key\": 35,"],[20,"\n","24:\"u2eS\"|36:177"],[20," \"doc_count\": 52"],[20,"\n","24:\"ltg4\"|36:177"],[20," },"],[20,"\n","24:\"SAWb\"|36:177"],[20," {"],[20,"\n","24:\"tpxH\"|36:177"],[20," \"key\": 36,"],[20,"\n","24:\"gjun\"|36:177"],[20," \"doc_count\": 52"],[20,"\n","24:\"Epg0\"|36:177"],[20," },"],[20,"\n","24:\"0GZO\"|36:177"],[20," {"],[20,"\n","24:\"1Jpx\"|36:177"],[20," \"key\": 22,"],[20,"\n","24:\"0Lac\"|36:177"],[20," \"doc_count\": 51"],[20,"\n","24:\"EODY\"|36:177"],[20," },"],[20,"\n","24:\"Laqh\"|36:177"],[20," {"],[20,"\n","24:\"Rl6u\"|36:177"],[20," \"key\": 28,"],[20,"\n","24:\"CI4A\"|36:177"],[20," \"doc_count\": 51"],[20,"\n","24:\"PhCV\"|36:177"],[20," },"],[20,"\n","24:\"PcBA\"|36:177"],[20," {"],[20,"\n","24:\"nitk\"|36:177"],[20," \"key\": 33,"],[20,"\n","24:\"W5Kg\"|36:177"],[20," \"doc_count\": 50"],[20,"\n","24:\"YSGw\"|36:177"],[20," },"],[20,"\n","24:\"yS5A\"|36:177"],[20," {"],[20,"\n","24:\"v4a2\"|36:177"],[20," \"key\": 34,"],[20,"\n","24:\"mRI5\"|36:177"],[20," \"doc_count\": 49"],[20,"\n","24:\"lH4y\"|36:177"],[20," }"],[20,"\n","24:\"bNjT\"|36:177"],[20," ]"],[20,"\n","24:\"4Trs\"|36:177"],[20," }"],[20,"\n","24:\"eRBm\"|36:177"],[20," }"],[20,"\n","24:\"B6V9\"|36:177"],[20,"}"],[20,"\n","24:\"NM2q\"|36:177"],[20,"\n","24:\"vMaR\""],[20," 结果说明：","31:2"],[20,"\n","24:\"tuoY\""],[20,"\"doc_count_error_upper_bound\": 0：文档计数的最大偏差值","31:2"],[20,"\n","24:\"xEAP\""],[20,"\"sum_other_doc_count\": 463：未返回的其他项的文档数","31:2"],[20,"\n","24:\"sGWc\""],[20,"默认情况下返回按文档计数从高到低的前10个分组：","31:2"],[20,"\n","24:\"MaM3\""],[20,"\n","24:\"LcNL\""],[20," \"buckets\": ["],[20,"\n","24:\"xqyt\"|36:177"],[20," {"],[20,"\n","24:\"wSrT\"|36:177"],[20," \"key\": 31,"],[20,"\n","24:\"6YCl\"|36:177"],[20," \"doc_count\": 61"],[20,"\n","24:\"sGMs\"|36:177"],[20," },"],[20,"\n","24:\"9kk4\"|36:177"],[20," {"],[20,"\n","24:\"Hxcp\"|36:177"],[20," \"key\": 39,"],[20,"\n","24:\"4u5v\"|36:177"],[20," \"doc_count\": 60"],[20,"\n","24:\"ALVv\"|36:177"],[20," },"],[20,"\n","24:\"dx30\"|36:177"],[20," ............."],[20,"\n","24:\"HPWD\"|36:177"],[20,"]"],[20,"\n","24:\"88Ua\"|36:177"],[20,"\n","24:\"lfFc\""],[20," 年龄为31的文档有61个，年龄为39的文档有60个","31:2"],[20,"\n","24:\"Etdh\""],[20," size 指定返回多少个分组：","31:2|8:1"],[20,"\n","24:\"tmj7\""],[20,"示例2：指定返回20个分组","31:2"],[20,"\n","24:\"6lpL\""],[20,"\n","24:\"zBAi\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"9APT\"|36:177"],[20,"{"],[20,"\n","24:\"CV7X\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"pdGK\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"kI1a\"|36:177"],[20," \"terms\": {"],[20,"\n","24:\"zMzx\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"afUe\"|36:177"],[20," \"size\": 20"],[20,"\n","24:\"cOi8\"|36:177"],[20," }"],[20,"\n","24:\"V2En\"|36:177"],[20," }"],[20,"\n","24:\"l7Oy\"|36:177"],[20," }"],[20,"\n","24:\"uzyF\"|36:177"],[20,"}"],[20,"\n","24:\"lZRk\"|36:177"],[20,"\n","24:\"hRzd\""],[20," 结果2：","31:2"],[20,"\n","24:\"jGlZ\""],[20," ","1:\"%23f5f5f5\"|27:\"9\""],[20,"View Code","1:\"%23ffffff\"|27:\"9\""],[20,"\n","24:\"NRN7\""],[20," 示例3：每个分组上显示偏差值","31:2"],[20,"\n","24:\"lImp\""],[20,"\n","24:\"N8GX\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"f6ju\"|36:177"],[20,"{"],[20,"\n","24:\"NoQP\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"ERPy\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"1PxX\"|36:177"],[20," \"terms\": {"],[20,"\n","24:\"RDG6\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"iWfj\"|36:177"],[20," \"size\": 5,"],[20,"\n","24:\"4xkX\"|36:177"],[20," \"shard_size\": 20,"],[20,"\n","24:\"zeY3\"|36:177"],[20," \"show_term_doc_count_error\": true"],[20,"\n","24:\"Zrxh\"|36:177"],[20," }"],[20,"\n","24:\"WJah\"|36:177"],[20," }"],[20,"\n","24:\"M0yX\"|36:177"],[20," }"],[20,"\n","24:\"KiGu\"|36:177"],[20,"}"],[20,"\n","24:\"bydm\"|36:177"],[20,"\n","24:\"YI9V\""],[20," 结果3：","31:2"],[20,"\n","24:\"lZes\""],[20,"\n","24:\"vSKx\""],[20,"{"],[20,"\n","24:\"lEcu\"|36:177"],[20," \"took\": 8,"],[20,"\n","24:\"WBZH\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"dAID\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"NQ7f\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"lSmG\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"hmOO\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"21fn\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"xZFX\"|36:177"],[20," },"],[20,"\n","24:\"pJBx\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"weqC\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"NnFA\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"bEKX\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"sc02\"|36:177"],[20," },"],[20,"\n","24:\"mkAj\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"DD8u\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"k3p6\"|36:177"],[20," \"doc_count_error_upper_bound\": 25,"],[20,"\n","24:\"SZuW\"|36:177"],[20," \"sum_other_doc_count\": 716,"],[20,"\n","24:\"t447\"|36:177"],[20," \"buckets\": ["],[20,"\n","24:\"gNY3\"|36:177"],[20," {"],[20,"\n","24:\"Ha4k\"|36:177"],[20," \"key\": 31,"],[20,"\n","24:\"J41W\"|36:177"],[20," \"doc_count\": 61,"],[20,"\n","24:\"xSXo\"|36:177"],[20," \"doc_count_error_upper_bound\": 0"],[20,"\n","24:\"aje0\"|36:177"],[20," },"],[20,"\n","24:\"924l\"|36:177"],[20," {"],[20,"\n","24:\"Fg9t\"|36:177"],[20," \"key\": 39,"],[20,"\n","24:\"fevj\"|36:177"],[20," \"doc_count\": 60,"],[20,"\n","24:\"ydaW\"|36:177"],[20," \"doc_count_error_upper_bound\": 0"],[20,"\n","24:\"49lP\"|36:177"],[20," },"],[20,"\n","24:\"BWxn\"|36:177"],[20," {"],[20,"\n","24:\"JkJI\"|36:177"],[20," \"key\": 26,"],[20,"\n","24:\"w4FS\"|36:177"],[20," \"doc_count\": 59,"],[20,"\n","24:\"PxMg\"|36:177"],[20," \"doc_count_error_upper_bound\": 0"],[20,"\n","24:\"ivz3\"|36:177"],[20," },"],[20,"\n","24:\"MMRQ\"|36:177"],[20," {"],[20,"\n","24:\"afHy\"|36:177"],[20," \"key\": 32,"],[20,"\n","24:\"hO03\"|36:177"],[20," \"doc_count\": 52,"],[20,"\n","24:\"HzCY\"|36:177"],[20," \"doc_count_error_upper_bound\": 0"],[20,"\n","24:\"1rGV\"|36:177"],[20," },"],[20,"\n","24:\"0zIn\"|36:177"],[20," {"],[20,"\n","24:\"nFoA\"|36:177"],[20," \"key\": 36,"],[20,"\n","24:\"aenf\"|36:177"],[20," \"doc_count\": 52,"],[20,"\n","24:\"V3yH\"|36:177"],[20," \"doc_count_error_upper_bound\": 0"],[20,"\n","24:\"9cXl\"|36:177"],[20," }"],[20,"\n","24:\"B6PN\"|36:177"],[20," ]"],[20,"\n","24:\"vDHF\"|36:177"],[20," }"],[20,"\n","24:\"UyjO\"|36:177"],[20," }"],[20,"\n","24:\"IcVy\"|36:177"],[20,"}"],[20,"\n","24:\"xGmD\"|36:177"],[20,"\n","24:\"1JIQ\""],[20," 示例4：shard_size 指定每个分片上返回多少个分组","31:2"],[20,"\n","24:\"1oTH\""],[20,"shard_size 的默认值为：","31:2"],[20,"\n","24:\"KYEL\""],[20,"索引只有一个分片：= size","31:2"],[20,"\n","24:\"rJx7\""],[20,"多分片：= size * 1.5 + 10","31:2"],[20,"\n","24:\"b6P0\""],[20,"\n","24:\"DgaE\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"QN4T\"|36:177"],[20,"{"],[20,"\n","24:\"v7VO\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"HQ2R\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"34ol\"|36:177"],[20," \"terms\": {"],[20,"\n","24:\"aFXX\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"uhR8\"|36:177"],[20," \"size\": 5,"],[20,"\n","24:\"MRVX\"|36:177"],[20," \"shard_size\": 20"],[20,"\n","24:\"iVDB\"|36:177"],[20," }"],[20,"\n","24:\"vwSw\"|36:177"],[20," }"],[20,"\n","24:\"4w5u\"|36:177"],[20," }"],[20,"\n","24:\"RVvY\"|36:177"],[20,"}"],[20,"\n","24:\"cux0\"|36:177"],[20,"\n","24:\"jEFg\""],[20," 结果4：","31:2"],[20,"\n","24:\"30K3\""],[20,"\n","24:\"LBPk\""],[20,"{"],[20,"\n","24:\"0aWR\"|36:177"],[20," \"took\": 8,"],[20,"\n","24:\"Vk2Z\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"pigQ\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"Khhs\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"T66x\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"GxDH\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"buyQ\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"qJLz\"|36:177"],[20," },"],[20,"\n","24:\"hsaD\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"JNHf\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"t9te\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"M0k3\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"BxoO\"|36:177"],[20," },"],[20,"\n","24:\"pHbZ\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"xPo3\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"EBDZ\"|36:177"],[20," \"doc_count_error_upper_bound\": 25,"],[20,"\n","24:\"13Op\"|36:177"],[20," \"sum_other_doc_count\": 716,"],[20,"\n","24:\"pccp\"|36:177"],[20," \"buckets\": ["],[20,"\n","24:\"yq2Y\"|36:177"],[20," {"],[20,"\n","24:\"mN4g\"|36:177"],[20," \"key\": 31,"],[20,"\n","24:\"OOoE\"|36:177"],[20," \"doc_count\": 61"],[20,"\n","24:\"Ivco\"|36:177"],[20," },"],[20,"\n","24:\"tJhi\"|36:177"],[20," {"],[20,"\n","24:\"mTG0\"|36:177"],[20," \"key\": 39,"],[20,"\n","24:\"2aCV\"|36:177"],[20," \"doc_count\": 60"],[20,"\n","24:\"KrEf\"|36:177"],[20," },"],[20,"\n","24:\"Xo5L\"|36:177"],[20," {"],[20,"\n","24:\"SaZn\"|36:177"],[20," \"key\": 26,"],[20,"\n","24:\"SU7T\"|36:177"],[20," \"doc_count\": 59"],[20,"\n","24:\"U9si\"|36:177"],[20," },"],[20,"\n","24:\"TncJ\"|36:177"],[20," {"],[20,"\n","24:\"Ti2G\"|36:177"],[20," \"key\": 32,"],[20,"\n","24:\"IBdE\"|36:177"],[20," \"doc_count\": 52"],[20,"\n","24:\"RagB\"|36:177"],[20," },"],[20,"\n","24:\"qicH\"|36:177"],[20," {"],[20,"\n","24:\"kpYi\"|36:177"],[20," \"key\": 36,"],[20,"\n","24:\"s61V\"|36:177"],[20," \"doc_count\": 52"],[20,"\n","24:\"u0FS\"|36:177"],[20," }"],[20,"\n","24:\"IbbM\"|36:177"],[20," ]"],[20,"\n","24:\"HBVx\"|36:177"],[20," }"],[20,"\n","24:\"ZVME\"|36:177"],[20," }"],[20,"\n","24:\"nWL9\"|36:177"],[20,"}"],[20,"\n","24:\"wyY5\"|36:177"],[20,"\n","24:\"DVrV\""],[20," order  指定分组的排序","31:2|8:1"],[20,"\n","24:\"pEvI\""],[20," 示例5：根据文档计数排序","31:2"],[20,"\n","24:\"361v\""],[20,"\n","24:\"9mQf\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"XRPE\"|36:177"],[20,"{"],[20,"\n","24:\"Qz9J\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"Auo5\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"Lupx\"|36:177"],[20," \"terms\": {"],[20,"\n","24:\"H4t3\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"p7Ye\"|36:177"],[20," \"order\" : { \"_count\" : \"asc\" }"],[20,"\n","24:\"Y0xt\"|36:177"],[20," }"],[20,"\n","24:\"7YM9\"|36:177"],[20," }"],[20,"\n","24:\"YYnD\"|36:177"],[20," }"],[20,"\n","24:\"pRq2\"|36:177"],[20,"}"],[20,"\n","24:\"DuGJ\"|36:177"],[20,"\n","24:\"JUuX\""],[20," 结果5：","31:2"],[20,"\n","24:\"KYVn\""],[20,"\n","24:\"w9dE\""],[20,"{"],[20,"\n","24:\"SiKB\"|36:177"],[20," \"took\": 3,"],[20,"\n","24:\"og0O\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"qwQ8\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"0SMs\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"HRuD\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"FloI\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"Lwz7\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"GROp\"|36:177"],[20," },"],[20,"\n","24:\"744x\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"EF7a\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"rfBm\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"airX\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"AS3o\"|36:177"],[20," },"],[20,"\n","24:\"UiYE\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"8MLq\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"bikf\"|36:177"],[20," \"doc_count_error_upper_bound\": 0,"],[20,"\n","24:\"3EHj\"|36:177"],[20," \"sum_other_doc_count\": 584,"],[20,"\n","24:\"tvKM\"|36:177"],[20," \"buckets\": ["],[20,"\n","24:\"RycI\"|36:177"],[20," {"],[20,"\n","24:\"K2iT\"|36:177"],[20," \"key\": 29,"],[20,"\n","24:\"kdsP\"|36:177"],[20," \"doc_count\": 35"],[20,"\n","24:\"lqqn\"|36:177"],[20," },"],[20,"\n","24:\"PdEe\"|36:177"],[20," {"],[20,"\n","24:\"60lp\"|36:177"],[20," \"key\": 27,"],[20,"\n","24:\"gnh2\"|36:177"],[20," \"doc_count\": 39"],[20,"\n","24:\"Mh35\"|36:177"],[20," },"],[20,"\n","24:\"fU53\"|36:177"],[20," {"],[20,"\n","24:\"YhQb\"|36:177"],[20," \"key\": 38,"],[20,"\n","24:\"p7NY\"|36:177"],[20," \"doc_count\": 39"],[20,"\n","24:\"wxIk\"|36:177"],[20," },"],[20,"\n","24:\"8dpM\"|36:177"],[20," {"],[20,"\n","24:\"xXtx\"|36:177"],[20," \"key\": 23,"],[20,"\n","24:\"BP7O\"|36:177"],[20," \"doc_count\": 42"],[20,"\n","24:\"8sBC\"|36:177"],[20," },"],[20,"\n","24:\"GNNU\"|36:177"],[20," {"],[20,"\n","24:\"gPBj\"|36:177"],[20," \"key\": 24,"],[20,"\n","24:\"pzsv\"|36:177"],[20," \"doc_count\": 42"],[20,"\n","24:\"jVWj\"|36:177"],[20," },"],[20,"\n","24:\"OHhv\"|36:177"],[20," {"],[20,"\n","24:\"Ch31\"|36:177"],[20," \"key\": 25,"],[20,"\n","24:\"coZj\"|36:177"],[20," \"doc_count\": 42"],[20,"\n","24:\"LARJ\"|36:177"],[20," },"],[20,"\n","24:\"mm6f\"|36:177"],[20," {"],[20,"\n","24:\"Xtbc\"|36:177"],[20," \"key\": 37,"],[20,"\n","24:\"XSNa\"|36:177"],[20," \"doc_count\": 42"],[20,"\n","24:\"yEeY\"|36:177"],[20," },"],[20,"\n","24:\"lkCc\"|36:177"],[20," {"],[20,"\n","24:\"Qhny\"|36:177"],[20," \"key\": 20,"],[20,"\n","24:\"O7WU\"|36:177"],[20," \"doc_count\": 44"],[20,"\n","24:\"us5c\"|36:177"],[20," },"],[20,"\n","24:\"WX5w\"|36:177"],[20," {"],[20,"\n","24:\"5Xr4\"|36:177"],[20," \"key\": 40,"],[20,"\n","24:\"B20c\"|36:177"],[20," \"doc_count\": 45"],[20,"\n","24:\"BAPK\"|36:177"],[20," },"],[20,"\n","24:\"mXs0\"|36:177"],[20," {"],[20,"\n","24:\"Ru5G\"|36:177"],[20," \"key\": 21,"],[20,"\n","24:\"DN6U\"|36:177"],[20," \"doc_count\": 46"],[20,"\n","24:\"1i2b\"|36:177"],[20," }"],[20,"\n","24:\"hfUC\"|36:177"],[20," ]"],[20,"\n","24:\"2rmY\"|36:177"],[20," }"],[20,"\n","24:\"4uTv\"|36:177"],[20," }"],[20,"\n","24:\"E8TO\"|36:177"],[20,"}"],[20,"\n","24:\"bN9k\"|36:177"],[20,"\n","24:\"wXqB\""],[20," 示例6：根据分组值排序","31:2"],[20,"\n","24:\"EUGC\""],[20,"\n","24:\"0ujK\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"lL3p\"|36:177"],[20,"{"],[20,"\n","24:\"V84D\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"QHJm\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"PmEB\"|36:177"],[20," \"terms\": {"],[20,"\n","24:\"LOjZ\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"Wsam\"|36:177"],[20," \"order\" : { \"_key\" : \"asc\" }"],[20,"\n","24:\"Z5vz\"|36:177"],[20," }"],[20,"\n","24:\"FxuZ\"|36:177"],[20," }"],[20,"\n","24:\"4uo8\"|36:177"],[20," }"],[20,"\n","24:\"Puo5\"|36:177"],[20,"}"],[20,"\n","24:\"6ega\"|36:177"],[20,"\n","24:\"7lyW\""],[20," 结果6：","31:2"],[20,"\n","24:\"EUe0\""],[20,"\n","24:\"D8rx\""],[20,"{"],[20,"\n","24:\"XmR3\"|36:177"],[20," \"took\": 10,"],[20,"\n","24:\"bwiY\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"pICy\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"eVSB\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"jwUm\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"qGEn\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"OVyo\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"liwB\"|36:177"],[20," },"],[20,"\n","24:\"QUPS\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"vHKG\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"5Shd\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"90HV\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"d5B3\"|36:177"],[20," },"],[20,"\n","24:\"8N31\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"0aZ0\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"Iy1O\"|36:177"],[20," \"doc_count_error_upper_bound\": 0,"],[20,"\n","24:\"M6QP\"|36:177"],[20," \"sum_other_doc_count\": 549,"],[20,"\n","24:\"lVZ9\"|36:177"],[20," \"buckets\": ["],[20,"\n","24:\"F8AQ\"|36:177"],[20," {"],[20,"\n","24:\"jbZ1\"|36:177"],[20," \"key\": 20,"],[20,"\n","24:\"yHTQ\"|36:177"],[20," \"doc_count\": 44"],[20,"\n","24:\"eskj\"|36:177"],[20," },"],[20,"\n","24:\"ZTXL\"|36:177"],[20," {"],[20,"\n","24:\"0KcQ\"|36:177"],[20," \"key\": 21,"],[20,"\n","24:\"4UTe\"|36:177"],[20," \"doc_count\": 46"],[20,"\n","24:\"U8TW\"|36:177"],[20," },"],[20,"\n","24:\"lsaK\"|36:177"],[20," {"],[20,"\n","24:\"LZjc\"|36:177"],[20," \"key\": 22,"],[20,"\n","24:\"Voyl\"|36:177"],[20," \"doc_count\": 51"],[20,"\n","24:\"F46A\"|36:177"],[20," },"],[20,"\n","24:\"7WFg\"|36:177"],[20," {"],[20,"\n","24:\"AqHo\"|36:177"],[20," \"key\": 23,"],[20,"\n","24:\"UkXk\"|36:177"],[20," \"doc_count\": 42"],[20,"\n","24:\"NMgz\"|36:177"],[20," },"],[20,"\n","24:\"zqsL\"|36:177"],[20," {"],[20,"\n","24:\"Gcxu\"|36:177"],[20," \"key\": 24,"],[20,"\n","24:\"5kFy\"|36:177"],[20," \"doc_count\": 42"],[20,"\n","24:\"6Wsx\"|36:177"],[20," },"],[20,"\n","24:\"gsEd\"|36:177"],[20," {"],[20,"\n","24:\"nYHM\"|36:177"],[20," \"key\": 25,"],[20,"\n","24:\"2EwL\"|36:177"],[20," \"doc_count\": 42"],[20,"\n","24:\"0C0v\"|36:177"],[20," },"],[20,"\n","24:\"yVQF\"|36:177"],[20," {"],[20,"\n","24:\"se3z\"|36:177"],[20," \"key\": 26,"],[20,"\n","24:\"GBbr\"|36:177"],[20," \"doc_count\": 59"],[20,"\n","24:\"SeIT\"|36:177"],[20," },"],[20,"\n","24:\"jhiN\"|36:177"],[20," {"],[20,"\n","24:\"1eh0\"|36:177"],[20," \"key\": 27,"],[20,"\n","24:\"8oBF\"|36:177"],[20," \"doc_count\": 39"],[20,"\n","24:\"9wbk\"|36:177"],[20," },"],[20,"\n","24:\"jM67\"|36:177"],[20," {"],[20,"\n","24:\"uZC2\"|36:177"],[20," \"key\": 28,"],[20,"\n","24:\"daV2\"|36:177"],[20," \"doc_count\": 51"],[20,"\n","24:\"UV4t\"|36:177"],[20," },"],[20,"\n","24:\"ty0U\"|36:177"],[20," {"],[20,"\n","24:\"hutF\"|36:177"],[20," \"key\": 29,"],[20,"\n","24:\"eH2P\"|36:177"],[20," \"doc_count\": 35"],[20,"\n","24:\"6Z9g\"|36:177"],[20," }"],[20,"\n","24:\"LQJN\"|36:177"],[20," ]"],[20,"\n","24:\"eek9\"|36:177"],[20," }"],[20,"\n","24:\"zXuq\"|36:177"],[20," }"],[20,"\n","24:\"kdt0\"|36:177"],[20,"}"],[20,"\n","24:\"JeRA\"|36:177"],[20,"\n","24:\"6ls6\""],[20,"示例7：取分组指标值排序","31:2"],[20,"\n","24:\"wFOQ\""],[20,"\n","24:\"WyNm\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"NEd1\"|36:177"],[20,"{"],[20,"\n","24:\"vCZz\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"7cot\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"qkCZ\"|36:177"],[20," \"terms\": {"],[20,"\n","24:\"SWGy\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"Hzxu\"|36:177"],[20," \"order\": {"],[20,"\n","24:\"zyOO\"|36:177"],[20," \"max_balance\": \"asc\""],[20,"\n","24:\"8z8S\"|36:177"],[20," }"],[20,"\n","24:\"dsxp\"|36:177"],[20," },"],[20,"\n","24:\"C6j7\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"iKq7\"|36:177"],[20," \"max_balance\": {"],[20,"\n","24:\"l61b\"|36:177"],[20," \"max\": {"],[20,"\n","24:\"DTC8\"|36:177"],[20," \"field\": \"balance\""],[20,"\n","24:\"L0P8\"|36:177"],[20," }"],[20,"\n","24:\"gh33\"|36:177"],[20," },"],[20,"\n","24:\"cV86\"|36:177"],[20," \"min_balance\": {"],[20,"\n","24:\"ehOC\"|36:177"],[20," \"min\": {"],[20,"\n","24:\"eKAQ\"|36:177"],[20," \"field\": \"balance\""],[20,"\n","24:\"bJdV\"|36:177"],[20," }"],[20,"\n","24:\"iAA1\"|36:177"],[20," }"],[20,"\n","24:\"egoR\"|36:177"],[20," }"],[20,"\n","24:\"fZ7K\"|36:177"],[20," }"],[20,"\n","24:\"t1RB\"|36:177"],[20," }"],[20,"\n","24:\"mhkH\"|36:177"],[20,"}"],[20,"\n","24:\"CLNl\"|36:177"],[20,"\n","24:\"Kl5y\""],[20," 结果7：","31:2"],[20,"\n","24:\"Zq9Z\""],[20," ","1:\"%23f5f5f5\"|27:\"9\""],[20,"View Code","1:\"%23ffffff\"|27:\"9\""],[20,"\n","24:\"eOGF\""],[20," 示例8：筛选分组-正则表达式匹配值","31:2"],[20,"\n","24:\"6QQV\""],[20,"\n","24:\"QtPH\""],[20,"GET /_search"],[20,"\n","24:\"sOrd\"|36:177"],[20,"{"],[20,"\n","24:\"E43a\"|36:177"],[20," \"aggs\" : {"],[20,"\n","24:\"OEeJ\"|36:177"],[20," \"tags\" : {"],[20,"\n","24:\"Imug\"|36:177"],[20," \"terms\" : {"],[20,"\n","24:\"Okwp\"|36:177"],[20," \"field\" : \"tags\","],[20,"\n","24:\"QcCz\"|36:177"],[20," \"include\" : \".*sport.*\","],[20,"\n","24:\"LyRB\"|36:177"],[20," \"exclude\" : \"water_.*\""],[20,"\n","24:\"1aET\"|36:177"],[20," }"],[20,"\n","24:\"ghPK\"|36:177"],[20," }"],[20,"\n","24:\"SWqP\"|36:177"],[20," }"],[20,"\n","24:\"bW4Q\"|36:177"],[20,"}"],[20,"\n","24:\"wcf7\"|36:177"],[20,"\n","24:\"CtAF\""],[20," 示例9：筛选分组-指定值列表","31:2"],[20,"\n","24:\"5PXR\""],[20,"\n","24:\"AClV\""],[20,"GET /_search"],[20,"\n","24:\"YaWh\"|36:177"],[20,"{"],[20,"\n","24:\"Hkfm\"|36:177"],[20," \"aggs\" : {"],[20,"\n","24:\"CoGz\"|36:177"],[20," \"JapaneseCars\" : {"],[20,"\n","24:\"NULW\"|36:177"],[20," \"terms\" : {"],[20,"\n","24:\"hMgi\"|36:177"],[20," \"field\" : \"make\","],[20,"\n","24:\"3N7V\"|36:177"],[20," \"include\" : [\"mazda\", \"honda\"]"],[20,"\n","24:\"TJoU\"|36:177"],[20," }"],[20,"\n","24:\"0bim\"|36:177"],[20," },"],[20,"\n","24:\"WVPo\"|36:177"],[20," \"ActiveCarManufacturers\" : {"],[20,"\n","24:\"IYHP\"|36:177"],[20," \"terms\" : {"],[20,"\n","24:\"Ql4g\"|36:177"],[20," \"field\" : \"make\","],[20,"\n","24:\"gcXt\"|36:177"],[20," \"exclude\" : [\"rover\", \"jensen\"]"],[20,"\n","24:\"XyQJ\"|36:177"],[20," }"],[20,"\n","24:\"ukdv\"|36:177"],[20," }"],[20,"\n","24:\"gdet\"|36:177"],[20," }"],[20,"\n","24:\"HFiC\"|36:177"],[20,"}"],[20,"\n","24:\"wknA\"|36:177"],[20,"\n","24:\"bfa5\""],[20," 示例10：根据脚本计算值分组","31:2"],[20,"\n","24:\"YC7C\""],[20,"\n","24:\"7RKV\""],[20,"GET /_search"],[20,"\n","24:\"CvNi\"|36:177"],[20,"{"],[20,"\n","24:\"eRm1\"|36:177"],[20," \"aggs\" : {"],[20,"\n","24:\"tdzc\"|36:177"],[20," \"genres\" : {"],[20,"\n","24:\"UyEl\"|36:177"],[20," \"terms\" : {"],[20,"\n","24:\"X6tk\"|36:177"],[20," \"script\" : {"],[20,"\n","24:\"NIHx\"|36:177"],[20," \"source\": \"doc['genre'].value\","],[20,"\n","24:\"HjY8\"|36:177"],[20," \"lang\": \"painless\""],[20,"\n","24:\"7S0d\"|36:177"],[20," }"],[20,"\n","24:\"Aj7s\"|36:177"],[20," }"],[20,"\n","24:\"GKO4\"|36:177"],[20," }"],[20,"\n","24:\"0PSy\"|36:177"],[20," }"],[20,"\n","24:\"ha9Z\"|36:177"],[20,"}"],[20,"\n","24:\"TU1w\"|36:177"],[20,"\n","24:\"2txU\""],[20," 示例1：缺失值处理","31:2"],[20,"\n","24:\"Z2D7\""],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"ns7T\""],[20,"GET /_search"],[20,"\n","24:\"ySC0\"|36:177"],[20,"{"],[20,"\n","24:\"VBt5\"|36:177"],[20," \"aggs\" : {"],[20,"\n","24:\"bnXm\"|36:177"],[20," \"tags\" : {"],[20,"\n","24:\"aSGK\"|36:177"],[20," \"terms\" : {"],[20,"\n","24:\"ldj4\"|36:177"],[20," \"field\" : \"tags\","],[20,"\n","24:\"MH4D\"|36:177"],[20," \"missing\": \"N/A\" "],[20,"\n","24:\"rMm7\"|36:177"],[20," }"],[20,"\n","24:\"Os9H\"|36:177"],[20," }"],[20,"\n","24:\"Kk0S\"|36:177"],[20," }"],[20,"\n","24:\"iG6T\"|36:177"],[20,"}"],[20,"\n","24:\"INlp\"|36:177"],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20,"\n","24:\"E7dB\""],[20," 结果10：","31:2"],[20,"\n","24:\"KnuF\""],[20,{"gallery":"https://assets.smcdn.cn/docs/assets/paste_error_placeholder-b6c71c3140.png"},"1:\"%23f5f5f5\"|27:\"9\"|29:0|30:0|3:\"auto\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"447\"|ori-width:\"612\""],[20," ","1:\"%23f5f5f5\"|27:\"9\""],[20,"View Code","1:\"%23ffffff\"|27:\"9\""],[20,"\n","24:\"kSZQ\""],[20,"2.  filter Aggregation  对满足过滤查询的文档进行聚合计算","27:\"12\"|31:2"],[20,"\n","24:\"qxGd\"|32:3|linespacing:\"150\""],[20," 在查询命中的文档中选取符合过滤条件的文档进行聚合，先过滤再聚合","31:2"],[20,"\n","24:\"6Bvd\""],[20,"示例1：","31:2"],[20,"\n","24:\"HNuJ\""],[20,"\n","24:\"IFlk\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"xNML\"|36:177"],[20,"{"],[20,"\n","24:\"7I2g\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"yO3L\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"Okvi\"|36:177"],[20," \"filter\": {\"match\":{\"gender\":\"F\"}},"],[20,"\n","24:\"n15j\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"XYvK\"|36:177"],[20," \"avg_age\": {"],[20,"\n","24:\"LoD5\"|36:177"],[20," \"avg\": {"],[20,"\n","24:\"zrjP\"|36:177"],[20," \"field\": \"age\""],[20,"\n","24:\"ejLU\"|36:177"],[20," }"],[20,"\n","24:\"xnIs\"|36:177"],[20," }"],[20,"\n","24:\"kYQc\"|36:177"],[20," }"],[20,"\n","24:\"egvR\"|36:177"],[20," }"],[20,"\n","24:\"Svv9\"|36:177"],[20," }"],[20,"\n","24:\"ma1U\"|36:177"],[20,"}"],[20,"\n","24:\"SoAs\"|36:177"],[20,"\n","24:\"O2rN\""],[20," 结果1：","31:2"],[20,"\n","24:\"sAUP\""],[20,"\n","24:\"6L7K\""],[20,"{"],[20,"\n","24:\"jPRX\"|36:177"],[20," \"took\": 163,"],[20,"\n","24:\"79iU\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"EEHy\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"7GIq\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"a6N9\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"9b1E\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"kE3h\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"I2TW\"|36:177"],[20," },"],[20,"\n","24:\"f0cL\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"SvfJ\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"vSaj\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"GbQ2\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"iKDn\"|36:177"],[20," },"],[20,"\n","24:\"fV67\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"Xs4J\"|36:177"],[20," \"age_terms\": {"],[20,"\n","24:\"bXSG\"|36:177"],[20," \"doc_count\": 493,"],[20,"\n","24:\"kMLr\"|36:177"],[20," \"avg_age\": {"],[20,"\n","24:\"snJA\"|36:177"],[20," \"value\": 30.3184584178499"],[20,"\n","24:\"sggL\"|36:177"],[20," }"],[20,"\n","24:\"BtSP\"|36:177"],[20," }"],[20,"\n","24:\"JIcn\"|36:177"],[20," }"],[20,"\n","24:\"vU0a\"|36:177"],[20,"}"],[20,"\n","24:\"IOuh\"|36:177"],[20,"\n","24:\"Yyng\""],[20," 3. Filters Aggregation  多个过滤组聚合计算","27:\"12\"|31:2"],[20,"\n","24:\"lmeT\"|32:3|linespacing:\"150\""],[20,"示例1：","31:2"],[20,"\n","24:\"W6NA\""],[20," 准备数据：","31:2"],[20,"\n","24:\"yCTU\""],[20,"\n","24:\"hz7v\""],[20,"PUT /logs/_doc/_bulk?refresh"],[20,"\n","24:\"5kYX\"|36:177"],[20,"{\"index\":{\"_id\":1}}"],[20,"\n","24:\"lVzy\"|36:177"],[20,"{\"body\":\"warning: page could not be rendered\"}"],[20,"\n","24:\"ZLPL\"|36:177"],[20,"{\"index\":{\"_id\":2}}"],[20,"\n","24:\"SXJN\"|36:177"],[20,"{\"body\":\"authentication error\"}"],[20,"\n","24:\"F7Ot\"|36:177"],[20,"{\"index\":{\"_id\":3}}"],[20,"\n","24:\"d4gQ\"|36:177"],[20,"{\"body\":\"warning: connection timed out\"}"],[20,"\n","24:\"T42p\"|36:177"],[20,"\n","24:\"drJh\""],[20,"获取组合过滤后聚合的结果：","31:2"],[20,"\n","24:\"Qmc2\""],[20,"\n","24:\"62qr\""],[20,"GET logs/_search"],[20,"\n","24:\"jTnA\"|36:177"],[20,"{"],[20,"\n","24:\"pvCe\"|36:177"],[20," \"size\": 0,"],[20,"\n","24:\"Du8M\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"Zh4b\"|36:177"],[20," \"messages\": {"],[20,"\n","24:\"TKe7\"|36:177"],[20," \"filters\": {"],[20,"\n","24:\"JBPq\"|36:177"],[20," \"filters\": {"],[20,"\n","24:\"9KQF\"|36:177"],[20," \"errors\": {"],[20,"\n","24:\"k8Kv\"|36:177"],[20," \"match\": {"],[20,"\n","24:\"Q9BF\"|36:177"],[20," \"body\": \"error\""],[20,"\n","24:\"QfsY\"|36:177"],[20," }"],[20,"\n","24:\"iT5C\"|36:177"],[20," },"],[20,"\n","24:\"VYpT\"|36:177"],[20," \"warnings\": {"],[20,"\n","24:\"MXGG\"|36:177"],[20," \"match\": {"],[20,"\n","24:\"s0dt\"|36:177"],[20," \"body\": \"warning\""],[20,"\n","24:\"NEJ7\"|36:177"],[20," }"],[20,"\n","24:\"Wpeg\"|36:177"],[20," }"],[20,"\n","24:\"Oi5x\"|36:177"],[20," }"],[20,"\n","24:\"X4Dy\"|36:177"],[20," }"],[20,"\n","24:\"cUWC\"|36:177"],[20," }"],[20,"\n","24:\"5XvM\"|36:177"],[20," }"],[20,"\n","24:\"A89R\"|36:177"],[20,"}"],[20,"\n","24:\"EDO8\"|36:177"],[20,"\n","24:\"Ht0o\""],[20," 上面的结果：","31:2"],[20,"\n","24:\"jS2F\""],[20,"\n","24:\"B9Oi\""],[20,"{"],[20,"\n","24:\"O6d6\"|36:177"],[20," \"took\": 18,"],[20,"\n","24:\"itGc\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"D6AQ\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"AFUT\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"xrKT\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"S1Ho\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"2qdp\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"LoAh\"|36:177"],[20," },"],[20,"\n","24:\"7NYf\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"RWab\"|36:177"],[20," \"total\": 3,"],[20,"\n","24:\"YjmT\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"R2a9\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"x0OC\"|36:177"],[20," },"],[20,"\n","24:\"bmu8\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"5ASz\"|36:177"],[20," \"messages\": {"],[20,"\n","24:\"C2Fs\"|36:177"],[20," \"buckets\": {"],[20,"\n","24:\"Pkmd\"|36:177"],[20," \"errors\": {"],[20,"\n","24:\"F5Jd\"|36:177"],[20," \"doc_count\": 1"],[20,"\n","24:\"ofYs\"|36:177"],[20," },"],[20,"\n","24:\"zJ4T\"|36:177"],[20," \"warnings\": {"],[20,"\n","24:\"fWob\"|36:177"],[20," \"doc_count\": 2"],[20,"\n","24:\"vxgH\"|36:177"],[20," }"],[20,"\n","24:\"xFYq\"|36:177"],[20," }"],[20,"\n","24:\"0Wfj\"|36:177"],[20," }"],[20,"\n","24:\"rYrL\"|36:177"],[20," }"],[20,"\n","24:\"Yuqu\"|36:177"],[20,"}"],[20,"\n","24:\"dnEo\"|36:177"],[20,"\n","24:\"7rNz\""],[20," 示例2：为其他值组指定key","31:2"],[20,"\n","24:\"pw09\""],[20,"\n","24:\"c4wr\""],[20,"GET logs/_search"],[20,"\n","24:\"tXHY\"|36:177"],[20,"{"],[20,"\n","24:\"tibx\"|36:177"],[20," \"size\": 0,"],[20,"\n","24:\"itY0\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"ReF0\"|36:177"],[20," \"messages\": {"],[20,"\n","24:\"23Uh\"|36:177"],[20," \"filters\": {"],[20,"\n","24:\"9kzm\"|36:177"],[20," \"other_bucket_key\": \"other_messages\","],[20,"\n","24:\"9DRY\"|36:177"],[20," \"filters\": {"],[20,"\n","24:\"AdeM\"|36:177"],[20," \"errors\": {"],[20,"\n","24:\"uzqY\"|36:177"],[20," \"match\": {"],[20,"\n","24:\"L4Uq\"|36:177"],[20," \"body\": \"error\""],[20,"\n","24:\"taFg\"|36:177"],[20," }"],[20,"\n","24:\"GAmj\"|36:177"],[20," },"],[20,"\n","24:\"rJJd\"|36:177"],[20," \"warnings\": {"],[20,"\n","24:\"eX6z\"|36:177"],[20," \"match\": {"],[20,"\n","24:\"RNHp\"|36:177"],[20," \"body\": \"warning\""],[20,"\n","24:\"dU3B\"|36:177"],[20," }"],[20,"\n","24:\"A7Vs\"|36:177"],[20," }"],[20,"\n","24:\"8lh9\"|36:177"],[20," }"],[20,"\n","24:\"Xs11\"|36:177"],[20," }"],[20,"\n","24:\"oL2H\"|36:177"],[20," }"],[20,"\n","24:\"NW9k\"|36:177"],[20," }"],[20,"\n","24:\"wnOq\"|36:177"],[20,"}"],[20,"\n","24:\"Jq6L\"|36:177"],[20,"\n","24:\"q5Jc\""],[20," 结果2：","31:2"],[20,"\n","24:\"dOdn\""],[20,"\n","24:\"GfXT\""],[20,"{"],[20,"\n","24:\"wNuy\"|36:177"],[20," \"took\": 5,"],[20,"\n","24:\"rT7j\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"Axbc\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"HBcS\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"Cae3\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"VHwG\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"ya8E\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"sPrT\"|36:177"],[20," },"],[20,"\n","24:\"o66z\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"aX3I\"|36:177"],[20," \"total\": 3,"],[20,"\n","24:\"Zd7Z\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"qK2E\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"vhEu\"|36:177"],[20," },"],[20,"\n","24:\"lvs5\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"AhJZ\"|36:177"],[20," \"messages\": {"],[20,"\n","24:\"dDGf\"|36:177"],[20," \"buckets\": {"],[20,"\n","24:\"7iiQ\"|36:177"],[20," \"errors\": {"],[20,"\n","24:\"olbx\"|36:177"],[20," \"doc_count\": 1"],[20,"\n","24:\"jKRO\"|36:177"],[20," },"],[20,"\n","24:\"VUFm\"|36:177"],[20," \"warnings\": {"],[20,"\n","24:\"X54B\"|36:177"],[20," \"doc_count\": 2"],[20,"\n","24:\"Xw6d\"|36:177"],[20," },"],[20,"\n","24:\"6X3k\"|36:177"],[20," \"other_messages\": {"],[20,"\n","24:\"wWZy\"|36:177"],[20," \"doc_count\": 0"],[20,"\n","24:\"uVm1\"|36:177"],[20," }"],[20,"\n","24:\"8Xy0\"|36:177"],[20," }"],[20,"\n","24:\"uaul\"|36:177"],[20," }"],[20,"\n","24:\"gF2b\"|36:177"],[20," }"],[20,"\n","24:\"SBTf\"|36:177"],[20,"}"],[20,"\n","24:\"NTz1\"|36:177"],[20,"\n","24:\"vFkj\""],[20," 4. Range Aggregation 范围分组聚合","27:\"12\"|31:2"],[20,"\n","24:\"If9j\"|32:3|linespacing:\"150\""],[20," 示例1：","31:2"],[20,"\n","24:\"6WB8\""],[20,"\n","24:\"LnTQ\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"3JyI\"|36:177"],[20,"{"],[20,"\n","24:\"Lxrf\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"wnrb\"|36:177"],[20," \"age_range\": {"],[20,"\n","24:\"t4i6\"|36:177"],[20," \"range\": {"],[20,"\n","24:\"aLHo\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"yoYj\"|36:177"],[20," \"ranges\": ["],[20,"\n","24:\"NJ24\"|36:177"],[20," {"],[20,"\n","24:\"LkMC\"|36:177"],[20," \"to\": 25"],[20,"\n","24:\"f162\"|36:177"],[20," },"],[20,"\n","24:\"ahOI\"|36:177"],[20," {"],[20,"\n","24:\"iRsC\"|36:177"],[20," \"from\": 25,"],[20,"\n","24:\"onpU\"|36:177"],[20," \"to\": 35"],[20,"\n","24:\"we85\"|36:177"],[20," },"],[20,"\n","24:\"gt6a\"|36:177"],[20," {"],[20,"\n","24:\"77lS\"|36:177"],[20," \"from\": 35"],[20,"\n","24:\"YQtG\"|36:177"],[20," }"],[20,"\n","24:\"bozR\"|36:177"],[20," ]"],[20,"\n","24:\"Han4\"|36:177"],[20," },"],[20,"\n","24:\"Bnfq\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"yXzU\"|36:177"],[20," \"bmax\": {"],[20,"\n","24:\"Xx0D\"|36:177"],[20," \"max\": {"],[20,"\n","24:\"xkdf\"|36:177"],[20," \"field\": \"balance\""],[20,"\n","24:\"elH9\"|36:177"],[20," }"],[20,"\n","24:\"RDNw\"|36:177"],[20," }"],[20,"\n","24:\"PzxX\"|36:177"],[20," }"],[20,"\n","24:\"cibP\"|36:177"],[20," }"],[20,"\n","24:\"dh4r\"|36:177"],[20," }"],[20,"\n","24:\"LIZB\"|36:177"],[20,"}"],[20,"\n","24:\"wAbu\"|36:177"],[20,"\n","24:\"g5zK\""],[20," 结果1：","31:2"],[20,"\n","24:\"O7jh\""],[20,"\n","24:\"0RPL\""],[20,"{"],[20,"\n","24:\"drSE\"|36:177"],[20," \"took\": 7,"],[20,"\n","24:\"vYVL\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"qDLA\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"fU5M\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"0sYw\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"UEEz\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"tXVM\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"xcOg\"|36:177"],[20," },"],[20,"\n","24:\"pxqi\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"7oDH\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"x90C\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"9NUj\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"qpwb\"|36:177"],[20," },"],[20,"\n","24:\"ZAtc\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"E7KL\"|36:177"],[20," \"age_range\": {"],[20,"\n","24:\"HbLZ\"|36:177"],[20," \"buckets\": ["],[20,"\n","24:\"x9HA\"|36:177"],[20," {"],[20,"\n","24:\"D0MD\"|36:177"],[20," \"key\": \"*-25.0\","],[20,"\n","24:\"QHu6\"|36:177"],[20," \"to\": 25,"],[20,"\n","24:\"Qdp1\"|36:177"],[20," \"doc_count\": 225,"],[20,"\n","24:\"0kgP\"|36:177"],[20," \"bmax\": {"],[20,"\n","24:\"ClQJ\"|36:177"],[20," \"value\": 49587"],[20,"\n","24:\"jeEI\"|36:177"],[20," }"],[20,"\n","24:\"WKA1\"|36:177"],[20," },"],[20,"\n","24:\"SJ3x\"|36:177"],[20," {"],[20,"\n","24:\"qJt6\"|36:177"],[20," \"key\": \"25.0-35.0\","],[20,"\n","24:\"Hl3A\"|36:177"],[20," \"from\": 25,"],[20,"\n","24:\"sAMj\"|36:177"],[20," \"to\": 35,"],[20,"\n","24:\"p3Ic\"|36:177"],[20," \"doc_count\": 485,"],[20,"\n","24:\"2Sgd\"|36:177"],[20," \"bmax\": {"],[20,"\n","24:\"Z1HX\"|36:177"],[20," \"value\": 49795"],[20,"\n","24:\"frwT\"|36:177"],[20," }"],[20,"\n","24:\"Ov1M\"|36:177"],[20," },"],[20,"\n","24:\"mXBK\"|36:177"],[20," {"],[20,"\n","24:\"Tii2\"|36:177"],[20," \"key\": \"35.0-*\","],[20,"\n","24:\"rHg1\"|36:177"],[20," \"from\": 35,"],[20,"\n","24:\"yn96\"|36:177"],[20," \"doc_count\": 290,"],[20,"\n","24:\"Ciit\"|36:177"],[20," \"bmax\": {"],[20,"\n","24:\"OHnZ\"|36:177"],[20," \"value\": 49989"],[20,"\n","24:\"Wmhk\"|36:177"],[20," }"],[20,"\n","24:\"rfLu\"|36:177"],[20," }"],[20,"\n","24:\"9tzw\"|36:177"],[20," ]"],[20,"\n","24:\"W7VT\"|36:177"],[20," }"],[20,"\n","24:\"FpUA\"|36:177"],[20," }"],[20,"\n","24:\"oEaI\"|36:177"],[20,"}"],[20,"\n","24:\"WDl5\"|36:177"],[20,"\n","24:\"cMjE\""],[20,"示例2：为组指定key","31:2"],[20,"\n","24:\"NJrb\""],[20,"\n","24:\"MeNX\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"r7nT\"|36:177"],[20,"{"],[20,"\n","24:\"SAyl\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"pXma\"|36:177"],[20," \"age_range\": {"],[20,"\n","24:\"UmgN\"|36:177"],[20," \"range\": {"],[20,"\n","24:\"Jguz\"|36:177"],[20," \"field\": \"age\","],[20,"\n","24:\"fwAW\"|36:177"],[20," \"keyed\": true,"],[20,"\n","24:\"RLep\"|36:177"],[20," \"ranges\": ["],[20,"\n","24:\"gbGq\"|36:177"],[20," {"],[20,"\n","24:\"Fbrk\"|36:177"],[20," \"to\": 25,"],[20,"\n","24:\"8Vnn\"|36:177"],[20," \"key\": \"Ld\""],[20,"\n","24:\"deM9\"|36:177"],[20," },"],[20,"\n","24:\"puIW\"|36:177"],[20," {"],[20,"\n","24:\"7Bb3\"|36:177"],[20," \"from\": 25,"],[20,"\n","24:\"n7VL\"|36:177"],[20," \"to\": 35,"],[20,"\n","24:\"jZ2w\"|36:177"],[20," \"key\": \"Md\""],[20,"\n","24:\"MS1G\"|36:177"],[20," },"],[20,"\n","24:\"sEgU\"|36:177"],[20," {"],[20,"\n","24:\"jQLH\"|36:177"],[20," \"from\": 35,"],[20,"\n","24:\"c0Ax\"|36:177"],[20," \"key\": \"Od\""],[20,"\n","24:\"DTLY\"|36:177"],[20," }"],[20,"\n","24:\"sfI2\"|36:177"],[20," ]"],[20,"\n","24:\"IV2f\"|36:177"],[20," }"],[20,"\n","24:\"ZVkr\"|36:177"],[20," }"],[20,"\n","24:\"tF6r\"|36:177"],[20," }"],[20,"\n","24:\"vLO6\"|36:177"],[20,"}"],[20,"\n","24:\"ciea\"|36:177"],[20,"\n","24:\"IOfB\""],[20,"结果2：","31:2"],[20,"\n","24:\"omxH\""],[20,"\n","24:\"SsXo\""],[20,"{"],[20,"\n","24:\"Cdd7\"|36:177"],[20," \"took\": 2,"],[20,"\n","24:\"rVwy\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"Hfa4\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"WdaX\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"hj4K\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"iDKm\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"NJVX\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"kvK9\"|36:177"],[20," },"],[20,"\n","24:\"T3Hu\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"xXGJ\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"o067\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"DP7m\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"IRZx\"|36:177"],[20," },"],[20,"\n","24:\"0RyD\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"dWop\"|36:177"],[20," \"age_range\": {"],[20,"\n","24:\"aTZ3\"|36:177"],[20," \"buckets\": {"],[20,"\n","24:\"hWHf\"|36:177"],[20," \"Ld\": {"],[20,"\n","24:\"81at\"|36:177"],[20," \"to\": 25,"],[20,"\n","24:\"31IT\"|36:177"],[20," \"doc_count\": 225"],[20,"\n","24:\"z7N4\"|36:177"],[20," },"],[20,"\n","24:\"gPgb\"|36:177"],[20," \"Md\": {"],[20,"\n","24:\"sqpg\"|36:177"],[20," \"from\": 25,"],[20,"\n","24:\"EbK5\"|36:177"],[20," \"to\": 35,"],[20,"\n","24:\"mdJ1\"|36:177"],[20," \"doc_count\": 485"],[20,"\n","24:\"oDm9\"|36:177"],[20," },"],[20,"\n","24:\"Q4Xg\"|36:177"],[20," \"Od\": {"],[20,"\n","24:\"cQqq\"|36:177"],[20," \"from\": 35,"],[20,"\n","24:\"NOg8\"|36:177"],[20," \"doc_count\": 290"],[20,"\n","24:\"biDh\"|36:177"],[20," }"],[20,"\n","24:\"Jwcw\"|36:177"],[20," }"],[20,"\n","24:\"kmcP\"|36:177"],[20," }"],[20,"\n","24:\"dA2Z\"|36:177"],[20," }"],[20,"\n","24:\"yYdk\"|36:177"],[20,"}"],[20,"\n","24:\"fwpn\"|36:177"],[20,"\n","24:\"HQFp\""],[20,"5. Date Range Aggregation  时间范围分组聚合","27:\"12\"|31:2"],[20,"\n","24:\"pHTo\"|32:3|linespacing:\"150\""],[20,"示例1：","31:2"],[20,"\n","24:\"Py0D\""],[20,"from 时间戳 - to 时间戳 的doc文档数","31:2"],[20,"\n","24:\"23pY\""],[20,"GET hot_sentence/_search?size=0"],[20,"\n","24:\"4BpN\"|36:177"],[20,"{"],[20,"\n","24:\"E91V\"|36:177"],[20,"  \"aggs\": {"],[20,"\n","24:\"u5ov\"|36:177"],[20,"    \"create_time_range\": {"],[20,"\n","24:\"ra5W\"|36:177"],[20,"      \"date_range\": {"],[20,"\n","24:\"cjST\"|36:177"],[20,"        \"field\": \"create_time\","],[20,"\n","24:\"wum2\"|36:177"],[20,"        \"ranges\": ["],[20,"\n","24:\"RqMc\"|36:177"],[20,"          {"],[20,"\n","24:\"l8jl\"|36:177"],[20,"            \"to\": 1606892400,"],[20,"\n","24:\"zFEX\"|36:177"],[20,"            \"from\": 0"],[20,"\n","24:\"VSqv\"|36:177"],[20,"          },"],[20,"\n","24:\"aiRg\"|36:177"],[20,"          {"],[20,"\n","24:\"0roy\"|36:177"],[20,"            \"from\": 1606892400,"],[20,"\n","24:\"JgDs\"|36:177"],[20,"            \"to\": 1606892401"],[20,"\n","24:\"Pso5\"|36:177"],[20,"          }"],[20,"\n","24:\"elA5\"|36:177"],[20,"        ]"],[20,"\n","24:\"jCCE\"|36:177"],[20,"      }"],[20,"\n","24:\"2c5J\"|36:177"],[20,"    }"],[20,"\n","24:\"tdAb\"|36:177"],[20,"  }"],[20,"\n","24:\"YQMH\"|36:177"],[20,"}"],[20,"\n","24:\"rROc\"|36:177"],[20,"\n","24:\"pLfo\"|36:177"],[20,"\n","24:\"xxNy\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"Gzcr\"|36:177"],[20,"{"],[20,"\n","24:\"RW6U\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"KsCt\"|36:177"],[20," \"range\": {"],[20,"\n","24:\"IHWc\"|36:177"],[20," \"date_range\": {"],[20,"\n","24:\"Ajwa\"|36:177"],[20," \"field\": \"date\","],[20,"\n","24:\"Kjrh\"|36:177"],[20," \"format\": \"MM-yyy\","],[20,"\n","24:\"dVCY\"|36:177"],[20," \"ranges\": ["],[20,"\n","24:\"dgz9\"|36:177"],[20," {"],[20,"\n","24:\"VnL9\"|36:177"],[20," \"to\": \"now-1d/d\""],[20,"\n","24:\"cRVe\"|36:177"],[20," },"],[20,"\n","24:\"WBET\"|36:177"],[20," {"],[20,"\n","24:\"9Rjp\"|36:177"],[20," \"from\": \"now-1d/d\""],[20,"\n","24:\"86i3\"|36:177"],[20," }"],[20,"\n","24:\"O1Wd\"|36:177"],[20," ]"],[20,"\n","24:\"aTLw\"|36:177"],[20," }"],[20,"\n","24:\"2AoR\"|36:177"],[20," }"],[20,"\n","24:\"OZKE\"|36:177"],[20," }"],[20,"\n","24:\"MHBT\"|36:177"],[20,"}"],[20,"\n","24:\"7TbP\"|36:177"],[20,"\n","24:\"TT64\""],[20,"结果1：","31:2"],[20,"\n","24:\"ZcBx\""],[20,"\n","24:\"Aswi\""],[20,"{"],[20,"\n","24:\"JeSf\"|36:177"],[20," \"took\": 115,"],[20,"\n","24:\"dx8w\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"HEB0\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"5Xql\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"AM1J\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"PkP7\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"2u2a\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"wgBe\"|36:177"],[20," },"],[20,"\n","24:\"8Lyh\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"8f8J\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"68lQ\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"PD85\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"cfT1\"|36:177"],[20," },"],[20,"\n","24:\"lz72\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"YM1N\"|36:177"],[20," \"range\": {"],[20,"\n","24:\"F5Kw\"|36:177"],[20," \"buckets\": ["],[20,"\n","24:\"v0DE\"|36:177"],[20," {"],[20,"\n","24:\"Eryx\"|36:177"],[20," \"key\": \"*-2017-08-01T00:00:00.000Z\","],[20,"\n","24:\"4eZS\"|36:177"],[20," \"to\": 1501545600000,"],[20,"\n","24:\"AbYi\"|36:177"],[20," \"to_as_string\": \"2017-08-01T00:00:00.000Z\","],[20,"\n","24:\"2jCJ\"|36:177"],[20," \"doc_count\": 0"],[20,"\n","24:\"qvPn\"|36:177"],[20," },"],[20,"\n","24:\"rRuj\"|36:177"],[20," {"],[20,"\n","24:\"zcCa\"|36:177"],[20," \"key\": \"2017-08-01T00:00:00.000Z-*\","],[20,"\n","24:\"qNvQ\"|36:177"],[20," \"from\": 1501545600000,"],[20,"\n","24:\"w1Y6\"|36:177"],[20," \"from_as_string\": \"2017-08-01T00:00:00.000Z\","],[20,"\n","24:\"mxbD\"|36:177"],[20," \"doc_count\": 0"],[20,"\n","24:\"U4zR\"|36:177"],[20," }"],[20,"\n","24:\"6bG5\"|36:177"],[20," ]"],[20,"\n","24:\"oQnM\"|36:177"],[20," }"],[20,"\n","24:\"OF32\"|36:177"],[20," }"],[20,"\n","24:\"xk4n\"|36:177"],[20,"}"],[20,"\n","24:\"M7XR\"|36:177"],[20,"6. Date Histogram Aggregation  时间直方图(柱状)聚合","27:\"12\"|31:2"],[20,"\n","24:\"5pEh\"|32:3|linespacing:\"150\""],[20,"就是按天、月、年等进行聚合统计。可按 year (1y), quarter (1q), month (1M), week (1w), day (1d), hour (1h), minute (1m), second (1s) 间隔聚合或指定的时间间隔聚合。","31:2"],[20,"\n","24:\"ndh5\""],[20,"示例1：","31:2"],[20,"\n","24:\"0XrP\""],[20,"calendar_interval","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20," 和","1:\"%23fbfbfb\"|27:\"12\"|31:2"],[20,"fixed_interval","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,"\n","24:\"v8v6\""],[20,"\n","24:\"V3HU\""],[20,"calendar_interval","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20," "],[20,"\n","24:\"gCU8\""],[20,"minute","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,", ","31:2"],[20,"1m","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,"\n","24:\"nOLZ\""],[20,"All minutes begin at 00 seconds. One minute is the interval between 00 seconds of the first minute and 00 seconds of the following minute in the specified time zone, compensating for any intervening leap seconds, so that the number of minutes and seconds past the hour is the same at the start and end.","31:2"],[20,"\n","24:\"M5fF\""],[20,"hour","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,", ","31:2"],[20,"1h","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,"\n","24:\"bO73\""],[20,"All hours begin at 00 minutes and 00 seconds. One hour (1h) is the interval between 00:00 minutes of the first hour and 00:00 minutes of the following hour in the specified time zone, compensating for any intervening leap seconds, so that the number of minutes and seconds past the hour is the same at the start and end.","31:2"],[20,"\n","24:\"JTGr\""],[20,"day","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,", ","31:2"],[20,"1d","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,"\n","24:\"acS7\""],[20,"All days begin at the earliest possible time, which is usually 00:00:00 (midnight). One day (1d) is the interval between the start of the day and the start of of the following day in the specified time zone, compensating for any intervening time changes.","31:2"],[20,"\n","24:\"k0WT\""],[20,"week","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,", ","31:2"],[20,"1w","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,"\n","24:\"iJ0k\""],[20,"One week is the interval between the start day_of_week:hour:minute:second and the same day of the week and time of the following week in the specified time zone.","31:2"],[20,"\n","24:\"fNxW\""],[20,"month","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,", ","31:2"],[20,"1M","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,"\n","24:\"RWgt\""],[20,"One month is the interval between the start day of the month and time of day and the same day of the month and time of the following month in the specified time zone, so that the day of the month and time of day are the same at the start and end.","31:2"],[20,"\n","24:\"axRp\""],[20,"quarter","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,", ","31:2"],[20,"1q","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,"\n","24:\"GAg7\""],[20,"One quarter is the interval between the start day of the month and time of day and the same day of the month and time of day three months later, so that the day of the month and time of day are the same at the start and end.","31:2"],[20,"\n","24:\"U4m5\""],[20,"year","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,", ","31:2"],[20,"1y","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,"\n","24:\"OyBI\""],[20,"One year is the interval between the start day of the month and time of day and the same day of the month and time of day the following year in the specified time zone, so that the date and time are the same at the start and end.","31:2"],[20,"\n","24:\"vRum\""],[20," "],[20,"\n","24:\"0R8U\""],[20,"fixed_interval","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20," "],[20,"\n","24:\"R4Tu\""],[20," "],[20,"milliseconds (","31:2|8:1"],[20,"ms","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,")","31:2"],[20,"\n","24:\"XXbX\""],[20,"A single millisecond. This is a very, very small interval.","31:2"],[20,"\n","24:\"LBbr\""],[20,"seconds (","31:2|8:1"],[20,"s","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,")","31:2"],[20,"\n","24:\"BDkF\""],[20,"Defined as 1000 milliseconds each.","31:2"],[20,"\n","24:\"rwIU\""],[20,"minutes (","31:2|8:1"],[20,"m","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,")","31:2"],[20,"\n","24:\"KvAg\""],[20,"Defined as 60 seconds each (60,000 milliseconds). All minutes begin at 00 seconds.","31:2"],[20,"\n","24:\"afLJ\""],[20,"hours (","31:2|8:1"],[20,"h","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,")","31:2"],[20,"\n","24:\"cmdw\""],[20,"Defined as 60 minutes each (3,600,000 milliseconds). All hours begin at 00 minutes and 00 seconds.","31:2"],[20,"\n","24:\"B5Bb\""],[20,"days (","31:2|8:1"],[20,"d","0:\"%23555555\"|1:\"%23f8f8f8\"|27:\"12\"|31:2|code:true"],[20,")","31:2"],[20,"\n","24:\"MFVo\""],[20,"Defined as 24 hours (86,400,000 milliseconds). All days begin at the earliest possible time, which is usually 00:00:00 (midnight).","31:2"],[20,"\n","24:\"gCOw\""],[20," "],[20,"\n","24:\"Nq7v\""],[20,"\n","24:\"oqXS\""],[20,"GET hot_sentence/_search?size=0"],[20,"\n","24:\"2jRM\"|36:177"],[20,"{"],[20,"\n","24:\"F9Zt\"|36:177"],[20,"  \"aggs\": {"],[20,"\n","24:\"Ml5J\"|36:177"],[20,"    \"create_time_dh\": {"],[20,"\n","24:\"i09P\"|36:177"],[20,"      \"date_histogram\": {"],[20,"\n","24:\"tQ83\"|36:177"],[20,"        \"field\": \"create_time\","],[20,"\n","24:\"DMOB\"|36:177"],[20,"        \"fixed_interval\": \"30s\""],[20,"\n","24:\"bIpB\"|36:177"],[20,"      }"],[20,"\n","24:\"7MSM\"|36:177"],[20,"    }"],[20,"\n","24:\"3sRV\"|36:177"],[20,"  }"],[20,"\n","24:\"ptU1\"|36:177"],[20,"}"],[20,"\n","24:\"R7jf\"|36:177"],[20,"\n","24:\"ThMw\"|36:177"],[20,"GET hot_sentence/_search?size=0"],[20,"\n","24:\"P9P1\"|36:177"],[20,"{"],[20,"\n","24:\"a0ba\"|36:177"],[20,"  \"aggs\": {"],[20,"\n","24:\"pgQ3\"|36:177"],[20,"    \"create_time_dh\": {"],[20,"\n","24:\"35F2\"|36:177"],[20,"      \"date_histogram\": {"],[20,"\n","24:\"DdVJ\"|36:177"],[20,"        \"field\": \"create_time\","],[20,"\n","24:\"XMCt\"|36:177"],[20,"        \"calendar_interval\": \"1d\""],[20,"\n","24:\"iv1l\"|36:177"],[20,"      }"],[20,"\n","24:\"D1Nj\"|36:177"],[20,"    }"],[20,"\n","24:\"lr1i\"|36:177"],[20,"  }"],[20,"\n","24:\"APoO\"|36:177"],[20,"}"],[20,"\n","24:\"hhu9\"|36:177"],[20,"\n","24:\"q49Q\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"w7B4\"|36:177"],[20,"{"],[20,"\n","24:\"OYAb\"|36:177"],[20," \"aggs\": {"],[20,"\n","24:\"LO22\"|36:177"],[20," \"sales_over_time\": {"],[20,"\n","24:\"N5SZ\"|36:177"],[20," \"date_histogram\": {"],[20,"\n","24:\"xZXU\"|36:177"],[20," \"field\": \"date\","],[20,"\n","24:\"8YaI\"|36:177"],[20," \"interval\": \"month\""],[20,"\n","24:\"kopT\"|36:177"],[20," }"],[20,"\n","24:\"lrHy\"|36:177"],[20," }"],[20,"\n","24:\"niw2\"|36:177"],[20," }"],[20,"\n","24:\"DS87\"|36:177"],[20,"}"],[20,"\n","24:\"39Hp\"|36:177"],[20,"\n","24:\"LI8p\""],[20,"结果1：","31:2"],[20,"\n","24:\"avs2\""],[20,"\n","24:\"7UYz\""],[20,"{"],[20,"\n","24:\"t8ON\"|36:177"],[20," \"took\": 9,"],[20,"\n","24:\"uvpr\"|36:177"],[20," \"timed_out\": false,"],[20,"\n","24:\"HnKo\"|36:177"],[20," \"_shards\": {"],[20,"\n","24:\"qNzk\"|36:177"],[20," \"total\": 5,"],[20,"\n","24:\"Cvhh\"|36:177"],[20," \"successful\": 5,"],[20,"\n","24:\"aM7N\"|36:177"],[20," \"skipped\": 0,"],[20,"\n","24:\"F5bS\"|36:177"],[20," \"failed\": 0"],[20,"\n","24:\"z3Fq\"|36:177"],[20," },"],[20,"\n","24:\"Ib7y\"|36:177"],[20," \"hits\": {"],[20,"\n","24:\"3OEQ\"|36:177"],[20," \"total\": 1000,"],[20,"\n","24:\"sKWQ\"|36:177"],[20," \"max_score\": 0,"],[20,"\n","24:\"Y62n\"|36:177"],[20," \"hits\": []"],[20,"\n","24:\"113V\"|36:177"],[20," },"],[20,"\n","24:\"bnAW\"|36:177"],[20," \"aggregations\": {"],[20,"\n","24:\"6KXT\"|36:177"],[20," \"sales_over_time\": {"],[20,"\n","24:\"tBe1\"|36:177"],[20," \"buckets\": []"],[20,"\n","24:\"h9ij\"|36:177"],[20," }"],[20,"\n","24:\"4VLk\"|36:177"],[20," }"],[20,"\n","24:\"AT5a\"|36:177"],[20,"}"],[20,"\n","24:\"oGZa\"|36:177"],[20,"\n","24:\"Pmsg\""],[20,"7. Missing Aggregation  缺失值的桶聚合","27:\"12\"|31:2"],[20,"\n","24:\"xKDx\"|32:3|linespacing:\"150\""],[20,"\n","24:\"m8wk\""],[20,"POST /bank/_search?size=0"],[20,"\n","24:\"NZdH\"|36:177"],[20,"{"],[20,"\n","24:\"w2uo\"|36:177"],[20," \"aggs\" : {"],[20,"\n","24:\"S0L4\"|36:177"],[20," \"account_without_a_age\" : {"],[20,"\n","24:\"njqK\"|36:177"],[20," \"missing\" : { \"field\" : \"age\" }"],[20,"\n","24:\"amPn\"|36:177"],[20," }"],[20,"\n","24:\"8IXn\"|36:177"],[20," }"],[20,"\n","24:\"Fk5q\"|36:177"],[20,"}"],[20,"\n","24:\"mbbq\"|36:177"],[20,"\n","24:\"ZDco\""],[20,"8. Geo Distance Aggregation  地理距离分区聚合","27:\"12\"|31:2"],[20,"\n","24:\"sSjO\"|32:3|linespacing:\"150\""],[20,"参考官网链接：","31:2"],[20,"\n","24:\"YfGi\""],[20,"https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-geodistance-aggregation.html","16:\"https%3A%2F%2Fwww.elastic.co%2Fguide%2Fen%2Felasticsearch%2Freference%2Fcurrent%2Fsearch-aggregations-bucket-geodistance-aggregation.html\"|31:2"],[20,"\n","24:\"init\""],[20,"\n","24:\"vpIX\""],[20,"聚合","27:\"22\"|31:2|8:1"],[20,"\n","24:\"Cjbe\"|32:1|linespacing:\"115\""],[20,"聚合分析主要分为以下四类","27:\"12\""],[20,"\n","24:\"2mBs\"|linespacing:\"150\""],[20,"Bucket，分桶类型，类似于group by，按照一定的规则将文档分配到不同的桶中，以达到分类分析的目的","27:\"12\""],[20,"\n","24:\"6Wzn\"|linespacing:\"150\""],[20,"Terms根据term分桶，如果是text类型，则按照分词后的结果分桶","27:\"12\""],[20,"\n","24:\"OxuN\"|linespacing:\"150\""],[20,"range(指定数值范围来设置分桶)","27:\"12\""],[20,"\n","24:\"QNwj\"|linespacing:\"150\""],[20,"data range(指定日期的范围)","27:\"12\""],[20,"\n","24:\"sCvJ\"|linespacing:\"150\""],[20,"histogram(以固定间隔的策略分割)","27:\"12\""],[20,"\n","24:\"tGWN\"|linespacing:\"150\""],[20,"date histogram(针对日期)","27:\"12\""],[20,"\n","24:\"Zaj0\"|linespacing:\"150\""],[20,"Metric，指标分析类型，如最大值、最小值、平均值等等","27:\"12\""],[20,"\n","24:\"irt6\"|linespacing:\"150\""],[20,"单值分析 min、max、avg、sum、cardinality(distinct count)","27:\"12\""],[20,"\n","24:\"Xqcp\"|linespacing:\"150\""],[20,"多值分析 stats,extended stats percentile(百分位数) percentile rank top hits","27:\"12\""],[20,"\n","24:\"OHne\"|linespacing:\"150\""],[20,"Pipeline,管道分析类型，基于上一级的聚合分析结果","27:\"12\""],[20,"\n","24:\"KNAC\"|linespacing:\"150\""],[20,"Parent结果内嵌到现有的聚合分析结果","27:\"12\""],[20,"\n","24:\"q0NS\"|linespacing:\"150\""],[20,"Sibling结果与现有聚合分析结果同级","27:\"12\""],[20,"\n","24:\"luhR\"|linespacing:\"150\""],[20,"Matrix,矩阵分析类型","27:\"12\""],[20,"\n","24:\"n4Sr\"|linespacing:\"150\""],[20,"语法","27:\"12\""],[20,"\n","24:\"Ehnw\"|linespacing:\"150\""],[20,"aggs->聚合名字->聚合类型->聚合内容","27:\"12\""],[20,"\n","24:\"lJ8A\"|linespacing:\"150\""],[20,"下面看一下聚合,聚合这里要注意一个点，如果对text类型的字段进行聚合时，要先把该字段设为fielddata:true，具体","27:\"12\""],[20,"请看","0:\"%236795b5\"|16:\"https%3A%2F%2Fwww.elastic.co%2Fguide%2Fen%2Felasticsearch%2Freference%2Fcurrent%2Ffielddata.html\"|27:\"12\""]]">

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations.html

GET hot_sentence/_search?size=0
{
  "aggs": {
    "create_time_dh": {
      "date_histogram": {
        "order": {
          "avg_age": "asc"
        },
        "field": "create_time",
        "fixed_interval": "30s"
      },
      "aggs": {
        "avg_age": {
          "avg": {
            "field": "hot_level"
          }
        }
      }
    }
  }
}

elasticsearch系列六：聚合分析(聚合分析简介、指标聚合、桶聚合)

一、聚合分析简介

 1. ES聚合分析是什么？

聚合分析是数据库中重要的功能特性，完成对一个查询的数据集中数据的聚合计算，如：找出某字段(或计算表达式的结果)的最大值、最小值，计算和、平均值等。ES作为搜索引擎兼数据库，同样提供了强大的聚合分析能力。

对一个数据集求最大、最小、和、平均值等指标的聚合，在ES中称为指标聚合   metric

而关系型数据库中除了有聚合函数外，还可以对查询出的数据进行分组group by，再在组上进行指标聚合。在 ES 中group by 称为分桶，桶聚合 bucketing

ES中还提供了矩阵聚合(matrix)、管道聚合(pipleline)，但还在完善中。 

 2. ES聚合分析查询的写法

 在查询请求体中以aggregations节点按如下语法定义聚合分析：

"aggregations" : {
    "" : { 
        "" : { 
        }
        [,"meta" : {  [] } ]? 
        [,"aggregations" : { []+ } ]? 
    }
    [,"" : { ... } ]*
}

 说明：

aggregations 也可简写为 aggs

 3. 聚合分析的值来源

聚合计算的值可以取字段的值，也可是脚本计算的结果。

二、指标聚合

1. max min sum avg

示例1：查询所有客户中余额的最大值

POST /bank/_search?
{
  "size": 0, 
  "aggs": {
    "masssbalance": {
      "max": {
        "field": "balance"
      }
    }
  }
}

 结果1：

{
  "took": 2080,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "masssbalance": {
      "value": 49989
    }
  }
}

示例2：查询年龄为24岁的客户中的余额最大值

POST /bank/_search?
{
  "size": 2, 
  "query": {
    "match": {
      "age": 24
    }
  },
  "sort": [
    {
      "balance": {
        "order": "desc"
      }
    }
  ],
  "aggs": {
    "max_balance": {
      "max": {
        "field": "balance"
      }
    }
  }
}

 结果2：

{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 42,
    "max_score": null,
    "hits": [
      {
        "_index": "bank",
        "_type": "_doc",
        "_id": "697",
        "_score": null,
        "_source": {
          "account_number": 697,
          "balance": 48745,
          "firstname": "Mallory",
          "lastname": "Emerson",
          "age": 24,
          "gender": "F",
          "address": "318 Dunne Court",
          "employer": "Exoplode",
          "email": "malloryemerson@exoplode.com",
          "city": "Montura",
          "state": "LA"
        },
        "sort": [
          48745
        ]
      },
      {
        "_index": "bank",
        "_type": "_doc",
        "_id": "917",
        "_score": null,
        "_source": {
          "account_number": 917,
          "balance": 47782,
          "firstname": "Parks",
          "lastname": "Hurst",
          "age": 24,
          "gender": "M",
          "address": "933 Cozine Avenue",
          "employer": "Pyramis",
          "email": "parkshurst@pyramis.com",
          "city": "Lindcove",
          "state": "GA"
        },
        "sort": [
          47782
        ]
      }
    ]
  },
  "aggregations": {
    "max_balance": {
      "value": 48745
    }
  }
}

 示例3：值来源于脚本，查询所有客户的平均年龄是多少，并对平均年龄加10

POST /bank/_search?size=0
{
  "aggs": {
    "avg_age": {
      "avg": {
        "script": {
          "source": "doc.age.value"
        }
      }
    },
    "avg_age10": {
      "avg": {
        "script": {
          "source": "doc.age.value + 10"
        }
      }
    }
  }
}

 结果3：

{
  "took": 86,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "avg_age": {
      "value": 30.171
    },
    "avg_age10": {
      "value": 40.171
    }
  }
}

 示例4：指定field，在脚本中用_value 取字段的值

POST /bank/_search?size=0
{
  "aggs": {
    "sum_balance": {
      "sum": {
        "field": "balance",
        "script": {
            "source": "_value * 1.03"
        }
      }
    }
  }
}

 结果4：

{
  "took": 165,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "sum_balance": {
      "value": 26486282.11
    }
  }
}

 示例5：为没有值字段指定值。如未指定，缺失该字段值的文档将被忽略。

POST /bank/_search?size=0
{
  "aggs": {
    "avg_age": {
      "avg": {
        "field": "age",
        "missing": 18
      }
    }
  }
}

 2. 文档计数 count

 示例1：统计银行索引bank下年龄为24的文档数量

POST /bank/_doc/_count
{
  "query": {
    "match": {
      "age" : 24
    }
  }
}

 结果1：

{
  "count": 42,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  }
}

 3. Value count 统计某字段有值的文档数

示例1：

POST /bank/_search?size=0
{
  "aggs": {
    "age_count": {
      "value_count": {
        "field": "age"
      }
    }
  }
}

 结果1：

{
  "took": 2022,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_count": {
      "value": 1000
    }
  }
}

 4. cardinality  值去重计数

示例1

POST /bank/_search?size=0
{
  "aggs": {
    "age_count": {
      "cardinality": {
        "field": "age"
      }
    },
    "state_count": {
      "cardinality": {
        "field": "state.keyword"
      }
    }
  }
}

 说明：state的使用它的keyword版

 结果1：

{
  "took": 2074,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "state_count": {
      "value": 51
    },
    "age_count": {
      "value": 21
    }
  }
}

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

 示例1：

POST /bank/_search?size=0
{
  "aggs": {
    "age_stats": {
      "stats": {
        "field": "age"
      }
    }
  }
}

             

 结果1：

             

{
  "took": 7,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_stats": {
      "count": 1000,
      "min": 20,
      "max": 40,
      "avg": 30.171,
      "sum": 30171
    }
  }
}

             

 6. Extended stats

高级统计，比stats多4个统计结果：平方和、方差、标准差、平均值加/减两个标准差的区间

 示例1：

             

POST /bank/_search?size=0
{
  "aggs": {
    "age_stats": {
      "extended_stats": {
        "field": "age"
      }
    }
  }
}

             

 结果1：

             

{
  "took": 7,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_stats": {
      "count": 1000,
      "min": 20,
      "max": 40,
      "avg": 30.171,
      "sum": 30171,
      "sum_of_squares": 946393,
      "variance": 36.10375899999996,
      "std_deviation": 6.008640362012022,
      "std_deviation_bounds": {
        "upper": 42.18828072402404,
        "lower": 18.153719275975956
      }
    }
  }
}

             

 7. Percentiles 占比百分位对应的值统计

对指定字段(脚本)的值按从小到大累计每个值对应的文档数的占比(占所有命中文档数的百分比)，返回指定占比比例对应的值。默认返回[ 1, 5, 25, 50, 75, 95, 99 ]分位上的值。如下中间的结果，可以理解为：占比为50%的文档的age值 <= 31，或反过来：age<=31的文档数占总命中文档数的50%

 示例1：

             

POST /bank/_search?size=0
{
  "aggs": {
    "age_percents": {
      "percentiles": {
        "field": "age"
      }
    }
  }
}

结果1：

{
  "took": 87,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_percents": {
      "values": {
        "1.0": 20,
        "5.0": 21,
        "25.0": 25,
        "50.0": 31,
        "75.0": 35.00000000000001,
        "95.0": 39,
        "99.0": 40
      }
    }
  }
}

 结果说明:

占比为50%的文档的age值 <= 31，或反过来：age<=31的文档数占总命中文档数的50%

 示例2：指定分位值

POST /bank/_search?size=0
{
  "aggs": {
    "age_percents": {
      "percentiles": {
        "field": "age",
        "percents" : [95, 99, 99.9] 
      }
    }
  }
}

 结果2：

{
  "took": 8,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_percents": {
      "values": {
        "95.0": 39,
        "99.0": 40,
        "99.9": 40
      }
    }
  }
}

 8. Percentiles rank 统计值小于等于指定值的文档占比

 示例1：统计年龄小于25和30的文档的占比，和第7项相反

POST /bank/_search?size=0
{
  "aggs": {
    "gge_perc_rank": {
      "percentile_ranks": {
        "field": "age",
        "values": [
          25,
          30
        ]
      }
    }
  }
}

结果2：

             

{
  "took": 8,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "gge_perc_rank": {
      "values": {
        "25.0": 26.1,
        "30.0": 49.2
      }
    }
  }
}

             

 结果说明：年龄小于25的文档占比为26.1%，年龄小于30的文档占比为49.2%，

 9. Geo Bounds aggregation 求文档集中的地理位置坐标点的范围

参考官网链接：

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-geobounds-aggregation.html

10. Geo Centroid aggregation  求地理位置中心点坐标值

参考官网链接：

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-geocentroid-aggregation.html

三、桶聚合

             

1. Terms Aggregation  根据字段值项分组聚合 

 示例1：

POST /bank/_search?size=0
{
  "aggs": {
    "age_terms": {
      "terms": {
        "field": "age"
      }
    }
  }
}

 结果1：

{
  "took": 2000,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_terms": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 463,
      "buckets": [
        {
          "key": 31,
          "doc_count": 61
        },
        {
          "key": 39,
          "doc_count": 60
        },
        {
          "key": 26,
          "doc_count": 59
        },
        {
          "key": 32,
          "doc_count": 52
        },
        {
          "key": 35,
          "doc_count": 52
        },
        {
          "key": 36,
          "doc_count": 52
        },
        {
          "key": 22,
          "doc_count": 51
        },
        {
          "key": 28,
          "doc_count": 51
        },
        {
          "key": 33,
          "doc_count": 50
        },
        {
          "key": 34,
          "doc_count": 49
        }
      ]
    }
  }
}

 结果说明：

"doc_count_error_upper_bound": 0：文档计数的最大偏差值

"sum_other_doc_count": 463：未返回的其他项的文档数

默认情况下返回按文档计数从高到低的前10个分组：

 "buckets": [
        {
          "key": 31,
          "doc_count": 61
        },
        {
          "key": 39,
          "doc_count": 60
        },
    .............
]

 年龄为31的文档有61个，年龄为39的文档有60个

 size 指定返回多少个分组：

示例2：指定返回20个分组

POST /bank/_search?size=0
{
  "aggs": {
    "age_terms": {
      "terms": {
        "field": "age",
        "size": 20
      }
    }
  }
}

 结果2：

 View Code

 示例3：每个分组上显示偏差值

POST /bank/_search?size=0
{
  "aggs": {
    "age_terms": {
      "terms": {
        "field": "age",
        "size": 5,
        "shard_size": 20,
        "show_term_doc_count_error": true
      }
    }
  }
}

 结果3：

{
  "took": 8,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_terms": {
      "doc_count_error_upper_bound": 25,
      "sum_other_doc_count": 716,
      "buckets": [
        {
          "key": 31,
          "doc_count": 61,
          "doc_count_error_upper_bound": 0
        },
        {
          "key": 39,
          "doc_count": 60,
          "doc_count_error_upper_bound": 0
        },
        {
          "key": 26,
          "doc_count": 59,
          "doc_count_error_upper_bound": 0
        },
        {
          "key": 32,
          "doc_count": 52,
          "doc_count_error_upper_bound": 0
        },
        {
          "key": 36,
          "doc_count": 52,
          "doc_count_error_upper_bound": 0
        }
      ]
    }
  }
}

 示例4：shard_size 指定每个分片上返回多少个分组

shard_size 的默认值为：

索引只有一个分片：= size

多分片：= size * 1.5 + 10

POST /bank/_search?size=0
{
  "aggs": {
    "age_terms": {
      "terms": {
        "field": "age",
        "size": 5,
        "shard_size": 20
      }
    }
  }
}

 结果4：

{
  "took": 8,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_terms": {
      "doc_count_error_upper_bound": 25,
      "sum_other_doc_count": 716,
      "buckets": [
        {
          "key": 31,
          "doc_count": 61
        },
        {
          "key": 39,
          "doc_count": 60
        },
        {
          "key": 26,
          "doc_count": 59
        },
        {
          "key": 32,
          "doc_count": 52
        },
        {
          "key": 36,
          "doc_count": 52
        }
      ]
    }
  }
}

 order  指定分组的排序

 示例5：根据文档计数排序

POST /bank/_search?size=0
{
  "aggs": {
    "age_terms": {
      "terms": {
        "field": "age",
        "order" : { "_count" : "asc" }
      }
    }
  }
}

 结果5：

{
  "took": 3,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_terms": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 584,
      "buckets": [
        {
          "key": 29,
          "doc_count": 35
        },
        {
          "key": 27,
          "doc_count": 39
        },
        {
          "key": 38,
          "doc_count": 39
        },
        {
          "key": 23,
          "doc_count": 42
        },
        {
          "key": 24,
          "doc_count": 42
        },
        {
          "key": 25,
          "doc_count": 42
        },
        {
          "key": 37,
          "doc_count": 42
        },
        {
          "key": 20,
          "doc_count": 44
        },
        {
          "key": 40,
          "doc_count": 45
        },
        {
          "key": 21,
          "doc_count": 46
        }
      ]
    }
  }
}

 示例6：根据分组值排序

POST /bank/_search?size=0
{
  "aggs": {
    "age_terms": {
      "terms": {
        "field": "age",
        "order" : { "_key" : "asc" }
      }
    }
  }
}

 结果6：

{
  "took": 10,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_terms": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 549,
      "buckets": [
        {
          "key": 20,
          "doc_count": 44
        },
        {
          "key": 21,
          "doc_count": 46
        },
        {
          "key": 22,
          "doc_count": 51
        },
        {
          "key": 23,
          "doc_count": 42
        },
        {
          "key": 24,
          "doc_count": 42
        },
        {
          "key": 25,
          "doc_count": 42
        },
        {
          "key": 26,
          "doc_count": 59
        },
        {
          "key": 27,
          "doc_count": 39
        },
        {
          "key": 28,
          "doc_count": 51
        },
        {
          "key": 29,
          "doc_count": 35
        }
      ]
    }
  }
}

示例7：取分组指标值排序

POST /bank/_search?size=0
{
  "aggs": {
    "age_terms": {
      "terms": {
        "field": "age",
        "order": {
          "max_balance": "asc"
        }
      },
      "aggs": {
        "max_balance": {
          "max": {
            "field": "balance"
          }
        },
        "min_balance": {
          "min": {
            "field": "balance"
          }
        }
      }
    }
  }
}

 结果7：

 View Code

 示例8：筛选分组-正则表达式匹配值

GET /_search
{
    "aggs" : {
        "tags" : {
            "terms" : {
                "field" : "tags",
                "include" : ".*sport.*",
                "exclude" : "water_.*"
            }
        }
    }
}

 示例9：筛选分组-指定值列表

GET /_search
{
    "aggs" : {
        "JapaneseCars" : {
             "terms" : {
                 "field" : "make",
                 "include" : ["mazda", "honda"]
             }
         },
        "ActiveCarManufacturers" : {
             "terms" : {
                 "field" : "make",
                 "exclude" : ["rover", "jensen"]
             }
         }
    }
}

 示例10：根据脚本计算值分组

GET /_search
{
    "aggs" : {
        "genres" : {
            "terms" : {
                "script" : {
                    "source": "doc['genre'].value",
                    "lang": "painless"
                }
            }
        }
    }
}

 示例1：缺失值处理

             

GET /_search
{
    "aggs" : {
        "tags" : {
             "terms" : {
                 "field" : "tags",
                 "missing": "N/A" 
             }
         }
    }
}

             

 结果10：

              View Code

2.  filter Aggregation  对满足过滤查询的文档进行聚合计算

 在查询命中的文档中选取符合过滤条件的文档进行聚合，先过滤再聚合

示例1：

POST /bank/_search?size=0
{
  "aggs": {
    "age_terms": {
      "filter": {"match":{"gender":"F"}},
      "aggs": {
        "avg_age": {
          "avg": {
            "field": "age"
          }
        }
      }
    }
  }
}

 结果1：

{
  "took": 163,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_terms": {
      "doc_count": 493,
      "avg_age": {
        "value": 30.3184584178499
      }
    }
  }
}

 3. Filters Aggregation  多个过滤组聚合计算

示例1：

 准备数据：

PUT /logs/_doc/_bulk?refresh
{"index":{"_id":1}}
{"body":"warning: page could not be rendered"}
{"index":{"_id":2}}
{"body":"authentication error"}
{"index":{"_id":3}}
{"body":"warning: connection timed out"}

获取组合过滤后聚合的结果：

GET logs/_search
{
  "size": 0,
  "aggs": {
    "messages": {
      "filters": {
        "filters": {
          "errors": {
            "match": {
              "body": "error"
            }
          },
          "warnings": {
            "match": {
              "body": "warning"
            }
          }
        }
      }
    }
  }
}

 上面的结果：

{
  "took": 18,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 3,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "messages": {
      "buckets": {
        "errors": {
          "doc_count": 1
        },
        "warnings": {
          "doc_count": 2
        }
      }
    }
  }
}

 示例2：为其他值组指定key

GET logs/_search
{
  "size": 0,
  "aggs": {
    "messages": {
      "filters": {
        "other_bucket_key": "other_messages",
        "filters": {
          "errors": {
            "match": {
              "body": "error"
            }
          },
          "warnings": {
            "match": {
              "body": "warning"
            }
          }
        }
      }
    }
  }
}

 结果2：

{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 3,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "messages": {
      "buckets": {
        "errors": {
          "doc_count": 1
        },
        "warnings": {
          "doc_count": 2
        },
        "other_messages": {
          "doc_count": 0
        }
      }
    }
  }
}

 4. Range Aggregation 范围分组聚合

 示例1：

POST /bank/_search?size=0
{
  "aggs": {
    "age_range": {
      "range": {
        "field": "age",
        "ranges": [
          {
            "to": 25
          },
          {
            "from": 25,
            "to": 35
          },
          {
            "from": 35
          }
        ]
      },
      "aggs": {
        "bmax": {
          "max": {
            "field": "balance"
          }
        }
      }
    }
  }
}

 结果1：

{
  "took": 7,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_range": {
      "buckets": [
        {
          "key": "*-25.0",
          "to": 25,
          "doc_count": 225,
          "bmax": {
            "value": 49587
          }
        },
        {
          "key": "25.0-35.0",
          "from": 25,
          "to": 35,
          "doc_count": 485,
          "bmax": {
            "value": 49795
          }
        },
        {
          "key": "35.0-*",
          "from": 35,
          "doc_count": 290,
          "bmax": {
            "value": 49989
          }
        }
      ]
    }
  }
}

示例2：为组指定key

POST /bank/_search?size=0
{
  "aggs": {
    "age_range": {
      "range": {
        "field": "age",
        "keyed": true,
        "ranges": [
          {
            "to": 25,
            "key": "Ld"
          },
          {
            "from": 25,
            "to": 35,
            "key": "Md"
          },
          {
            "from": 35,
            "key": "Od"
          }
        ]
      }
    }
  }
}

结果2：

{
  "took": 2,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "age_range": {
      "buckets": {
        "Ld": {
          "to": 25,
          "doc_count": 225
        },
        "Md": {
          "from": 25,
          "to": 35,
          "doc_count": 485
        },
        "Od": {
          "from": 35,
          "doc_count": 290
        }
      }
    }
  }
}

5. Date Range Aggregation  时间范围分组聚合

示例1：

from 时间戳 - to 时间戳 的doc文档数

GET hot_sentence/_search?size=0
{
  "aggs": {
    "create_time_range": {
      "date_range": {
        "field": "create_time",
        "ranges": [
          {
            "to": 1606892400,
            "from": 0
          },
          {
            "from": 1606892400,
            "to": 1606892401
          }
        ]
      }
    }
  }
}

POST /bank/_search?size=0
{
  "aggs": {
    "range": {
      "date_range": {
        "field": "date",
        "format": "MM-yyy",
        "ranges": [
          {
            "to": "now-1d/d"
          },
          {
            "from": "now-1d/d"
          }
        ]
      }
    }
  }
}

结果1：

{
  "took": 115,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "range": {
      "buckets": [
        {
          "key": "*-2017-08-01T00:00:00.000Z",
          "to": 1501545600000,
          "to_as_string": "2017-08-01T00:00:00.000Z",
          "doc_count": 0
        },
        {
          "key": "2017-08-01T00:00:00.000Z-*",
          "from": 1501545600000,
          "from_as_string": "2017-08-01T00:00:00.000Z",
          "doc_count": 0
        }
      ]
    }
  }
}

6. Date Histogram Aggregation  时间直方图(柱状)聚合

就是按天、月、年等进行聚合统计。可按 year (1y), quarter (1q), month (1M), week (1w), day (1d), hour (1h), minute (1m), second (1s) 间隔聚合或指定的时间间隔聚合。

示例1：

calendar_interval 和fixed_interval

calendar_interval

minute, 1m

All minutes begin at 00 seconds. One minute is the interval between 00 seconds of the first minute and 00 seconds of the following minute in the specified time zone, compensating for any intervening leap seconds, so that the number of minutes and seconds past the hour is the same at the start and end.

hour, 1h

All hours begin at 00 minutes and 00 seconds. One hour (1h) is the interval between 00:00 minutes of the first hour and 00:00 minutes of the following hour in the specified time zone, compensating for any intervening leap seconds, so that the number of minutes and seconds past the hour is the same at the start and end.

day, 1d

All days begin at the earliest possible time, which is usually 00:00:00 (midnight). One day (1d) is the interval between the start of the day and the start of of the following day in the specified time zone, compensating for any intervening time changes.

week, 1w

One week is the interval between the start day_of_week:hour:minute:second and the same day of the week and time of the following week in the specified time zone.

month, 1M

One month is the interval between the start day of the month and time of day and the same day of the month and time of the following month in the specified time zone, so that the day of the month and time of day are the same at the start and end.

quarter, 1q

One quarter is the interval between the start day of the month and time of day and the same day of the month and time of day three months later, so that the day of the month and time of day are the same at the start and end.

year, 1y

One year is the interval between the start day of the month and time of day and the same day of the month and time of day the following year in the specified time zone, so that the date and time are the same at the start and end.

fixed_interval

milliseconds (ms)

A single millisecond. This is a very, very small interval.

seconds (s)

Defined as 1000 milliseconds each.

minutes (m)

Defined as 60 seconds each (60,000 milliseconds). All minutes begin at 00 seconds.

hours (h)

Defined as 60 minutes each (3,600,000 milliseconds). All hours begin at 00 minutes and 00 seconds.

days (d)

Defined as 24 hours (86,400,000 milliseconds). All days begin at the earliest possible time, which is usually 00:00:00 (midnight).

GET hot_sentence/_search?size=0
{
  "aggs": {
    "create_time_dh": {
      "date_histogram": {
        "field": "create_time",
        "fixed_interval": "30s"
      }
    }
  }
}
GET hot_sentence/_search?size=0
{
  "aggs": {
    "create_time_dh": {
      "date_histogram": {
        "field": "create_time",
        "calendar_interval": "1d"
      }
    }
  }
}

POST /bank/_search?size=0
{
  "aggs": {
    "sales_over_time": {
      "date_histogram": {
        "field": "date",
        "interval": "month"
      }
    }
  }
}

结果1：

{
  "took": 9,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1000,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "sales_over_time": {
      "buckets": []
    }
  }
}

7. Missing Aggregation  缺失值的桶聚合

POST /bank/_search?size=0
{
    "aggs" : {
        "account_without_a_age" : {
            "missing" : { "field" : "age" }
        }
    }
}

8. Geo Distance Aggregation  地理距离分区聚合

参考官网链接：

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-geodistance-aggregation.html

聚合

聚合分析主要分为以下四类

Bucket，分桶类型，类似于group by，按照一定的规则将文档分配到不同的桶中，以达到分类分析的目的

Terms根据term分桶，如果是text类型，则按照分词后的结果分桶

range(指定数值范围来设置分桶)

data range(指定日期的范围)

histogram(以固定间隔的策略分割)

date histogram(针对日期)

Metric，指标分析类型，如最大值、最小值、平均值等等

单值分析 min、max、avg、sum、cardinality(distinct count)

多值分析 stats,extended stats percentile(百分位数) percentile rank top hits

Pipeline,管道分析类型，基于上一级的聚合分析结果

Parent结果内嵌到现有的聚合分析结果

Sibling结果与现有聚合分析结果同级

Matrix,矩阵分析类型

语法

aggs->聚合名字->聚合类型->聚合内容

下面看一下聚合,聚合这里要注意一个点，如果对text类型的字段进行聚合时，要先把该字段设为fielddata:true，具体请看

yk