1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
Contenus pertinents
- demandé il y a un an
- demandé il y a un mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 5 ans
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an