elasticSearch嵌入桶中的学习与实践

 

https://www.elastic.co/guide/cn/elasticsearch/guide/cn/_buckets_inside_buckets.html

 

{
    "size":0,
    "query":{
    },
    "aggregations":{
        "total_count":{
            "terms":{
                "field":"statusId",
                "missing":"-1",
                "size":500,
                "min_doc_count":1,
                "shard_min_doc_count":0,
                "show_term_doc_count_error":false,
                "order":[
                    {
                        "_term":"desc"
                    }
                ]
            },
            "aggregations":{
                "avg_caseId":{
                    "avg":{
                        "field":"caseId"
                    }
                }
            }
        }
    }
}

 

{
  "took": 76,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1649341,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "total_count": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": 125,
          "doc_count": 9,
          "avg_caseId": {
            "value": 1649983.6666666667
          }
        },
        {
          "key": 124,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1647877
          }
        },
        {
          "key": 123,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1650298
          }
        },
        {
          "key": 118,
          "doc_count": 28,
          "avg_caseId": {
            "value": 1620169.1785714286
          }
        },
        {
          "key": 117,
          "doc_count": 10,
          "avg_caseId": {
            "value": 1619273.2
          }
        },
        {
          "key": 115,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1615978
          }
        },
        {
          "key": 109,
          "doc_count": 44,
          "avg_caseId": {
            "value": 1620698.0454545454
          }
        },
        {
          "key": 108,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1615535
          }
        },
        {
          "key": 102,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1615850
          }
        },
        {
          "key": 101,
          "doc_count": 26,
          "avg_caseId": {
            "value": 1615908.0384615385
          }
        },
        {
          "key": 100,
          "doc_count": 32,
          "avg_caseId": {
            "value": 1622660.03125
          }
        },
        {
          "key": 99,
          "doc_count": 17,
          "avg_caseId": {
            "value": 1617725.5882352942
          }
        },
        {
          "key": 98,
          "doc_count": 2,
          "avg_caseId": {
            "value": 1615960
          }
        },
        {
          "key": 97,
          "doc_count": 28,
          "avg_caseId": {
            "value": 1626726.9285714286
          }
        },
        {
          "key": 84,
          "doc_count": 3,
          "avg_caseId": {
            "value": 1620288
          }
        },
        {
          "key": 77,
          "doc_count": 10,
          "avg_caseId": {
            "value": 1616216.3
          }
        },
        {
          "key": 75,
          "doc_count": 7,
          "avg_caseId": {
            "value": 1616354
          }
        },
        {
          "key": 74,
          "doc_count": 3,
          "avg_caseId": {
            "value": 1620221.6666666667
          }
        },
        {
          "key": 73,
          "doc_count": 362,
          "avg_caseId": {
            "value": 1642278.7182320443
          }
        },
        {
          "key": 65,
          "doc_count": 13,
          "avg_caseId": {
            "value": 1639632.7692307692
          }
        },
        {
          "key": 60,
          "doc_count": 197,
          "avg_caseId": {
            "value": 1619859.4771573604
          }
        },
        {
          "key": 58,
          "doc_count": 13,
          "avg_caseId": {
            "value": 1634659.6153846155
          }
        },
        {
          "key": 57,
          "doc_count": 40,
          "avg_caseId": {
            "value": 1615854.45
          }
        },
        {
          "key": 56,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1647824
          }
        },
        {
          "key": 55,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1619424
          }
        },
        {
          "key": 33,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1620581
          }
        },
        {
          "key": 31,
          "doc_count": 6,
          "avg_caseId": {
            "value": 1633189.6666666667
          }
        },
        {
          "key": 30,
          "doc_count": 36,
          "avg_caseId": {
            "value": 1622526.0833333333
          }
        },
        {
          "key": 16,
          "doc_count": 9,
          "avg_caseId": {
            "value": 1631462.888888889
          }
        },
        {
          "key": 15,
          "doc_count": 4,
          "avg_caseId": {
            "value": 1616555.75
          }
        },
        {
          "key": 12,
          "doc_count": 810,
          "avg_caseId": {
            "value": 1620188.4
          }
        },
        {
          "key": 9,
          "doc_count": 115,
          "avg_caseId": {
            "value": 1634853.9391304348
          }
        },
        {
          "key": 8,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1616066
          }
        },
        {
          "key": 7,
          "doc_count": 122,
          "avg_caseId": {
            "value": 1510171.950819672
          }
        },
        {
          "key": 6,
          "doc_count": 1126,
          "avg_caseId": {
            "value": 1621347.9307897072
          }
        },
        {
          "key": 4,
          "doc_count": 1,
          "avg_caseId": {
            "value": 1522284
          }
        },
        {
          "key": 3,
          "doc_count": 2,
          "avg_caseId": {
            "value": 1184044.5
          }
        },
        {
          "key": 2,
          "doc_count": 1627475,
          "avg_caseId": {
            "value": 814128.8230872978
          }
        },
        {
          "key": 1,
          "doc_count": 18775,
          "avg_caseId": {
            "value": 1633111.1089500317
          }
        },
        {
          "key": 0,
          "doc_count": 3,
          "avg_caseId": {
            "value": 539859.6666666666
          }
        },
        {
          "key": -1,
          "doc_count": 4,
          "avg_caseId": {
            "value": 30547159
          }
        }
      ]
    }
  }
}

 

 

 

 

 

