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.
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
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