Release Notes
- v3.1
- v3.0
- v2.5
- v2.4
- v2.3
- v2.2
- v2.1
- v2.0
- v1.19

StarRocks
Introduction to StarRocks
Quick Start
Table Design
- Understand StarRocks table design
- Data models
- Data distribution
  - Data distribution
  - Temporary partition
- Sort keys and prefix indexes
Data Loading
Data Unloading
Query Data Sources
- Use catalogs to manage internal and external data
- External tables
Query Acceleration
Administration
- Deployment
- Management
- Data Recovery
  - Data recovery
  - Restore FEs
- User Privilege and Authentication
  - User privilege
  - Authentication
- Performance Tuning
Reference
- SQL Reference
- Function Reference
  - Java UDFs
  - Window functions
  - Aggregate Functions
  - Array Functions
  - Bit Functions
  - Bitmap Functions
  - Conditional Functions
  - Cryptographic Functions
  - Date Functions
  - Geographic Functions
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON operators
    - JSON constructor functions
    - JSON query and processing functions
  - Math Functions
    - abs
    - acos
    - asin
    - atan
    - atan2
    - bin
    - ceil
    - ceiling
    - conv
    - cos
    - cosh
    - cot
    - degrees
    - divide
    - e
    - exp
    - floor
    - fmod
    - greatest
    - least
    - ln
    - log
    - log2
    - log10
    - mod
    - multiply
    - negative
    - pi
    - pmod
    - positive
    - pow
    - radians
    - rand
    - round
    - sign
    - sin
    - sqrt
    - square
    - tan
    - truncate
  - String Functions
  - Pattern Matching Functions
  - Percentile Functions
  - Scalar Functions
    - hll_cardinality
  - Utility Functions
  - cast function
  - hash function
- System variables
- Error code
- System limits
FAQ
- Deploy
- Data Migration
  - Data Loading
  - Data Unloading
- SQL
- Other FAQs
Benchmark
- SSB Benchmark
- TPC-H Benchmark

Developers
- Contribute to StarRocks
- Code Style Guides
  - protobuf style guides
  - thrift style guides
- Use the debuginfo file for debugging
- Development Environment
- Trace Tools
  - Trace

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

Examples

View the RESTORE task of example_db.

SHOW RESTORE FROM example_db;

Edit

In this article

SHOW RESTORE