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