GET index_alias/_search
{
"profile": "true",
"size": 0,
"query": {
"bool": {
"must": [
{
"range": {
"release_date": {
"gte": "2022-11-05 10:00:09",
"lte": "2022-11-14 11:30:09"
}
}
}
]
}
},
"aggs": {
"topicGroup": {
"terms": {
"field": "only_crc",
"size": 1000
},
"aggs": {
"keyName": {
"cardinality": {
"field": "only_crc"
}
}
}
},
"sumOfData": {
"sum_bucket": {
"buckets_path": "topicGroup._count"
}
},
"count": {
"cardinality": {
"field": "only_crc"
}
},
"sum": {
"sum_bucket": {
"buckets_path": "topicGroup>keyName.value"
}
}
}
}
GET data_stream_write_alias/_search
{
"profile": "true",
"size": 0,
"query": {
"bool": {
"must": [
{
"range": {
"release_date": {
"gte": "2022-11-10 11:30:09",
"lte": "2022-11-14 11:30:09"
}
}
},
{
"nested": {
"path": "areas",
"query": {
"bool": {
"should": [
{
"match": {
"areas.areaId": 46
}
},
{
"match": {
"areas.areaId": 23
}
}
]
}
}
}
}
]
}
},
"aggs": {
"topicGroup": {
"cardinality": {
"field": "only_crc"
}
},
"countById": {
"cardinality": {
"field": "stream_id"
}
}
}
}