AnalyticDB for MySQL allows you to execute the MSCK REPAIR TABLE statement to synchronize a partition from an Object Storage Service (OSS) external table to an AnalyticDB for MySQL cluster.


The minor engine version of the cluster is or later.
Note For more information about how to view the minor engine version of a cluster, see How can I view the version of an AnalyticDB for MySQL cluster? To update the minor engine version of a cluster, contact technical support.

Usage notes

The syntax is applicable only to partitions of OSS external tables other than AnalyticDB for MySQL tables.


MSCK REPAIR TABLE table_name [SYNC_DIR 'Location'];


table_nameThe name of the external table.
SYNC_DIR 'Location'Synchronizes the specified partition. If you do not specify this parameter, the entire table is synchronized. Location specifies the OSS path of the specified partition.


  • Synchronize the entire table.
    MSCK REPAIR TABLE adb_external_db.partition_table_test;
  • Synchronize the specified partition.
    MSCK REPAIR TABLE adb_external_db.partition_table_test SYNC_DIR 'oss://testBucketName/test_db/partition_table_test/dt=20220619';