Vertica Analytics Platform Version 9.2.x Documentation

S3EXPORT

Exports data to an Amazon S3 bucket from your Vertica cluster.

If your bucket name contains a period, you must specify a file extension in your export syntax or enable the prepend_hash parameter in s3export.

Syntax

S3EXPORT( expression USING PARAMETERS { parameter=setting} [,…] 

Parameters

expression Specifies the source of the export operation.
url

The URL of the S3 bucket and object base name. This value can be either the HTTPS URL or the S3 URL. URL length is limited to a maximum of 236 characters.

URLs should contain only ASCII characters, 0x01 to 0x7F.

delimiter

Specifies the column delimiter character.

Default value: | (vertical bar)

multipart

Deprecated; has no effect.

chunksize

Specifies in bytes the maximum size of each part. Valid settings can range between 5 MB and 5 GB.

The maximum number of chunks allowed in an export is 10000.

Default value: 10485760

record_terminator

Specifies what character marks the end of a record.

Default value: \n

from_charset

Specifies the character set in which your data is currently encoded.

to_charset Specifies the character set in which you want to encode your export.
prepend_hash

Prepends the unique hash values assigned to exported objects instead of the standard appendation.

If your S3 bucket contains a period in its path, set the prepend_hash parameter to true.

Default value: false

from_charset and to_charset values are system-dependent. Refer to your operating system documentation for more details.

Examples

Export column1 data from exampleTable:

=> SELECT s3export(column1 USING PARAMETERS 
    url='s3://exampleBucket/object', 
    delimiter=',',
    chunksize='10485760',
    record_terminator='\n', 
    from_charset='ASCII',
    to_charset='UTF-8', 
    prepend_hash='true') 
OVER () FROM exampleTable;

See Also