Answer-first summary for fast verification
Answer: Confirm that Athena is pointing to the correct Amazon S3 location., Use the MSCK REPAIR TABLE command.
When an Amazon Athena query returns no data for an Amazon S3 partitioned table, the most common reasons are that the Amazon S3 location specified in the table definition is incorrect (Option A), or that the partitions physically exist in S3 but have not been loaded into the AWS Glue Data Catalog. Running the `MSCK REPAIR TABLE` command scans the designated S3 path for new, missing partitions and registers them in the catalog so Athena can successfully query the underlying data (Option C).
Author: Ritesh Yadav
Ultimate access to all questions.
Question 57
A company has a data lake in Amazon S3. The company collects AWS CloudTrail logs for multiple applications. The company stores the logs in the data lake, catalogs the logs in AWS Glue, and partitions the logs based on the year. The company uses Amazon Athena to analyze the logs. Recently, customers reported that a query on one of the Athena tables did not return any data. A data engineer must resolve the issue. Which combination of troubleshooting steps should the data engineer take? (Choose two.)
A
Confirm that Athena is pointing to the correct Amazon S3 location.
B
Increase the query timeout duration.
C
Use the MSCK REPAIR TABLE command.
D
Restart Athena.
No comments yet.