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 |
|---|---|---|
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 |
|---|---|
File Path |
|
Delimiter for the input file |
|
Username |
|
Password |
|
Connection String |
|
Select Statement |
|