Vertica Bulk Export Action

The Vertica Bulk Export action plugin is available in the Hub.

Bulk exports data in a Vertica table into a file.

Vertica Bulk Export Action plugin gets executed after a successful MapReduce or Spark job. It executes a select query on a Vertica table and writes the results in a provided file location in csv format.

Configuration

Property	Macro Enabled?	Description

Property	Macro Enabled?	Description
File Path	Yes	Required. HDFS File path where exported data will be written.
Delimiter for the input file	Yes	Optional. Delimiter in the output file. Values in each column is separated by this delimiter while writing to output file. Default is , (comma).
Username	Yes	User identity for connecting to the specified database. Required for databases that need authentication. Optional for databases that do not require authentication.
Password	Yes	Password to use to connect to the specified database. Required for databases that need authentication. Optional for databases that do not require authentication.
Connection String	Yes	Required. JDBC connection string including database name.
Select Statement	Yes	Optional. Select command to select values from a Vertica table.

Example

This example connects to a Vertica database using the specified Connection String, which means it will connect to the 'test' database of a Vertica instance running on 'localhost' and run the select query. This plugin will read all the columns as String and write to file /tmp/vertica/vertica_export.csv on HDFS. We can also specify column delimiter which is common in below properties.

Property	Value

Property	Value
File Path	`/tmp/vertica/vertica_export.csv`
Delimiter for the input file	`,`
Username	`username`
Password	`password`
Connection String	`jdbc:localhost:5433/test`
Select Statement	`Select * from testTable`