How to get more than 10K rows using SQL Plugin group by?

Plugins SQL
1

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.

Configuration:

SQL size_limit=10K
Max window size=10K

Relevant Logs or Screenshots:

2

@asfoorial For non aggregation queries, please refer Extend query size limit using scroll

And for aggregation query requests, currently there is a size limit. You can track the progress here.