This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
copy-from-ftp [2016/03/28 19:41] dmtolpeko |
copy-from-ftp [2016/03/28 19:49] (current) dmtolpeko |
||
---|---|---|---|
Line 26: | Line 26: | ||
* SUBDIR option specifies to transfer files in sub-directories. The directory structure is recreated in the target. By default, the command transfers files only from the directory specified by DIR option. | * SUBDIR option specifies to transfer files in sub-directories. The directory structure is recreated in the target. By default, the command transfers files only from the directory specified by DIR option. | ||
* SESSIONS specifies the number of concurrent FTP sessions to transfer the files. Each session transfers the whole file. By default, files are copied in the single session. | * SESSIONS specifies the number of concurrent FTP sessions to transfer the files. Each session transfers the whole file. By default, files are copied in the single session. | ||
+ | |||
+ | **Example:** | ||
+ | |||
+ | Copy new files including files in subdirectories from a FTP server to HDFS location using 3 concurrent connections: | ||
+ | |||
+ | <code language="sql"> | ||
+ | copy from ftp 'ftp.myserver.com' user 'paul' pwd '***' dir data/sales/in subdir | ||
+ | files '.*' to /data/sales/raw sessions 3 new | ||
+ | </code> | ||
**Compatibility**: HPL/SQL Extension | **Compatibility**: HPL/SQL Extension | ||
**Version**: HPL/SQL 0.3.17 | **Version**: HPL/SQL 0.3.17 |