UNCACHE TABLE

Description

UNCACHE TABLE removes the entries and associated data from the in-memory and/or on-disk cache for a given table or view. The underlying entries should already have been brought to cache by previous CACHE TABLE operation. UNCACHE TABLE on a non-existent table throws Exception if IF EXISTS is not specified.

Syntax

UNCACHE TABLE [ IF EXISTS ] table_name

Parameters

table_name
The name of the table or view to be uncached.

Examples

UNCACHE TABLE t1;