This statement is used to view RESTORE tasks
SHOW [BRIEF] RESTORE [FROM <db_name>]
1.<db_name>
The name of the database to which the recovery task belongs.
| Column | Description |
|---|---|
| JobId | Unique job id |
| Label | The name of the backup to restore |
| Timestamp | The time version of the backup to restore |
| DbName | belongs to the database |
| State | current stage: PENDING: The initial state after submitting the job.SNAPSHOTING: Executing snapshot.DOWNLOAD: The snapshot is complete, ready to download the snapshot in the repository.DOWNLOADING: Snapshot downloading.COMMIT: Snapshot download is complete, ready to take effect.COMMITTING: in effect.FINISHED: Job finish time.CANCELLED: Job failed. |
| AllowLoad | Whether to allow import when restoring (currently not supported) |
| ReplicationNum | Specifies the number of replicas to restore |
| ReserveReplica | Whether to keep a copy |
| ReplicaAllocation | Whether to keep dynamic partitioning enabled |
| RestoreJobs | Tables and partitions to restore |
| CreateTime | task submission time |
| MetaPreparedTime | Metadata preparation completion time |
| SnapshotFinishedTime | Snapshot completion time |
| DownloadFinishedTime | Snapshot download completion time |
| FinishedTime | Job finish time |
| UnfinishedTasks | Displays unfinished subtask ids during SNAPSHOTING, DOWNLOADING and COMMITING stages |
| Progress | Task progress |
| TaskErrMsg | Display task error messages |
| Status | If the job fails, display the failure message |
| Timeout | Job timeout, in seconds |
SHOW RESTORE FROM example_db;