Hi All,
I am working on creating the table from elasticsearch with nested aggregation query.
Below is my example Query
{
“index”:“data”
“size”: 0,
“aggs”: {
“date_aggr”: {
“date_histogram”: {
“field”: “timestamp”,
“interval”: “1d”
},
“aggs”: {
“agg_abc”: {
“terms”: {
“field”: “abc.keyword”,
“order”: {
“price”: “desc”
}
},
“aggs”: {
“price”: {
“sum”: {
“field”: “price”
}
}
}
}
}
}
}
}
The above Nested aggregated query does not give all the columns in the table as the response of elasticsearch. Also “agg_abc” have more than 5 categories in it but in table it shows only for 2 categories which is also not complete.
But when I hit the above query to elastic search It gives the proper response with all categories.
According to me the nested aggregated query is not being parsed properly as some of the columns are missing.
