1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
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.
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 3 años
- OFICIAL DE AWSActualizada hace 2 años