[Discover-Next][UI] Validate total hits value

[kavilla]

Description

DQL ends up calling _search and _msearch with track_total_hits. The value is intended be all the hits in the cluster even though the size param is 500 based on the Advanced Setting

Requirements

• Might need UX assistance but what if the data source doesn't support the total hits param [more info]
• Get the param to send for PPL/SQL to get this value if it is support
• Verify the calculation is correct but need to check with UX and product if its ok to display the response size and if it got total hits then we display
  • [SOURCE i think this is the wrong location but will include it](

    OpenSearch-Dashboards/src/plugins/data/common/data_frames/utils.ts

    Line 207 in a4aa682

    searchResponse.hits.total += bucketValue;