Feedback) AWS Athena MSCK REPAIR TABLE does not work for double quote table

0

Problem: MSCK REPAIR TABLE "table"; => Double quote does not work. Result: 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>

MSCK REPAIR TABLE table; => Works.

Please note that when we click our table name in left panel from AWS console it auto-generates double quotes instead of `

Suggested solution:

Option 1) Enable Athena Query to work on both syntax including double quote

Option 2) When clicking table name from aws console auto-generate table instead of "table"

schoi
asked 7 months ago263 views
1 Answer
0

Hello,

I understand that MSCK REPAIR TABLE "table"; => Double quote does not work, when table name is double clicked on the left panel.

As an alternative solution, please follow the below mentioned steps:

  1. Click on the 3 dots in-front of table name in the left panel.
  2. Load partitions.
  3. It will auto-generate the query like MSCK REPAIR TABLE tablename;
  4. Run the query.

By following these steps, you will be able to execute the MSCK REPAIR query without any issues.

That being said, if you would like to request a new feature, as suggested above, please raise a support case with AWS for further information.

Have a good day!

AWS
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions