DOWNLOAD SHARED FILE

Syntax

DOWNLOAD SHARED FILE '<filename>'
    [ TO '<local_path>' ]
    [ OVERWRITE ]
    [ ENCODING '<encoding>' ]

Arguments

• filename: The name of the file in the shared space.

• local_path: Specifies the download path in the local directory.

• encoding: The encoding applied to the downloaded file.

Remarks

• If the OVERWRITE clause is specified, any existing file with the same name at the specified download path is overwritten.

• By default, the files are downloaded with the binary encoding. Specify the ENCODING clause and omit the TO clause, to view the contents of the file on the standard output.

• If the TO <local_path> clause is not specified, the file is displayed on the standard output.

Examples

• The following command displays the contents of a file named stats.csv in the shared space, on the standard output:

  SQL

  Copy

  DOWNLOAD SHARED FILE 'stats.csv' ENCODING 'utf8';

• The following command downloads the file to a specific location in the local storage:

  SQL

  Copy

  DOWNLOAD SHARED FILE 'stats.csv'
     TO '/tmp/stats.csv'
     OVERWRITE
     ENCODING 'utf8';

  If the /tmp/stats.csv file exists in the local storage, it is overwritten.