A Column Mapping
Oracle GoldenGate supports the Hive column mapping to various datatypes, such as Oracle, SQL Server.
This appendix contains the following topics:
A.1 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 |
A.2 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 |