NOT_SUPPORTED: Hive table rows is only supported for transactional tables

Hello,

Going by the error message, It indicates that the modify/update operation of rows in athena is not supported for non-transactional tables.

Athena ACID transactions[1] add single-table support for insert, delete, update, and time travel operations to the Athena SQL data manipulation language (DML)

The documentation[2] states that athena only supports ACID transactions for transactional tables and feature like updating/modifying the rows is only supported for apache iceberg tables in Athena.

https://docs.aws.amazon.com/athena/latest/ug/update-statement.html

Further, I checked and could see a 3rd party stack overflow link[3] which might help you and provide some insight on how to update/delete operations on a non-transaction table.

https://stackoverflow.com/questions/73729405/how-to-do-update-delete-operations-on-non-transactional-table?noredirect=1&lq=1

I hope this helps! Thank you !

References: [1]https://docs.aws.amazon.com/athena/latest/ug/acid-transactions.html [2]https://docs.aws.amazon.com/athena/latest/ug/update-statement.html [3]https://stackoverflow.com/questions/73729405/how-to-do-update-delete-operations-on-non-transactional-table?noredirect=1&lq=1