[BUG] Opensearch Dashboards using docvalue_fields when it's not needed

[CpuID]

Describe the bug

Copied from elastic/kibana#68672 - same bug that exists in Opensearch Dashboards also.

When creating simple daily count visualizations, or really any Kibana based query. Everything breaks due to kibana including more than 100 doc_values, even if only one, "@timestamp" is actually needed.
This includes ilm, apm, beats, you name it. After we updated to 7.6.0 and updated our index patterns Kibana is completely useless.

To Reproduce

Steps to reproduce the behavior:

1. Open up Visualize
2. select Data Table
3. use an index pattern/search that has a decent volume of data and fields in it, with a Terms aggregation
4. click Inspect -> Requests -> Request to see all the docvalue_fields in there

Expected behavior

Less docvalue_fields in the query sent to Opensearch

OpenSearch Version

2.13

Dashboards Version

2.13

Plugins

None

Screenshots

Additional context

This issue existed in Kibana - elastic/kibana#68672 and was resolved, I believe by changing to the Fields API over on that project...?

[dblock]

[Catch All Triage - 1, 2, 3, 4, 5]

Thanks for opening this. When contributing a fix please make sure not to look at/copy any non-APLv2-compatible/non-open-source code.