docs/sql-manual/sql-statements/Database-Administration-Statements/ADMIN-SET-PARTITION-VERSION.md

{ “title”: “ADMIN-SET-PARTITION-VERSION”, “language”: “en” }

ADMIN-SET-PARTITION-VERSION

Name

ADMIN SET PARTITION VERSION

Description

This statement is used to set the version of the specified partition.

In certain cases, the version of the partition in the metadata may not be consistent with the version of the actual replica. This command can manually set the version of the partition in the metadata.

grammar:

ADMIN SET TABLE table_name PARTITION VERSION
        PROPERTIES ("key" = "value", ...);

The following properties are currently supported:

“partition_id”: Required. Specify a Partition Id.
“visible_version”: Required. Specify Version.

Note:
It is necessary to first confirm the version of the actual replica on the Be before set the version of the partition. This command is generally only used for emergency troubleshooting, please proceed with caution.

Example

Set the version of partition 1769152 to 100.

ADMIN SET TABLE tbl1 PARTITION VERSION PROPERTIES("partition_id" = "1769152", "visible_version" = "100");

Keywords