On this page

Show all

REFRESH CATALOG

Updated on 2022-11-18 GMT+08:00

This statement is used to manually refresh the HetuEngine MetaStore cache to synchronize the metadata of tables, partitions, and databases of the Hive data source.

Syntax

REFRESH CATALOG catalog_name

Example

Log in to FusionInsight Manager, and choose Cluster > Name of the desired cluster > Service > HetuEngine > Configuration > All Configurations. Set hive.metastore-cache-ttl and hive.metastore-refresh-interval to 5m, indicating that the metadata cache is refreshed every 5 minutes.

Use Hive to create a table tb3 and the query result on Hetu-cli is:

 show tables;
 Table 
-------
 tb1   
 tb2   
(2 rows)

Refresh the metadata cache and query again.

 refresh catalog hive;
show tables;
 Table 
-------
 tb1   
 tb2   
 tb3   
(3 rows)
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback