Oracle to Hive datatype Mapping
This table identifies the the Oracle datatype, Replication Definition datatype, and the Hive datatype.
| Oracle datatype | Replication Definition datatype | Hive datatype |
|---|---|---|
| Integer | rs_oracle_decimal | double |
| Number | rs_oracle_decimal | double |
| Number(10) - Number(18) | rs_oracle_decimal | Bigint |
| Number(5) - Number(9) | rs_oracle_decimal | int |
| Number(2) - Number(4) | rs_oracle_decimal | smallint |
| Number(P,S) | rs_oracle_decimal/varchar | decimal/varchar |
| Number(1) | rs_oracle_decimal | tinyint |
| FLOAT | rs_oracle_float | double |
| BINARY_FLOAT | rs_oracle_float | double |
| BINARY_DOUBLE | rs_oracle_decimal | double |
| DATE | rs_oracle_datetime | timestamp |
| TIMESTAMP(N) | rs_oracle_timestamp9 | timestamp |
| CHAR | Char | varchar |
| NCHAR | Unichar | varchar |
| VARCHAR2 | Varchar | varchar |
| NVARCHAR | univarchar | varchar |
| NVARCHAR2 | univarchar | varchar |
| BLOB | image | No Default |
| BFILE | image | No Default |
| NCLOB | unitext | No Default |
| INTERVAL | rs_oracle_interval | No Default |
| ROWID | rs_oracle_rowid | No Default |
| UROWID | rs_oracle_rowid | No Default |
| TIMESTAMP with time zone | rs_oracle_timestamptz | No Default |
| TIMESTAMP with local time zone | rs_oracle_timestamp9 | No Default |
| ANYDATA | opaque | No Default |
| VARRAY | opaque | No Default |
| NESTEDTAB | opaque | No Default |
| Object | opaque | No Default |
| REF | rs_oracle_binary | No default |
| RAW | rs_oracle_binary | binary |
Note When no default value is provided, the successful replication of the Oracle type requires
you to choose the customization tool of your choice to map to the Hive datatype
based on your business needs. Refer to Oracle Datatype Compatibility
and Oracle Datatype Restrictions of the Replication Agent Primary
Database Guide for additional Oracle datatype information.