====== COPY FROM LOCAL Statement ======
COPY FROM LOCAL statement allows to copy local directories and files to Hadoop compatible file system. Using this statement you can easily copy subdirectories into HDFS i.e.
**Syntax**:
COPY FROM LOCAL src [, src2, ...] TO tgt [options]
options:
OVERWRITE
DELETE
IGNORE
Return values (set to [[hostcode|HOSTCODE]]):
| **HOSTCODE** | **Description** |
| 0 | Copy was successful |
| 1 | Copy failed |
| 2 | No files found |
Notes:
* //srcN// specifies a file or directory. If a directory is specified all subdirectories and their files are copied as well.
* //srcN// can be an expression, variable, quoted or unquoted string.
* If a single file is copied //tgt// must specify a path including the target file name.
* If multiple files are copied //tgt// must specify a directory.
* If the target directory does not exist it is created.
* OVERWRITE specifies to overwrite the target files if they exist.
* DELETE specifies to delete the source file upon successfull copy.
* IGNORE specifies to ignore errors when copying a file and proceed to copy the remaining files.
**Example**:
Copy files from a directory and its subdirectories to a daily backup directory:
COPY FROM LOCAL '/home/data' TO '/user/backup/' || CURRENT_DATE;
**Compatibility:** HPL/SQL Extension
**Version:** HPL/SQL 0.3.7
See also:
* [[copy|COPY]]