DROP CACHE table WHERE condition;
DROP CACHE deletes cache metadata of the
table from coordinator only. Workers' caches purged automatically by expiry time
or by reaching size limit but recurring splits will not reuse any cached node assignments.
DROP CACHE command supports dropping specific cache records by matching the corresponding predicate string.
For example, if
SHOW CACHE command shows that there is a record with predicate string
sale_id = 24 under the table of
sales, then running the following query can delete it without
affecting any other cache record:
DROP CACHE sales WHERE sale_id = 24;
Or simply drop all cache metadata for 'sales' table by running:
DROP CACHE sales;
Only Hive connector support this functionality at this time. See connector documentation for more details.