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

Read syntax diagramSkip visual syntax diagramHCAT_CACHE_SYNC(schema-name object-name )

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.
    
CALL SYSHADOOP.HCAT_CACHE_SYNC('SCHEMA1','TABLE1');
    This procedure tells the Db2® Big SQL scheduler to flush its cache for the particular object, which in this example is the table, Table1.
  • Direct the Db2 Big SQL scheduler to clear its cache of everything in SCHEMA1.
    
CALL SYSHADOOP.HCAT_CACHE_SYNC('SCHEMA1');