[BUG] OpenSearch API - {"message":"{\"Message\":\"Fail to run query. Cause: Not a map type: string\"}"}

[A-Gray-Cat]

What is the bug?
I tried to execute a PPL query using the API, and I got the following error: {"message":"{\"Message\":\"Fail to run query. Cause: Not a map type: string\"}"}

The same query would return results successfully in an OpenSearch domain.

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

1. Issue an API request to include a query similar to this one:

source = amazon_security_lake_glue_db_us_west_2.amazon_security_lake_table_us_west_2_lambda_execution_2_0 | where time_dt >= timestamp('"'"'2024-10-07'"'"') | fields accountid, region | head 10

What is the expected behavior?
The query should return 10 rows of data that include "accountid", and "region" as columns.

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.

[dblock]

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