Getting INTERNAL_ERROR_QUERY_ENGINE while trying to run msck repair table

Hi Diksha,

Amazon Athena while trying to run the msck repair table command on your daily_wallet_dlr_new table.

Let's Solve the issue in simple way:

• Retry the Query: Sometimes, internal errors can be transient. Try rerunning the msck repair table daily_wallet_dlr_new query.
• Check Athena Service Status: Visit the AWS Service Health Dashboard (https://docs.aws.amazon.com/health/latest/ug/aws-health-dashboard-status.html) and check for any reported issues with Athena in your region.
• Analyze the Table: Use the MSCK REPAIR TABLE command with the VALIDATE option to get more detailed information about potential errors with the table. The command would look like this:

MSCK REPAIR TABLE daily_wallet_dlr_new VALIDATE;

• Check Table Properties: Ensure that the table properties like parquet.compression are set correctly. In your case, the compression is set to 'SNAPPY'. You can find the documentation for supported table properties here: https://hive.apache.org/
• Reduce the Scope of Repair: If the entire table repair fails, try running the MSCK REPAIR TABLE command on a specific partition of the table. This can help isolate the issue if it's confined to a particular partition.

MSCK REPAIR TABLE daily_wallet_dlr_new VALIDATE;

doesn't work for me.

line 1:1: mismatched input 'MSCK'. Expecting: 'ALTER', 'ANALYZE', 'CALL', 'COMMENT', 'COMMIT', 'CREATE', 'DEALLOCATE', 'DELETE', 'DENY', 'DESC', 'DESCRIBE', 'DROP', 'EXECUTE', 'EXPLAIN', 'GRANT', 'INSERT', 'MERGE', 'PREPARE', 'REFRESH', 'RESET', 'REVOKE', 'ROLLBACK', 'SET', 'SHOW', 'START', 'TRUNCATE', 'UNLOAD', 'UPDATE', 'USE', <query>