1 Answer
- Newest
- Most votes
- Most comments
0
This type of error occurs when an invalid argument is passed to a function. Provided below is an example of how this error occurs.
Correct query:
SELECT date_parse('2010-10-23 00:00:00','%Y-%m-%d %H:%i:%s');
Result:
_col0
1 2010-10-23 00:00:00.000
Query with error:
SELECT date_parse('2010--23 00:00:00','%Y-%m-%d %H:%i:%s');
Result:
INVALID_FUNCTION_ARGUMENT: Invalid format: "2010--23 00:00:00" is malformed at "-23 00:00:00"
From the error message, it looks like an empty string is being passed to a function. Please check your query to see if there are any such functions being used and the values being passed to them.
If your query was working before and started to fail now, please reach out to to AWS Premium Support with successful and failure Athena query ids.
Relevant content
- asked 10 months ago
- asked 10 months ago
- asked 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated a month ago