Oracle to Hive Data Type Conversions

Table 8-1 Oracle to Hive Data Type Conversions

Oracle Data Type	Hive Data Type
NUMBER	INT when the scale is 0 and the precision is less than 10 BIGINT when the scale is 0 and the precision is less than 19 DECIMAL when the scale is greater than 0 or the precision is greater than 19
BINARY_DOUBLE	DOUBLE
BINARY_FLOAT	FLOAT
CHAR NCHAR	CHAR
VARCHAR2 NVARCHAR2	VARCHAR
DATE	TIMESTAMP
TIMESTAMP	TIMESTAMP
TIMESTAMPTZFoot 1  TIMESTAMPLTZ	Unsupported
RAW	BINARY

Reference : https://docs.oracle.com/cd/E63064_01/doc.42/e63062/copy2bda.htm#BIGUG76752