Describe the bug

When the max bucket size is hit & when partial or no results are returned, the response needs to inform that the results are partial.
When the bucket size limit was being hit, observed inconsistencies.
On some customers a toast popup (on OpenSearch Dashboards) clearly showed that something had gone wrong, though it was still unclear what.
In other customers, the dashboard simply appeared fine, however the data had not been updated. This can lead customers to think that the data is complete & they may miss vitally important information for their business.
This is occurring even with a simple table visualisation.

When opensearch-project/OpenSearch#18982 is fixed, use the details in the response to display a message clearly indicating that the results are not complete.

For improved usability, allow a mechanism to resend the request with an increased bucket size. This could be a follow-up ticket if not addressed in this ticket.

To Reproduce
Steps to reproduce the behavior:
Create a simple table viz that has many terms aggs in it. Set the bucket size to some very small number and then use a terms agg that is greater than this.

Expected behavior
The feedback in the returned results should be more clearly escalated that there are partial or no results and the data that is shown should still be processed and updated but appropriate feedback needs to be clearly presented to the user.

OpenSearch Version
2.19.0

Dashboards Version
2.19.0

Plugins

NA

Screenshots

None

Host/Environment (please complete the following information):
OS: Alma Linux
Version 9.4

Additional context

NA