[BUG][SanityTest] stats by a high cardinality field will cause writing job fail with "size exceed limitation"

[LantaoJin]

What is the bug?
When group by a high cardinality field, such as clientip, the spark writing job will fail "Request size exceeded 10485760 bytes" .

How can one reproduce the bug?
Steps to reproduce the behavior:

1. Go to Workbench page. For example https://search-flint05-sanity-h5if7yelmxws5hc35cap2lauf4.us-east-1.es-integ.amazonaws.com/_dashboards/app/opensearch-query-workbench#/
2. Execute a PPL query source = myglue_test.default.http_logs | stats avg(size) by clientip
3. Open the EMR-S job in Spark UI.
4. See error

What is the expected behavior?
A clear and concise description of what you expected to happen.

What is your host/environment?

• OS: [e.g. iOS]
• Version [e.g. 22]
• Plugins

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
Add any other context about the problem.

[YANG-DB]

@LantaoJin what do you suggest here ?
should we rewrite the query in such high carnality cases ?

[YANG-DB]

fieldsummary should provide statistical info about fields and assisting the cost estimation of the query including cardinality