{
    "size":0,
    "query":{
    },
    "aggregations":{
        "total_count":{
            "terms":{
                "field":"statusId",
                "missing":"-1",
                "size":500,
                "min_doc_count":1,
                "shard_min_doc_count":0,
                "show_term_doc_count_error":false,
                "order":[
                    {
                        "_term":"desc"
                    }
                ]
            },
            "aggregations":{
                "avg_caseId":{
                    "avg":{
                        "field":"caseId"
                    }
                },
                "creatorId" : {
                   "terms" : {
                      "field" : "creatorId"
                   }
                }
            }
        }
    }
}

 

 

{
  "took": 110,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1649341,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "total_count": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": 125,
          "doc_count": 9,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 244,
                "doc_count": 9
              }
            ]
          },
          "avg_caseId": {
            "value": 1649983.6666666667
          }
        },
        {
          "key": 124,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 84,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1647877
          }
        },
        {
          "key": 123,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 882,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1650298
          }
        },
        {
          "key": 118, 
          "doc_count": 28,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 618,
                "doc_count": 7
              },
              {
                "key": 859,
                "doc_count": 7
              },
              {
                "key": 207,
                "doc_count": 4
              },
              {
                "key": 702,
                "doc_count": 3
              },
              {
                "key": 788,
                "doc_count": 2
              },
              {
                "key": 434,
                "doc_count": 1
              },
              {
                "key": 465,
                "doc_count": 1
              },
              {
                "key": 777,
                "doc_count": 1
              },
              {
                "key": 848,
                "doc_count": 1
              },
              {
                "key": 994,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1620169.1785714286
          }
        },
        {
          "key": 117,
          "doc_count": 10,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 1003,
                "doc_count": 5
              },
              {
                "key": 1002,
                "doc_count": 4
              },
              {
                "key": 1041,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1619273.2
          }
        },
        {
          "key": 115,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 702,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1615978
          }
        },
        {
          "key": 109,
          "doc_count": 44,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 0,
                "doc_count": 20
              },
              {
                "key": 84,
                "doc_count": 12
              },
              {
                "key": 702,
                "doc_count": 5
              },
              {
                "key": 78,
                "doc_count": 3
              },
              {
                "key": 85,
                "doc_count": 2
              },
              {
                "key": 244,
                "doc_count": 2
              }
            ]
          },
          "avg_caseId": {
            "value": 1620698.0454545454
          }
        },
        {
          "key": 108,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 27,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1615535
          }
        },
        {
          "key": 102,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 859,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1615850
          }
        },
        {
          "key": 101,
          "doc_count": 26,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 848,
                "doc_count": 15
              },
              {
                "key": 859,
                "doc_count": 11
              }
            ]
          },
          "avg_caseId": {
            "value": 1615908.0384615385
          }
        },
        {
          "key": 100,
          "doc_count": 32,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 4,
            "buckets": [
              {
                "key": 994,
                "doc_count": 7
              },
              {
                "key": 207,
                "doc_count": 5
              },
              {
                "key": 859,
                "doc_count": 4
              },
              {
                "key": 465,
                "doc_count": 3
              },
              {
                "key": 20,
                "doc_count": 2
              },
              {
                "key": 434,
                "doc_count": 2
              },
              {
                "key": 702,
                "doc_count": 2
              },
              {
                "key": 25,
                "doc_count": 1
              },
              {
                "key": 87,
                "doc_count": 1
              },
              {
                "key": 244,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1622660.03125
          }
        },
        {
          "key": 99,
          "doc_count": 17,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 702,
                "doc_count": 5
              },
              {
                "key": 84,
                "doc_count": 3
              },
              {
                "key": 859,
                "doc_count": 3
              },
              {
                "key": 0,
                "doc_count": 1
              },
              {
                "key": 20,
                "doc_count": 1
              },
              {
                "key": 277,
                "doc_count": 1
              },
              {
                "key": 579,
                "doc_count": 1
              },
              {
                "key": 848,
                "doc_count": 1
              },
              {
                "key": 994,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1617725.5882352942
          }
        },
        {
          "key": 98,
          "doc_count": 2,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 27,
                "doc_count": 1
              },
              {
                "key": 702,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1615960
          }
        },
        {
          "key": 97,
          "doc_count": 28,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 745,
                "doc_count": 17
              },
              {
                "key": 848,
                "doc_count": 6
              },
              {
                "key": 27,
                "doc_count": 1
              },
              {
                "key": 74,
                "doc_count": 1
              },
              {
                "key": 277,
                "doc_count": 1
              },
              {
                "key": 788,
                "doc_count": 1
              },
              {
                "key": 790,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1626726.9285714286
          }
        },
        {
          "key": 84,
          "doc_count": 3,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 84,
                "doc_count": 1
              },
              {
                "key": 994,
                "doc_count": 1
              },
              {
                "key": 1164,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1620288
          }
        },
        {
          "key": 77,
          "doc_count": 10,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 702,
                "doc_count": 5
              },
              {
                "key": 859,
                "doc_count": 3
              },
              {
                "key": 0,
                "doc_count": 1
              },
              {
                "key": 465,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1616216.3
          }
        },
        {
          "key": 75,
          "doc_count": 7,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 78,
                "doc_count": 2
              },
              {
                "key": 438,
                "doc_count": 2
              },
              {
                "key": 87,
                "doc_count": 1
              },
              {
                "key": 244,
                "doc_count": 1
              },
              {
                "key": 618,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1616354
          }
        },
        {
          "key": 74,
          "doc_count": 3,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 0,
                "doc_count": 1
              },
              {
                "key": 78,
                "doc_count": 1
              },
              {
                "key": 99,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1620221.6666666667
          }
        },
        {
          "key": 73,
          "doc_count": 362,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 1,
            "buckets": [
              {
                "key": 848,
                "doc_count": 252
              },
              {
                "key": 0,
                "doc_count": 37
              },
              {
                "key": 78,
                "doc_count": 33
              },
              {
                "key": 434,
                "doc_count": 18
              },
              {
                "key": 84,
                "doc_count": 13
              },
              {
                "key": 567,
                "doc_count": 2
              },
              {
                "key": 702,
                "doc_count": 2
              },
              {
                "key": 994,
                "doc_count": 2
              },
              {
                "key": 438,
                "doc_count": 1
              },
              {
                "key": 616,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1642278.7182320443
          }
        },
        {
          "key": 65,
          "doc_count": 13,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 994,
                "doc_count": 7
              },
              {
                "key": 859,
                "doc_count": 3
              },
              {
                "key": 788,
                "doc_count": 2
              },
              {
                "key": 0,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1639632.7692307692
          }
        },
        {
          "key": 60,
          "doc_count": 197,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 3,
            "buckets": [
              {
                "key": 788,
                "doc_count": 166
              },
              {
                "key": 994,
                "doc_count": 10
              },
              {
                "key": 78,
                "doc_count": 6
              },
              {
                "key": 848,
                "doc_count": 4
              },
              {
                "key": 702,
                "doc_count": 2
              },
              {
                "key": 1001,
                "doc_count": 2
              },
              {
                "key": 0,
                "doc_count": 1
              },
              {
                "key": 20,
                "doc_count": 1
              },
              {
                "key": 211,
                "doc_count": 1
              },
              {
                "key": 277,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1619859.4771573604
          }
        },
        {
          "key": 58,
          "doc_count": 13,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 0,
                "doc_count": 6
              },
              {
                "key": 859,
                "doc_count": 3
              },
              {
                "key": 434,
                "doc_count": 1
              },
              {
                "key": 451,
                "doc_count": 1
              },
              {
                "key": 465,
                "doc_count": 1
              },
              {
                "key": 480,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1634659.6153846155
          }
        },
        {
          "key": 57,
          "doc_count": 40,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 5,
            "buckets": [
              {
                "key": 316,
                "doc_count": 6
              },
              {
                "key": 469,
                "doc_count": 5
              },
              {
                "key": 579,
                "doc_count": 4
              },
              {
                "key": 78,
                "doc_count": 3
              },
              {
                "key": 277,
                "doc_count": 3
              },
              {
                "key": 465,
                "doc_count": 3
              },
              {
                "key": 567,
                "doc_count": 3
              },
              {
                "key": 702,
                "doc_count": 3
              },
              {
                "key": 994,
                "doc_count": 3
              },
              {
                "key": 74,
                "doc_count": 2
              }
            ]
          },
          "avg_caseId": {
            "value": 1615854.45
          }
        },
        {
          "key": 56,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 20,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1647824
          }
        },
        {
          "key": 55,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 702,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1619424
          }
        },
        {
          "key": 33,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 20,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1620581
          }
        },
        {
          "key": 31,
          "doc_count": 6,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 465,
                "doc_count": 3
              },
              {
                "key": 0,
                "doc_count": 2
              },
              {
                "key": 20,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1633189.6666666667
          }
        },
        {
          "key": 30,
          "doc_count": 36,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 0,
                "doc_count": 27
              },
              {
                "key": 702,
                "doc_count": 2
              },
              {
                "key": 788,
                "doc_count": 2
              },
              {
                "key": 882,
                "doc_count": 2
              },
              {
                "key": 84,
                "doc_count": 1
              },
              {
                "key": 277,
                "doc_count": 1
              },
              {
                "key": 465,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1622526.0833333333
          }
        },
        {
          "key": 16,
          "doc_count": 9,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 0,
                "doc_count": 4
              },
              {
                "key": 1003,
                "doc_count": 3
              },
              {
                "key": 244,
                "doc_count": 1
              },
              {
                "key": 702,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1631462.888888889
          }
        },
        {
          "key": 15,
          "doc_count": 4,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 702,
                "doc_count": 3
              },
              {
                "key": 0,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1616555.75
          }
        },
        {
          "key": 12,
          "doc_count": 810,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 17,
            "buckets": [
              {
                "key": 0,
                "doc_count": 664
              },
              {
                "key": 848,
                "doc_count": 53
              },
              {
                "key": 244,
                "doc_count": 21
              },
              {
                "key": 702,
                "doc_count": 20
              },
              {
                "key": 434,
                "doc_count": 13
              },
              {
                "key": 465,
                "doc_count": 5
              },
              {
                "key": 469,
                "doc_count": 5
              },
              {
                "key": 859,
                "doc_count": 5
              },
              {
                "key": 316,
                "doc_count": 4
              },
              {
                "key": 56,
                "doc_count": 3
              }
            ]
          },
          "avg_caseId": {
            "value": 1620188.4
          }
        },
        {
          "key": 9,
          "doc_count": 115,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 3,
            "buckets": [
              {
                "key": 0,
                "doc_count": 61
              },
              {
                "key": 465,
                "doc_count": 15
              },
              {
                "key": 469,
                "doc_count": 10
              },
              {
                "key": 777,
                "doc_count": 8
              },
              {
                "key": 702,
                "doc_count": 7
              },
              {
                "key": 78,
                "doc_count": 3
              },
              {
                "key": 848,
                "doc_count": 3
              },
              {
                "key": 20,
                "doc_count": 2
              },
              {
                "key": 84,
                "doc_count": 2
              },
              {
                "key": 87,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1634853.9391304348
          }
        },
        {
          "key": 8,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 27,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1616066
          }
        },
        {
          "key": 7,
          "doc_count": 122,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 4,
            "buckets": [
              {
                "key": 0,
                "doc_count": 75
              },
              {
                "key": 81,
                "doc_count": 14
              },
              {
                "key": 80,
                "doc_count": 8
              },
              {
                "key": 994,
                "doc_count": 5
              },
              {
                "key": 316,
                "doc_count": 4
              },
              {
                "key": 745,
                "doc_count": 3
              },
              {
                "key": 1041,
                "doc_count": 3
              },
              {
                "key": 86,
                "doc_count": 2
              },
              {
                "key": 1002,
                "doc_count": 2
              },
              {
                "key": 1003,
                "doc_count": 2
              }
            ]
          },
          "avg_caseId": {
            "value": 1510171.950819672
          }
        },
        {
          "key": 6,
          "doc_count": 1126,
          "creatorId": {
            "doc_count_error_upper_bound": 5,
            "sum_other_doc_count": 210,
            "buckets": [
              {
                "key": 0,
                "doc_count": 613
              },
              {
                "key": 1002,
                "doc_count": 59
              },
              {
                "key": 702,
                "doc_count": 52
              },
              {
                "key": 848,
                "doc_count": 41
              },
              {
                "key": 1003,
                "doc_count": 37
              },
              {
                "key": 579,
                "doc_count": 28
              },
              {
                "key": 78,
                "doc_count": 26
              },
              {
                "key": 722,
                "doc_count": 24
              },
              {
                "key": 477,
                "doc_count": 19
              },
              {
                "key": 316,
                "doc_count": 17
              }
            ]
          },
          "avg_caseId": {
            "value": 1621347.9307897072
          }
        },
        {
          "key": 4,
          "doc_count": 1,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 316,
                "doc_count": 1
              }
            ]
          },
          "avg_caseId": {
            "value": 1522284
          }
        },
        {
          "key": 3,
          "doc_count": 2,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 316,
                "doc_count": 2
              }
            ]
          },
          "avg_caseId": {
            "value": 1184044.5
          }
        },
        {
          "key": 2,
          "doc_count": 1627475,
          "creatorId": {
            "doc_count_error_upper_bound": 118,
            "sum_other_doc_count": 8287,
            "buckets": [
              {
                "key": 0,
                "doc_count": 1615258
              },
              {
                "key": 78,
                "doc_count": 673
              },
              {
                "key": 244,
                "doc_count": 641
              },
              {
                "key": 469,
                "doc_count": 589
              },
              {
                "key": 702,
                "doc_count": 497
              },
              {
                "key": 243,
                "doc_count": 424
              },
              {
                "key": 84,
                "doc_count": 313
              },
              {
                "key": 81,
                "doc_count": 291
              },
              {
                "key": 277,
                "doc_count": 258
              },
              {
                "key": 848,
                "doc_count": 244
              }
            ]
          },
          "avg_caseId": {
            "value": 814128.8230872978
          }
        },
        {
          "key": 1,
          "doc_count": 18775,
          "creatorId": {
            "doc_count_error_upper_bound": 5,
            "sum_other_doc_count": 133,
            "buckets": [
              {
                "key": 1,
                "doc_count": 10678
              },
              {
                "key": 0,
                "doc_count": 7449
              },
              {
                "key": 465,
                "doc_count": 358
              },
              {
                "key": 84,
                "doc_count": 41
              },
              {
                "key": 469,
                "doc_count": 27
              },
              {
                "key": 434,
                "doc_count": 23
              },
              {
                "key": 316,
                "doc_count": 18
              },
              {
                "key": 244,
                "doc_count": 17
              },
              {
                "key": 1003,
                "doc_count": 16
              },
              {
                "key": 78,
                "doc_count": 15
              }
            ]
          },
          "avg_caseId": {
            "value": 1633111.1089500317
          }
        },
        {
          "key": 0,
          "doc_count": 3,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": 0,
                "doc_count": 3
              }
            ]
          },
          "avg_caseId": {
            "value": 539859.6666666666
          }
        },
        {
          "key": -1,
          "doc_count": 4,
          "creatorId": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": []
          },
          "avg_caseId": {
            "value": 30547159
          }
        }
      ]
    }
  }
}

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值