Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

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.

...