Logical table DML operations

Operation

Syntax

Description

INSERT OVERWRITE

insert overwrite table {table_name} [partition ({pt_spec})] ({col_name}, {col_name}, ...) {select_statement} from {from_statement};

Inserts or overwrites data in the table. This operation applies only to logical dimension tables, logical aggregate tables, and logical fact tables.

• If you omit field specifications, all existing data in the target table is cleared before the new data is inserted.

• If you specify fields, only the data in those fields is cleared. Data in other fields remains unaffected.