I am getting below error when running SELECT, INSERT, DELETE or any other statement on ICEBERG table
GENERIC_INTERNAL_ERROR: io.trino.plugin.hive.s3.TrinoS3FileSystem$UnrecoverableS3OperationException: com.amazonaws.services.s3.model.AmazonS3Exception: The specified key does not exist. (Service: Amazon S3; Status Code: 404; Error Code: NoSuchKey; Request ID: 01PHNZRRTYEF3169; S3 Extended Request ID: IvGkhgs9KJqlgmeL5hd9uhZiTYUfgI9JR7k7WgecOWnmN6LkusUVqUBoCbfmGl8KjdIKBSu4Q5U=; Proxy: null)
I have tried repairing the table using MSCK REPAIR TABLE <TABLE_NAME>
but it says athena doesn't support this. When I try to OPTIMIZE table then also I get same GENERIC_INTERNAL_ERROR.
I checked S3 bucked related to this athena table and it has both metadata and data available.