1 Resposta
- Mais recentes
- Mais votos
- Mais comentários
0
Timestamp with Time Zone is not supported by the glue crawler or by Athena.
Timestamp would be automatically identified if it is in the java.sql.Timestamp format, i.e. yyyy-mm-dd hh:mm:ss[.f...] by the Glue crawler. see this link for timestamp format: https://docs.aws.amazon.com/athena/latest/ug/data-types.html
option 1 - You could use CAST() to convert string with timezone into timestamp
option 2 - you could write an custom classifier. refer to https://docs.aws.amazon.com/glue/latest/dg/custom-classifier.html for TIMEZONE and DATESTAMP
respondido há 2 anos
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos