copy-from-ftp

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
copy-from-ftp [2016/03/09 16:53]
dmtolpeko
copy-from-ftp [2016/03/28 19:49]
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
 +
 +**Version**:​ HPL/SQL 0.3.17