RECOVER

Dans DataKanu Warehouse

Les bases et tables supprimées depuis l'interface restent récupérables pendant un jour, sauf suppression forcée. Voir Sauvegarde et restauration.

Description

This statement is used to recover previously deleted databases, tables, or partitions.

It supports recovering specified metadata by name or ID and allows renaming the recovered metadata.

Syntax:

RECOVER { DATABASE <db_name> [<db_id>] [AS <new_db_name>] 
        | TABLE [<db_name>.]<table_name> [<table_id>] [AS <new_table_name>] 
        | PARTITION <partition_name> [<partition_id>] FROM [<db_name>.]<table_name> [AS <new_partition_name>] }

Required Parameters

Recover a database

1. <db_name>

The name of the database to recover.

Recover a table

1. <table_name>

The name of the table to recover.

Recover a partition

1. <partition_name>

The name of the partition to recover.

2. <table_name>

The name of the table where the partition resides.

Optional Parameters

Recover a database

1. <db_id>

The ID of the database to recover.

2. <new_db_name>

The new name of the recovered database.

Recover a table

1. <db_name>

The name of the database where the table resides.

2. <table_id>

The ID of the table to recover.

3. <new_table_name>

The new name of the recovered table.

Recover a partition

1. <partition_id>

The ID of the partition to recover.

2. <db_name>

The name of the database where the table resides.

3. <new_partition_name>

The new name of the recovered partition.

Access Control Requirements

Privilege	Object	Note
ADMIN_PRIV

Usage Notes

• This operation can only recover metadata deleted within a certain period. The default is 1 day (configurable via the catalog_trash_expire_second parameter in fe.conf).
• If no ID is specified when recovering metadata, the last deleted metadata with the same name is recovered by default.
• You can query the currently recoverable metadata using SHOW CATALOG RECYCLE BIN.

Examples

1. Recover a database named example_db

   RECOVER DATABASE example_db;

2. Recover a table named example_tbl

   RECOVER TABLE example_db.example_tbl;

3. Recover a partition named p1 from the table example_tbl

   RECOVER PARTITION p1 FROM example_tbl;

4. Recover a database with ID example_db_id and name example_db

   RECOVER DATABASE example_db example_db_id;

5. Recover a table with ID example_tbl_id and name example_tbl

   RECOVER TABLE example_db.example_tbl example_tbl_id;

6. Recover a partition with ID p1_id and name p1 from the table example_tbl

   RECOVER PARTITION p1 p1_id FROM example_tbl;

7. Recover a database with ID example_db_id and name example_db, and rename it to new_example_db

   RECOVER DATABASE example_db example_db_id AS new_example_db;

8. Recover a table named example_tbl and rename it to new_example_tbl

   RECOVER TABLE example_db.example_tbl AS new_example_tbl;

9. Recover a partition with ID p1_id and name p1 from the table example_tbl, and rename it to new_p1

   RECOVER PARTITION p1 p1_id AS new_p1 FROM example_tbl;