C++ SDK Data Types

The Vertica SDK has typedefs and classes for representing Vertica data types within your UDx code. Using these typedefs ensures data type compatibility between the data your UDx processes and generates and the Vertica database. The following table describes some of the typedefs available. Consult the VerticaC++ SDK Documentation for a complete list, as well as lists of helper functions to convert and manipulate these data types.

Type Definition Description

Interval

A Vertica interval

IntervalYM

A Vertica year-to-month interval.

Timestamp

A Vertica timestamp

vint

A standard Vertica 64-bit integer

vint_null

A null value for integer values

vbool

A Boolean value in Vertica

vbool_null

A null value for a Boolean data types

vfloat

A Vertica floating point value

VString

String data types (such as varchar and char)

Note: Do not use a VString object to hold an intermediate result. Use a std::string or char[] instead.

VNumeric

Fixed-point data types from Vertica

Notes