- Newest
- Most votes
- Most comments
Hi,
We can programmatically copy the tables by executing the DDL statements in different regions https://docs.aws.amazon.com/athena/latest/ug/code-samples.html
Also since the Athena tables are basically Glue data catalogs, you can also refer the following Github link for migration of glue data catalog to another data catalog, and see if that helps with your requirement. https://github.com/aws-samples/aws-glue-samples/tree/master/utilities/Hive_metastore_migration#aws-glue-data-catalog-to-another-aws-glue-data-catalog.
I understand that you are getting the following error while running MSCK REPAIR TABLE command. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask There can be different reasons for this error, but the most common one is with permissions issue. I would recommend you to check the IAM user/role permissions and S3 bucket permissions (if it is an S3 source). https://aws.amazon.com/premiumsupport/knowledge-center/access-denied-athena/ https://aws.amazon.com/premiumsupport/knowledge-center/quicksight-access-denied-athena-data/
Relevant content
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 7 months ago