Error on create view
0
Hi, i'm trying to upgrade from athena version 2 to 3 and the following query fails now with the error bellow. I run the select alone and it works fine. Did anything change in the new version that i missed ?
1 Answer
- Newest
- Most votes
- Most comments
0
im not sure what breaking change affects it so ended up casting to timestamp(3) without timezone UNNEST("sequence"(cast(from_iso8601_timestamp('2021-01-01') as timestamp), cast(from_iso8601_timestamp(to_iso8601(current_date + INTERVAL '1' YEAR)) as timestamp), INTERVAL '1' DAY)) sequence (day)
answered a year ago
Relevant content
- asked 10 months ago
- asked a year ago
AWS OFFICIALUpdated 3 years ago- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated a year ago
Try check if done breaking change affected you https://docs.aws.amazon.com/athena/latest/ug/engine-versions-reference-0003.html#engine-versions-reference-0003-breaking-changes.