1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
Hello,
In Athena, values enclosed within single quotes represent string
values. I checked through table details and could see column 'MATERIAL_DOCUMENT_YEAR' is defined as decimal(4,0)
and thus the error.
To fix this, you can consider any one of the below approaches:
where MATERIAL_DOCUMENT_YEAR = 2021
Or
where MATERIAL_DOCUMENT_YEAR = decimal '2021'
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans