UNCACHE TABLE

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

Syntax

UNCACHE TABLE [ IF EXISTS ] table_name

See Delta and Apache Spark caching for the differences between the Delta cache and the Apache Spark cache.

Parameters

Examples

> UNCACHE TABLE t1;