REFRESH
Description
REFRESH
is used to invalidate and refresh all the cached data (and the associated metadata) for
all Datasets that contains the given data source path. Path matching is by prefix, i.e. “/” would
invalidate everything that is cached.
Syntax
REFRESH resource_path
Parameters
-
resource_path
The path of the resource that is to be refreshed.
Examples
-- The Path is resolved using the datasource's File Index.
CREATE TABLE test(ID INT) using parquet;
INSERT INTO test SELECT 1000;
CACHE TABLE test;
INSERT INTO test SELECT 100;
REFRESH "hdfs://path/to/table";