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달 전