Vertica Datatype Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

Vertica Datatype Mapping

  • Dark
    Light
  • PDF

We match Vertica data types to Rivery 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 Rivery-compatible types:

Vertica Type Rivery 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

Was this article helpful?