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.
- If this flag is provided, the local file system will be used load the path. Otherwise, the default file system will be used.
- If this flag is provided, the existing data in the table will be deleted. Otherwise, the new data will be appended to the table.