- Newest
- Most votes
- Most comments
As you might already be aware that Athena uses Presto in the back end. It seems that there was a known issue with PrestoSQL (Trino) where the query would fail if two columns are being updated with the same value. Please refer the below Github link for more details: https://github.com/trinodb/trino/commit/4e1cc58c2a73129a5d590c01e1e0040755e58248
But this was fixed in the newer versions of the PrestoSQL and since Athena version 2 still uses an older version of Presto which is causing the above problem. I have tested with Athena version 2 and faced the same issue. On testing with Athena version 3 this issue seem to have been fixed as the Update query is working fine when two columns are being updated with same value, such as 0 in your case.
Therefore, to overcome the issue I would request you to upgrade to Athena version to 3 and then test. Please refer the below document for Athena version 3: https://docs.aws.amazon.com/athena/latest/ug/engine-versions-reference-0003.html
Relevant content
- asked 5 months ago
- Accepted Answerasked 6 months ago
- asked 2 years ago
- Accepted Answerasked 4 months ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago