When you are loading a table, you can use the INTO
TABLE
clause to specify a table-specific loading method (INSERT
, APPEND
, REPLACE
, or TRUNCATE
) that applies only to that table. That method overrides the global table-loading method. The global table-loading method is INSERT
, by default, unless a different method was specified before any INTO
TABLE
clauses. The following sections discuss using these options to load data into empty and nonempty tables.