Question: what is msck in hive?
Answer: 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. ... To update the metadata, you run MSCK REPAIR TABLE on the table. This enables you to query the data in the new partitions from Athena.