Edit

SHOW RESTORE

Description

This statement is used to view RESTORE task.

Syntax

SHOW RESTORE [FROM <db_name>]

Note:

1. Only the latest RESTORE task is saved in StarRocks.
2. The meanings of each column are as follows:
JobId:                  unique job id
Label:                  name of the backup to restore
Timestamp:              the time version of the backup to restore
DbName:                 Owning Database
State:                  current stage
PENDING:                the initial status after submitting the job
SNAPSHOTING:            executing snapshot
DOWNLOAD:               the snapshot is completed and ready to download the snapshot in the repository.
DOWNLOADING:            snapshot downloading
COMMIT:                 the snapshot download is complete and ready to take effect
COMMITING:              in effect
FINISHED:               job succeeded
CANCELLED:              job failed
AllowLoad:              whether to allow import during recovery (currently not supported)
ReplicationNum:         Specifies the number of replicas to restore
RestoreJobs:            tables and partitions to restore
CreateTime:             ask submission time
MetaPreparedTime:       metadata preparation completion time
SnapshotFinishedTime:   snapshot completion time
DownloadFinishedTime:   snapshot download completion time
FinishedTime:           job end time
UnfinishedTasks:        unfinished subtask id is displayed in the SNAPSHOTING, DOWNLOADING and COMMITING phases
Status:                 if the job fails, the failure information is displayed
Timeout:                job timeout, in seconds

Examples

View the RESTORE task of example_db.

SHOW RESTORE FROM example_db;