SHOW-RESTORE

Name

SHOW RESTORE

Description

This statement is used to view RESTORE tasks

grammar:

1. SHOW [BRIEF] RESTORE [FROM DB_NAME]

illustrate:

1. 1. Only the most recent RESTORE task is saved in Doris.
2. 2. The meaning of each column is as follows:
3. JobId: Unique job id
4. Label: The name of the backup to restore
5. Timestamp: The time version of the backup to restore
6. DbName: belongs to the database
7. State: current stage
8. PENDING: The initial state after submitting the job
9. SNAPSHOTING: Executing snapshot
10. DOWNLOAD: The snapshot is complete, ready to download the snapshot in the repository
11. DOWNLOADING: Snapshot downloading
12. COMMIT: Snapshot download is complete, ready to take effect
13. COMMITING: in effect
14. FINISHED: The job was successful
15. CANCELLED: Job failed
16. AllowLoad: Whether to allow import when restoring (currently not supported)
17. ReplicationNum: Specifies the number of replicas to restore
18. RestoreJobs: Tables and partitions to restore
19. CreateTime: task submission time
20. MetaPreparedTime: Metadata preparation completion time
21. SnapshotFinishedTime: Snapshot completion time
22. DownloadFinishedTime: Snapshot download completion time
23. FinishedTime: Job finish time
24. UnfinishedTasks: Displays unfinished subtask ids during SNAPSHOTING, DOWNLOADING and COMMITING stages
25. Status: If the job fails, display the failure message
26. Timeout: Job timeout, in seconds

SinceVersion dev

1. 2. brief: only show key information of RESTORE tasks, columns RestoreObjs, Progress, TaskErrMsg will not show

Example

1. View the latest RESTORE task under example_db.

1. SHOW RESTORE FROM example_db;

Keywords

1. SHOW, RESTORE

Best Practice