Load Data


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_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.