ContextQMD
Back to Spark

UNCACHE TABLE

docs/sql-ref-syntax-aux-cache-uncache-table.md

4.1.11.1 KB
Original Source

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 an exception if IF EXISTS is not specified.

Note: Cached data is shared across all Spark sessions on the cluster, so uncaching it affects all sessions.

Syntax

sql
UNCACHE TABLE [ IF EXISTS ] table_identifier

Parameters

  • table_identifier

    Specifies the table or view name to be uncached. The table or view name may be optionally qualified with a database name.

    Syntax: [ database_name. ] table_name

Examples

sql
UNCACHE TABLE t1;