Purpose
This statement is used to manually update the files of an external table. For a table with a single file, the data can be automatically updated. However, if the data of the external table comes from a list of files, it cannot be automatically updated and requires manual refreshing.
Syntax
ALTER EXTERNAL TABLE table_name REFRESH
Parameters
table_name specifies the name of the external table to be refreshed.
Examples
-- To successfully execute this statement, you must ensure that the corresponding external table exists.
obclient> ALTER EXTERNAL TABLE lineitem REFRESH;