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

Vertica Datatype Mapping

  • Dark
    Light
  • PDF

Article summary

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 TypeRivery Type
BINARYSTRING
VARBINARYSTRING
LONGVARBINARYSTRING
BYTEASTRING
RAWSTRING
BOOLEANBOOLEAN
CHARSTRING
VARCHARSTRING
LONGVARCHARSTRING
VARCHAR2STRING
TEXTSTRING
UUIDSTRING
DATEDATE
DATETIMETIMESTAMP
SMALLDATETIMETIMESTAMP
TIMETIMESTAMP
TIMETZSTRING
TIMEWITHTIMEZONETIMESTAMP
TIMESTAMPTIMESTAMP
TIMESTAMPTZSTRING
TIMESTAMPWITHTIMEZONETIMESTAMP
INTERVALTIMESTAMP
FLOATFLOAT
FLOAT8FLOAT
DOUBLEFLOAT
REALFLOAT
INTINTEGER
INTEGERINTEGER
INT8INTEGER
BIGINTINTEGER
SMALLINTINTEGER
TINYINTINTEGER
NUMERICINTEGER
DECIMALFLOAT
NUMBERFLOAT
MONEYSTRING

Was this article helpful?