- Introduction
- Quick Start
- Table Design
- Data Loading
- Data Export
- Using StarRocks
- Reference
- SQL Reference
- User Account Management
- Cluster Management
- ADMIN CANCEL REPAIR
- ADMIN CHECK TABLET
- ADMIN REPAIR
- ADMIN SET CONFIG
- ADMIN SET REPLICA STATUS
- ADMIN SHOW CONFIG
- ADMIN SHOW REPLICA DISTRIBUTION
- ADMIN SHOW REPLICA STATUS
- ALTER SYSTEM
- CANCEL DECOMMISSION
- CREATE FILE
- DROP FILE
- INSTALL PLUGIN
- SHOW BACKENDS
- SHOW BROKER
- SHOW FILE
- SHOW FRONTENDS
- SHOW FULL COLUMNS
- SHOW INDEX
- SHOW PLUGINS
- SHOW TABLE STATUS
- UNINSTALL PLUGIN
- DDL
- ALTER DATABASE
- ALTER TABLE
- ALTER VIEW
- BACKUP
- CANCEL BACKUP
- CANCEL RESTORE
- CREATE DATABASE
- CREATE INDEX
- CREATE MATERIALIZED VIEW
- CREATE REPOSITORY
- CREATE RESOURCE
- CREATE TABLE AS SELECT
- CREATE TABLE LIKE
- CREATE TABLE
- CREATE VIEW
- CREATE FUNCTION
- DROP DATABASE
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP REPOSITORY
- DROP RESOURCE
- DROP TABLE
- DROP VIEW
- DROP FUNCTION
- HLL
- RECOVER
- RESTORE
- SHOW RESOURCES
- SHOW FUNCTION
- TRUNCATE TABLE
- DML
- ALTER ROUTINE LOAD
- BROKER LOAD
- CANCEL LOAD
- DELETE
- EXPORT
- GROUP BY
- INSERT
- PAUSE ROUTINE LOAD
- RESUME ROUTINE LOAD
- ROUTINE LOAD
- SELECT
- SHOW ALTER
- SHOW BACKUP
- SHOW DATA
- SHOW DATABASES
- SHOW DELETE
- SHOW DYNAMIC PARTITION TABLES
- SHOW EXPORT
- SHOW LOAD
- SHOW PARTITIONS
- SHOW PROPERTY
- SHOW REPOSITORIES
- SHOW RESTORE
- SHOW ROUTINE LOAD
- SHOW ROUTINE LOAD TASK
- SHOW SNAPSHOT
- SHOW TABLES
- SHOW TABLET
- SHOW TRANSACTION
- SPARK LOAD
- STOP ROUTINE LOAD
- STREAM LOAD
- Data Type
- Auxiliary Commands
- Function Reference
- Date Functions
- Geographic Functions
- String Functions
- Aggregation Functions
- Bitmap Functions
- Array Functions
- cast function
- hash function
- Crytographic Functions
- Math Functions
- Utility Functions
- System variables
- Error code
- System limits
- SQL Reference
- Administration
- FAQ
- Deployment
- Data Migration
- SQL
- Others FAQs
- Benchmark
- Developers
- Contribute to StarRocks
- Code Style Guides
- Use the debuginfo file for debugging
- Development Environment
- Trace Tools
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
example
- View example_ db the next RESTORE task.
SHOW RESTORE FROM example_db;
keyword
SHOW, RESTORE
Edit
In this article