es统计有多少个分组_es多字段分组去重统计

<

es多字段分组去重统计

oracle中sql:

select a1 ,b1 from dual group by a1 ,b1

或

select DISTINCT a1 ,b1 from dual

es分组去重统计：

(话不多说，直接贴代码)

TermsAggregationBuilder mobilesBuilder = AggregationBuilders.terms(“mobiles”).field(“mobile”);

TermsAggregationBuilder msgIdsBuilder = AggregationBuilders.terms(“msgIds”).field(“msgId”);

mobilesBuilder.subAggregation(msgIdsBuilder);

SearchResponse searchResponse = this.getClient().prepareSearch(dailyIndexNamesByTime)

.setFrom(0)

.setSize(10000)

.setSearchType(SearchType.DFS_QUERY_THEN_FETCH)

.addSort(“createDate”, SortOrder.DESC)

.addAggregation(mobilesBuilder)

.setQuery(boolQueryBuilder)

.execute()

.actionGet();

查询结果：

“aggregations”: {

“mobiles”: {

“doc_count_error_upper_bou