HCAT_CACHE_SYNC stored procedure
Whenever a change occurs in the Hive metastore, the HCAT_CACHE_SYNC stored procedure updates the scheduler cache with the catalog data from the Hive metastore.
Syntax
Description
- schema-name
- Specifies the name of the schema that you want to refresh. If no object name is included with the schema name, information about all contents of the schema is refreshed.
- object-name
- Specifies the name of the object in the schema that you want to refresh.
Examples
- Update the table object TABLE1 in schema
SCHEMA1.
This procedure tells the Db2® Big SQL scheduler to flush its cache for the particular object, which in this example is the table, Table1.CALL SYSHADOOP.HCAT_CACHE_SYNC('SCHEMA1','TABLE1');
- Direct the Db2 Big SQL scheduler to clear its cache of everything in SCHEMA1.
CALL SYSHADOOP.HCAT_CACHE_SYNC('SCHEMA1');