HPL/SQL is included to Apache Hive since version 2.0
This is an old revision of the document!
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.
COPY FROM LOCAL src [, src2, ...] TO tgt [options] options: OVERWRITE DELETE IGNORE
|0||Copy was successful|
|2||No files found|
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