Function
This command is used to register Carbon table to Hive meta store catalogue from exisiting Carbon table data.
Syntax
REFRESH TABLE db_name.table_name;
Parameter Description
Table 1 REFRESH TABLE parametersParameter
|
Description
|
|---|
db_name
|
Name of the database. If this parameter is left unspecified, the current database is selected.
|
table_name
|
Name of the table.
|
Usage Guidelines
- The new database name and the old database name should be same.
- Before executing this command the old table schema and data should be copied into the new database location.
- If the table is aggregate table, then all the aggregate tables should be copied to the new database location.
- For old store, the time zone of the source and destination cluster should be same.
- If old cluster used HIVE meta store to store schema, refresh will not work as schema file does not exist in file system.
Examples
REFRESH TABLE dbcarbon.productSalesTable;
System Response
By running this command, the Carbon table will be registered to Hive meta store catalogue from exisiting Carbon table data.