Vertica Bulk Export Action (Deprecated)

This plugin is no longer available as of July 26, 2024.

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



Created in 2020 by Google Inc.