SHOW-RESTORE

SHOW RESTORE

This statement is used to view RESTORE tasks

Syntax:

SHOW RESTORE [FROM DB_NAME]

Note:

Only the most recent RESTORE task is saved in Doris.
The implication of each column is as follows: 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 COMMITING: in effect FINISHED: The job was successful CANCELLED: Job failed AllowLoad: Whether to allow import when restoring (currently not supported) ReplicationNum: Specifies the number of replicas to restore 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 Status: If the job fails, display the failure message Timeout: Job timeout, in seconds

View the latest RESTORE task under example_db.
```
SHOW RESTORE FROM example_db;
```

SHOW, RESTORE