Vertica datatype mapping
We match Vertica data types to Data Integration data types while extracting your data. If a data type is not supported, we will map it as a String type.
The following table shows the mapping of Vertica data types to Data Integration-compatible types:
| Vertica Type | Data Integration Type |
|---|---|
| BINARY | STRING |
| VARBINARY | STRING |
| LONGVARBINARY | STRING |
| BYTEA | STRING |
| RAW | STRING |
| BOOLEAN | BOOLEAN |
| CHAR | STRING |
| VARCHAR | STRING |
| LONGVARCHAR | STRING |
| VARCHAR2 | STRING |
| TEXT | STRING |
| UUID | STRING |
| DATE | DATE |
| DATETIME | TIMESTAMP |
| SMALLDATETIME | TIMESTAMP |
| TIME | TIMESTAMP |
| TIMETZ | STRING |
| TIMEWITHTIMEZONE | TIMESTAMP |
| TIMESTAMP | TIMESTAMP |
| TIMESTAMPTZ | STRING |
| TIMESTAMPWITHTIMEZONE | TIMESTAMP |
| INTERVAL | TIMESTAMP |
| FLOAT | FLOAT |
| FLOAT8 | FLOAT |
| DOUBLE | FLOAT |
| REAL | FLOAT |
| INT | INTEGER |
| INTEGER | INTEGER |
| INT8 | INTEGER |
| BIGINT | INTEGER |
| SMALLINT | INTEGER |
| TINYINT | INTEGER |
| NUMERIC | INTEGER |
| DECIMAL | FLOAT |
| NUMBER | FLOAT |
| MONEY | STRING |
