ALTER EXTERNAL TABLE

Purpose

You can use this statement to manually update the files of an external table. A single file can be automatically updated, but a list of files must be manually updated.

Syntax

ALTER EXTERNAL TABLE table_name REFRESH;

Parameters

table_name specifies the name of the external table whose files are to be updated.

Examples

obclient> ALTER EXTERNAL TABLE lineitem REFRESH;
Query OK, 0 rows affected

References

CREATE EXTERNAL TABLE