repair_table: Run the Hive's metastore consistency check: 'MSCK REPAIR...
| repair_table | R Documentation |
Run the Hive's metastore consistency check: 'MSCK REPAIR TABLE table;'.
Description
Recovers partitions and data associated with partitions. Use this statement when you add partitions to the catalog. It is possible it will take some time to add all partitions. If this operation times out, it will be in an incomplete state where only a few partitions are added to the catalog.
Usage
repair_table(table, database)
Arguments
table |
Table name |
database |
AWS Glue/Athena database name |
Value
Query final state ('SUCCEEDED', 'FAILED', 'CANCELLED')
Examples
`query_final_state = dbtools::repair_table(table='...', database='...')`
