REFRESH

Name

SinceVersion 1.2.0

REFRESH

Description

This statement refreshes the metadata of the specified Catalog/Database/Table.

syntax:

1. REFRESH CATALOG catalog_name;
2. REFRESH DATABASE [catalog_name.]database_name;
3. REFRESH TABLE [catalog_name.][database_name.]table_name;

When the Catalog is refreshed, the object-related Cache is forced to be invalidated.

Including Partition Cache, Schema Cache, File Cache, etc.

Example

1. Refresh hive catalog

1. REFRESH CATALOG hive; 2. Refresh database1

1. REFRESH DATABASE ctl.database1; 2. REFRESH DATABASE database1; 3. Refresh table1

1. REFRESH TABLE ctl.db.table1; 2. REFRESH TABLE db.table1; 3. REFRESH TABLE table1;

Keywords

REFRESH, CATALOG, DATABASE, TABLE

Best Practice