Question: how msck repair table works?
Answer: MSCK REPAIR TABLE. Use the MSCK REPAIR TABLE command to update the metadata in the catalog after you add or remove Hive compatible partitions. The MSCK REPAIR TABLE command scans a file system such as Amazon S3 for Hive compatible partitions that were added to or removed from the file system after the table was created ...