Column Mapping

Invariant Discovery supports the following datatypes from relational databases to Hive

DB2 to Hive mapping

DB2 datatype	Hive datatype
CHAR	STRING
VARCHAR	STRING
INT	INT
DECIMAL	DECIMAL
DATE	DATE
TIMESTAMP	TIMESTAMP
XML	XML

SQL Server to Hive mapping

SQL Server datatype	Hive datatype
CHAR, NCHAR	STRING
VARCHAR, NVARCHAR	STRING
INT, SMALLINT, TINYINT	INT
BIGINT	BIGINT
DECIMAL	DECIMAL
DATE	DATE
DATETIME, DATETIME2	TIMESTAMP
MONEY, SMALLMONEY	DECIMAL