Load Data

Important

This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See 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.