A Column Mapping

Oracle GoldenGate supports the Hive column mapping to various datatypes, such as Oracle, SQL Server.

This appendix contains the following topics:

Oracle Data Type to Hive Mapping

Oracle Datatype Oracle GoldenGate Veridata Format Hive Datatype
CHAR, NCHAR String CHAR
VARCHAR, NVARCHAR String VARCHAR
LONGRAW, BLOB Blob BINARY
RAW Binary BINARY
FLOAT, BINARY_FLOAT Float FLOAT
BINARY_DOUBLE Binary DOUBLE
DATE Date DATE
TIMESTAMP Timestamp TIMESTAMP
LONG, CLOB, NCLOB Clob STRING

SQLServer to Hive Mapping

SQLServer Datatype Oracle GoldenGate Veridata Format Hive Data type

BIGINT,

BIT,

INT,

SMALLINT

TINYINT

numeric

TINYINT,

SMALLINT,

INT,

BIGINT

DECIMAL,

MONEY,

SMALLMONEY

dec_float

DECIMAL

FLOAT

float

FLOAT

REAL

float

DOUBLE

CHAR,

NCHAR,

string

CHAR

VARCHAR,

NVARCHAR,

string

VARCHAR

STRING

TEXT,

NTEXT

clob

STRING

BINARY,

VARBINARY

binary

BINARY

IMAGE

blob

BINARY

DATE

date

DATE

DATETIME,

DATETIME2,

SMALLDATETIME,

DATETIMEOFFSET

timestamp

TIMESTAMP

TIME

time

TIMESTAMP