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公式更新しました 8ヶ月前