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' )

The schema is SYSHADOOP.

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 refresh its cache of everything in SCHEMA1.
    CALL SYSHADOOP.HCAT_CACHE_SYNC('SCHEMA1');