Get Distinct Values with More than 50000


I found an error if the unique count of a field over 50000.

Request to Elasticsearch failed: {"error":{"root_cause":,"type":"search_phase_execution_exception","reason":"","phase":"fetch","grouped":true,"failed_shards":,"caused_by":{"type":"too_many_buckets_exception","reason":"Trying to create too many buckets. Must be less than or equal to: [50000] but was [50001]. This limit can be set by changing the [search.max_buckets] cluster level setting.","max_buckets":50000}},"status":503}

May I ask how can we get the distinct count of a field if the distinct count more than 50000?



Hi @stevetso,

Could you gives us some more details on how did you get this error?

Best regards

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.