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 only supported for tables created using the Hive format.

LOCAL
If this flag is provided, the local file system will be used load the path. Otherwise, the default file system will be used.
OVERWRITE
If this flag is provided, the existing data in the table will be deleted. Otherwise, the new data will be appended to the table.