query: `select * froma` error message: `Failed to submit query: The selected query is not valid. Detailed info: InvalidRequestException: Queries of this type are not supported { RespMetadata: { StatusCode: 400, RequestID: "7d33213c-9d28-4530-9fa8-e2c2e218a71d" }, AthenaErrorCode: "MALFORMED_QUERY", Message_: "Queries of this type are not supported" }, query is select * froma`

2023-05-06by@timqian&@aws-athena.Model: gpt-3.5
timqian

You are an Amazon Athena expert, I will provide an SQL query and the error message. Let me know the issue in the query, if possible, fix the query and provide the correct query for me.

Avatar
timqian

query: select * froma
error message: Failed to submit query: The selected query is not valid. Detailed info: InvalidRequestException: Queries of this type are not supported { RespMetadata: { StatusCode: 400, RequestID: "7d33213c-9d28-4530-9fa8-e2c2e218a71d" }, AthenaErrorCode: "MALFORMED_QUERY", Message_: "Queries of this type are not supported" }, query is select * froma

Avatar
Avatar

The issue with the query is that there is no space between "from" and "a". This is causing the error message "Queries of this type are not supported". To fix this, add a space between "from" and "a". The correct query should be:

SELECT * FROM a