VeloDB Cloud
SQL Manual
SQL Statements
Database Administration
ADMIN-SET-PARTITION-VERSION

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:

  1. "partition_id": Required. Specify a Partition Id.
  2. "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

  1. Set the version of partition 1769152 to 100.
ADMIN SET TABLE tbl1 PARTITION VERSION PROPERTIES("partition_id" = "1769152", "visible_version" = "100");

Keywords

ADMIN, SET, PARTITION, VERSION

Best Practice