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