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 | Description |
0 | Copy was successful |
1 | Copy failed |
2 | No files found |
Notes:
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: