Load Data

LOAD DATA [LOCAL] INPATH path [OVERWRITE] INTO TABLE [db_name.]table_name [PARTITION part_spec]

part_spec:
    : (part_col_name1=val1, part_col_name2=val2, ...)

Load data from a file into a table or a partition in the table. The target table must not be temporary. A partition spec must be provided if and only if the target table is partitioned.

Note

This is supported only for tables created using the Hive format.

LOCAL
Load the path from the local file system. Otherwise, the default file system is used.
OVERWRITE
Delete existing data in the table. Otherwise, new data is appended to the table.