SHOW-CATALOG-RECYCLE-BIN
SHOW-CATALOG-RECYCLE-BIN
Name
SHOW CATALOG RECYCLE BIN
Description
This statement is used to display the dropped meta informations that can be recovered
grammar:
SHOW CATALOG RECYCLE BIN [ WHERE NAME [ = "name" | LIKE "name_matcher"] ]
grammar:
The meaning of each column is as follows:
Type: type of meta information:Database、Table、Partition
Name: name of meta information
DbId: id of database
TableId: id of table
PartitionId: id of partition
DropTime: drop time of meta information
DataSize: the amount of data. If the type is database, this value includes the data size of the recycled tables and partitions in the database
RemoteDataSize: the amount of data on remote storage(hdfs or object storage). If the type is database, this value includes the remote data size of the recycled tables and partitions in the database
Example
Display all meta informations that can be recovered
SHOW CATALOG RECYCLE BIN;
Display meta informations with name 'test'
SHOW CATALOG RECYCLE BIN WHERE NAME = 'test';
Keywords
SHOW, CATALOG RECYCLE BIN