SHOW RESTORE

Description

This statement is used to view RESTORE tasks

Syntax

SHOW [BRIEF] RESTORE [FROM <db_name>]

Parameters

1.<db_name>

The name of the database to which the recovery task belongs.

Return Value

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

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

Example

1. View the latest RESTORE task under example_db.

SHOW RESTORE FROM example_db;