RECOVER

Description

This statement is used to recover deleted database, table or partition.

Syntax:

1. Recover database

   RECOVER DATABASE db_name;

2. Recover database

   RECOVER TABLE [db_name.]table_name;

3. Recover partition

   RECOVER PARTITION partition_name FROM [db_name.]table_name;

Note：

1. It can only recover meta-information deleted some time ago. The default time: one day. (You can change it through parameter configuration catalog_trash_expire_second in fe.conf. )
2. If the meta-information is deleted with an identical meta-information created, the previous one will not be recovered.

Examples

1. Recover database named example_db

   RECOVER DATABASE example_db;

2. Recover table name example_tbl

   RECOVER TABLE example_db.example_tbl;

3. Recover partition named p1 in the example_tbl table

   RECOVER PARTITION p1 FROM example_tbl;