R and Vertica data types
The following data types are supported when passing data to/from an R UDx:.
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, TIMESTAMPTZ, 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.
Important
When specifying LONG VARCHAR or LONG VARBINARY data types, include the space between the two words. For example,datatype = c("long varchar").