Reputation: 1
We are trying to execute a query to get variable_width_histogram aggregation results but getting an error 'Trying to create too many buckets'. However bucket size in query is 10. When trying to get bucket size 8, I am able to get results correctly but with size 10, this error is coming.
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"query_string": {
"fields": [
"field1",
"field2"
],
"default_operator": "AND",
"query": "(product1)"
}
}
]
}
}
],
"must": [],
"must_not": []
}
},
"size": 0,
"aggs": {
"minMaxPriceRangeData": {
"filter": {
"bool": {
"must": []
}
},
"aggs": {
"piceRangeData": {
"variable_width_histogram": {
"field": "value",
"buckets": 10
}
}
}
}
}
}
Total result doc count are 7974263 on which this query is running. Is there any other way we can extract similar data without any error?
Tried by passing less number of buckets and in that case getting results correctly.
I don't want to change my cluster settings for this. Instead looking for getting results from query itself.
Upvotes: 0
Views: 67