Classes · 1 min read

VerticaBulkInsertMapItem

A mapping class used to define a column mapping, with an optional explicit VerticaType, for the Vertica bulk operations.

This class extends BulkInsertMapItem with an optional, explicit VerticaType to bind with for the mapped column. It is not currently consumed by the COPY-stream-based bulk-copy implementation — Vertica’s COPY parser infers each field’s wire format from the destination column’s actual server-side type — so it is kept only as a forward-looking escape hatch, matching the equivalent parameter on every other bulk-operations package’s map-item type.

Used by the Vertica BulkInsert, BulkMerge and BulkUpdate operations.

Create a new Instance

var mapItem = new VerticaBulkInsertMapItem("SourceId", "DestinationId");

Or with an explicit VerticaType:

var mapItem = new VerticaBulkInsertMapItem("SourceName", "DestinationName", VerticaType.VarChar);

Usage for BulkOperations

var mappings = new []
{
    new VerticaBulkInsertMapItem("FirstName", "FName"),
    new VerticaBulkInsertMapItem("LastName", "LName")
};

using (var connection = new VerticaConnection(connectionString))
{
    var people = GetPeople(100000);
    connection.BulkInsert(people, mappings: mappings);
}

The same approach applies to BulkMerge and BulkUpdate. The mappings argument is optional — omitting it causes the library to auto-map columns by name (case-insensitive).