Versions (relevant - OpenSearch SQL Plugin - 1.3.2 or after):
Describe the issue:
How to get more than 10K rows using SQL Plugin group by? It always returns 1000 rows or less. If I remove the group by I am also stuck with 10K or less.
In typical scenarios our data are in millions if not billions and it is highly expected that a group by statement goes beyond 10K.
Max window size=10K
Relevant Logs or Screenshots: