Data Lake Analytics - Deprecated：MSCK REPAIR TABLE

Synchronize the partition information of the OSS data source to the metadata

Syntax

MSCK REPAIR TABLE table_name

Example

SHOW PARTITIONS primitives_parquet_p does not display partition information before you run the MSCK REPAIR TABLE command.

mysql> show partitions primitives_parquet_p;
+--------+
| Result |
+--------+
|        |
+--------+
1 row in set (0.85 sec)

After you run the MSCK REPAIR TABLE command, the partition information is displayed:

mysql> msck repair table primitives_parquet_p;
+--------+
| Result |
+--------+
| NULL   |
+--------+
1 row in set (0.94 sec)
mysql> show partitions primitives_parquet_p;
+--------------------------------------------------------------------------+
| Result                                                                   |
+--------------------------------------------------------------------------+
| year=2009/month=1
year=2009/month=2
year=2009/month=3
year=2009/month=4
 |
+--------------------------------------------------------------------------+
1 row in set (0.33 sec)