RECOVER
Name
RECOVER
Description
This statement is used to restore a previously deleted database, table or partition
grammar:
restore database
RECOVER DATABASE db_name;
restore table
RECOVER TABLE [db_name.]table_name;
restore partition
RECOVER PARTITION partition_name FROM [db_name.]table_name;
illustrate:
- This operation can only restore meta information that was deleted in the previous period. Default is 1 day. (Configurable through the
catalog_trash_expire_second
parameter in fe.conf) - If a new meta information with the same name and type is created after the meta information is deleted, the previously deleted meta information cannot be recovered
Example
- Restore the database named example_db
RECOVER DATABASE example_db;
- Restore the table named example_tbl
RECOVER TABLE example_db.example_tbl;
- Restore the partition named p1 in table example_tbl
RECOVER PARTITION p1 FROM example_tbl;
Keywords
RECOVER