[MAPREDUCE-775] Add input/output formatters for Vertica clustered ADBMS.

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.21.0
• Component/s: contrib/vertica
• Hadoop Flags: Reviewed
• Release Note: Add native and streaming support for Vertica as an input or output format taking advantage of parallel read and write properties of the DBMS.
• Tags: vertica, db, formatter
• Assignee: Omer Trajman
• Reporter: Omer Trajman
• Created: 20/Jul/09 23:34
• Updated: 24/Aug/10 21:14
• Resolved: 18/Sep/09 18:24

Description

Add native support for Vertica as an input or output format taking advantage of parallel read and write properties of the DBMS.

On the input side allow for parametrized queries (a la prepared statements) and create a split for each combination of parameters. Also support the parameter list to be generated from a sql statement. For example - return metrics for all dimensions that meet criteria X with one input split for each dimension. Divide the read among any number of hosts in the Vertica cluster.

On the output side, support Vertica streaming load to any number of hosts in the Vertica cluster. Output may be to a different cluster than input.

Also includes Input and Output formatters that support streaming interface.

Code has been tested and run on live systems under 19 and 20. Patch for 21 with new API will be ready end of this week.