es统计有多少个分组_Elasticsearch分组聚合-查询每个A_logtype下有多少数据

Elasticsearch分组聚合

1.查询指定索引下每个A_logtype有多少数据

curl -XPOST 'localhost:19200/ylchou-0-2015-10-07/_search?pretty' -d '

{

"size": 0,

"aggs": {

"group_by_state": {

"terms": {

"field": "A_logtype"

}

}

}

}'

结果:

{

"took" : 33,

"timed_out" : false,

"_shards" : {

"total" : 1,

"successful" : 1,

"failed" : 0

},

"hits" : {

"total" : 30434,

"max_score" : 0.0,

"hits" : [ ]

},

"aggregations" : {

"group_by_state" : {

"doc_count_error_upper_bound" : 0,

"sum_other_doc_count" : 0,

"buckets" : [ {

"key" : "waf-214",

"doc_count" : 28928

}, {

"key" : "waf-358",

"doc_count" : 1506

} ]

}

}

}

2.查询多个索引下每个A_logtype下有多少数据

curl -XPOST 'localhost:19200/ylchou-0-2015-*/_search?pretty' -d '

{

"size": 0,

"aggs": {

"group_by_state": {

"terms": {

"field": "A_logtype"

}

}

}

}'

结果:

{

"took" : 531,

"timed_out" : false,

"_shards" : {

"total" : 28,

"successful" : 28,

"failed" : 0

},

"hits" : {

"total" : 13477509,

"max_score" : 0.0,

"hits" : [ ]

},

"aggregations" : {

"group_by_state" : {

"doc_count_error_upper_bound" : 0,

"sum_other_doc_count" : 23151,

"buckets" : [ {

"key" : "error",

"doc_count" : 3880753

}, {

"key" : "draglog-168",

"doc_count" : 3566095

}, {

"key" : "策略测试数据004",

"doc_count" : 2999538

}, {

"key" : "syslog-37",

"doc_count" : 1284500

}, {

"key" : "waf-214",

"doc_count" : 667958

}, {

"key" : "QimingStar13",

"doc_count" : 646717

}, {

"key" : "136test",

"doc_count" : 201971

}, {

"key" : "标准化策略测试数据101",

"doc_count" : 161039

}, {

"key" : "Waf150test",

"doc_count" : 24208

}, {

"key" : "waf-358",

"doc_count" : 21579

} ]

}

}

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值