"too_many_buckets_exception"

OpenSearch
,
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):

I have created aggregation query with 14 fields. Time range every 5 minutes. we got around 7 k records but getting “too_many_buckets_exception” issue.

I am sharing the error. please check.

{“error”:{“root_cause”:[{“type”:“too_many_buckets_exception”,“reason”:“Trying to create too many buckets. Must be less than or equal to: [65535] but was [65536]. This limit can be set by changing the [search.max_buckets] cluster level setting.”,“max_buckets”:65535}],“type”:“too_many_buckets_exception”,“reason”:“Trying to create too many buckets. Must be less than or equal to: [65535] but was [65536]. This limit can be set by changing the [search.max_buckets] cluster level setting.”,“max_buckets”:65535},“status”:503}

Thank you

Describe the issue:

Configuration:

Relevant Logs or Screenshots:

2

Could you show your query DSL?

3

I am sharing query. Please check and Thanks in advance

GET index_name/_search
{"size":0,"query":{"bool":{"filter":[{"range":{"StartTime":{"gte":"2024-07-07T01:05:00Z","lt":"2024-07-07T01:10:00Z"}}}]}},"aggs":{"StartTime":{"date_histogram":{"field":"StartTime","fixed_interval":"5m"},"aggs":{"FieldNameOne":{"terms":{"field":"FieldNameOne.keyword"},"aggs":{"FieldNameTwo":{"terms":{"field":"FieldNameTwo.keyword"},"aggs":{"FieldNameThree":{"terms":{"field":"FieldNameThree.keyword"},"aggs":{"FieldNameFour":{"terms":{"field":"FieldNameFour.keyword"},"aggs":{"FieldNameFive":{"terms":{"field":"FieldNameFive.keyword"},"aggs":{"FieldNameSix":{"terms":{"field":"FieldNameSix.keyword"},"aggs":{"FieldNameSeven":{"terms":{"field":"FieldNameSeven.keyword"},"aggs":{"FieldNameNight":{"terms":{"field":"FieldNameNight.keyword"},"aggs":{"FieldNameNine":{"terms":{"field":"FieldNameNine.keyword"},"aggs":{"FieldNameTen":{"terms":{"field":"FieldNameTen.keyword"},"aggs":{"FieldNameEleven":{"terms":{"field":"FieldNameEleven.keyword"},"aggs":{"FieldNameTwelve":{"terms":{"field":"FieldNameTwelve.keyword"},"aggs":{"FieldNamethirteen":{"terms":{"field":"FieldNamethirteen.keyword"},"aggs":{"AvgETime":{"avg":{"field":"FieldNamemobileTime"}},"MinETime":{"min":{"field":"FieldNamemobileTime"}},"MaxETime":{"max":{"field":"FieldNamemobileTime"}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}