[FEATURE] Increase the maximum numbers of records returned as a config. or UI settings

[anirudha]

Is your feature request related to a problem?
customers needs a setting to set max limits on reports

What solution would you like?
UI per report or a larger global yml setting

[Yankun-lk]

hello anirudha

I encountered the following limitations when exporting data to Csv files using opensearch dashboard.
CSV reports have a non-configurable 10,000 row limit. They have no explicit size limit (for example, MB), but extremely large documents could cause report generation to fail with an out of memory error from the V8 JavaScript engine.
https://opensearch.org/docs/latest/dashboards/reporting/#:~:text=CSV%20reports%20have%20a%20non%2Dconfigurable%2010%2C000%20row%20limit.%20They%20have%20no%20explicit%20size%20limit%20(for%20example%2C%20MB)%2C%20but%20extremely%20large%20documents%20could%20cause%20report%20generation%20to%20fail%20with%20an%20out%20of%20memory%20error%20from%20the%20V8%20JavaScript%20engine

For Opensearch, the limit of 10000 JSON data is not very friendly. We hope to increase the upper limit of this limit.

[krisfreedain]

Catch All Triage - 1, 2, 3