Load Data


This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is no longer supported. See LOAD DATA.

LOAD DATA [LOCAL] INPATH path [OVERWRITE] INTO TABLE [db_name.]table_name [PARTITION 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.


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


Load the path from the local file system. Otherwise, the default file system is used.


Delete existing data in the table. Otherwise, new data is appended to the table.