1 Answer
- Newest
- Most votes
- Most comments
1
Cause: Athena engine version 3 checks to make sure that the precision of timestamps in the data is the same as the precision specified for the column data type in the table specification. Currently, this precision is always 3. If the data has a precision greater than this, queries fail with the error noted. reference: https://docs.aws.amazon.com/athena/latest/ug/engine-versions-reference-0003.html
If you need date from the column, you can try SELECT DATE(my_problem_column) FROM my_table. Basically changing the format of timestamp to date type.
answered a year ago
Relevant content
- asked 2 years ago
- asked a year ago
- asked 5 months ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 3 months ago