ADMIN-COPY-TABLET
ADMIN-COPY-TABLET
Name
ADMIN COPY TABLET
Description
This statement is used to make a snapshot for the specified tablet, mainly used to load the tablet locally to reproduce the problem.
syntax:
ADMIN COPY TABLET tablet_id PROPERTIES("xxx");
Notes:
This command requires ROOT privileges.
PROPERTIES supports the following properties:
backend_id: Specifies the id of the BE node where the replica is located. If not specified, a replica is randomly selected.
version: Specifies the version of the snapshot. The version must be less than or equal to the largest version of the replica. If not specified, the largest version is used.
expiration_minutes: Snapshot retention time. The default is 1 hour. It will automatically clean up after a timeout. Unit minutes.
The results are shown below:
TabletId: 10020
BackendId: 10003
Ip: 192.168.10.1
Path: /path/to/be/storage/snapshot/20220830101353.2.3600
ExpirationMinutes: 60
CreateTableStmt: CREATE TABLE `tbl1` (
`k1` int(11) NULL,
`k2` int(11) NULL
) ENGINE=OLAP
DUPLICATE KEY(`k1`, `k2`)
DISTRIBUTED BY HASH(k1) BUCKETS 1
PROPERTIES (
"replication_num" = "1",
"version_info" = "2"
);
- TabletId: tablet id
- BackendId: BE node id
- Ip: BE node ip
- Path: The directory where the snapshot is located
- ExpirationMinutes: snapshot expiration time
- CreateTableStmt: The table creation statement for the table corresponding to the tablet. This statement is not the original table-building statement, but a simplified table-building statement for later loading the tablet locally.
Example
Take a snapshot of the replica on the specified BE node
ADMIN COPY TABLET 10010 PROPERTIES("backend_id" = "10001");
Take a snapshot of the specified version of the replica on the specified BE node
ADMIN COPY TABLET 10010 PROPERTIES("backend_id" = "10001", "version" = "10");
Keywords
ADMIN, COPY, TABLET