ALTER EXTERNAL TABLE

Purpose

This statement is used to manually update the data of an external table. If the data of an external table comes from a list of files, you must manually refresh the table data.

Syntax

ALTER EXTERNAL TABLE table_name REFRESH

Parameters

table_name specifies the name of the external table to be refreshed.

Examples

-- Make sure that the corresponding external table exists before you execute this statement.
obclient> ALTER EXTERNAL TABLE lineitem REFRESH;

References

CREATE EXTERNAL TABLE