...
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.
...