I am not able to perform delete operation on row in AWS Athena tables. It is throwing below error as:

NOT_SUPPORTED: Modifying Hive table rows is only supported for transactional tables
This query ran against the "some database" database, unless qualified by the query.

Please note my data is stored in S3.

Any leads would be highly appreciated.

Thanks