LOAD DATA
Description
LOAD DATA
statement loads the data into a table from the user specified directory or file. If a directory is specified then all the files from the directory are loaded. If a file is specified then only the single file is loaded. Additionally the LOAD DATA
statement takes an optional partition specification. When a partition is specified, the data files (when input source is a directory) or the single file (when input source is a file) are loaded into the partition of the target table.
Syntax
Parameters
path
- Path of the file system. It can be either an absolute or a relative path.
table_identifier
-
Specifies a table name, which may be optionally qualified with a database name.
Syntax:[ database_name. ] table_name
partition_spec
-
An optional parameter that specifies a comma separated list of key and value pairs
for partitions.
Syntax:PARTITION ( partition_col_name = partition_col_val [ , ... ] )
LOCAL
- If specified, it causes the
INPATH
to be resolved against the local file system, instead of the default file system, which is typically a distributed storage.
OVERWRITE
- By default, new data is appended to the table. If
OVERWRITE
is used, the table is instead overwritten with new data.