Skip to main content
Removes all entries from a file cache, both in memory and on disk, on every rank. The cache remains enabled, so data read after it is cleared is cached again; until then, reads of data that was held in the cache are retrieved from their source instead, and may be slower. Only users with the system_admin permission can issue this command. To see the entries held in each file cache and the usage statistics of the caches, query the ki_file_cache_entries and ki_file_cache_stats catalog tables.
CLEAR FILE CACHE Syntax

​
Parameters

<cache name>

Name of the file cache to clear. The only file cache is external_files, which holds data read from files in remote storage, such as the files backing external tables.Cache names are case-sensitive and must be given in lowercase.

"default"

Clear all file caches. As default is a reserved word, it must be double-quoted.

​
Response

The response to CLEAR FILE CACHE is a single-row result set with one column, SYSTEM_PROPERTIES, confirming the request in the form file_cache.<cache name>.clear = true.

​
Examples

To clear the external files cache:
CLEAR FILE CACHE Example
To clear all file caches:
CLEAR FILE CACHE for All Caches Example