1 回答
- 最新
- 投票最多
- 评论最多
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
已回答 2 年前
相关内容
- AWS 官方已更新 1 年前