R and Vertica Data Types

The following data types are supported when passing data to/from an R UDx:

Vertica Data Type R Data Type

BOOLEAN

logical

DATE, DATETIME, SMALLDATETIME, TIME, TIMESTAMP, TIMESTAMPZ, TIMETZ

numeric

DOUBLE PRECISION, FLOAT, REAL

numeric

BIGINT, DECIMAL, INT, NUMERIC, NUMBER, MONEY

numeric

BINARY, VARBINARY

character

CHAR, VARCHAR

character

NULL values in Vertica are translated to R NA values when sent to the R function. R NA values are translated into Vertica null values when returned from the R function to Vertica.

When specifying LONG VARCHAR or LONG VARBINARY data types, include the space between the two words. For example, datatype = c("long varchar").