Microsoft SQL Server

The following table describes the data movement, data domain profiling, and data masking operations that you can perform on the Microsoft SQL Server data types when the target is Hive or HDFS:

Data Types	HIVE	HDFS	Comments
Bigint	Yes	Yes
Binary	Yes	No
Bit	Yes	Yes
Char	Yes	Yes
Datetime	Yes	Yes
Datetime2	Yes	Yes
Datetimeoffset	Yes	Yes
Decimal	Yes	Yes	You can enter a precision value up to 28.
Float	Yes	Yes	You can enter a precision value up to 28.
Image	Yes	No
Int	Yes	Yes
Money	Yes	Yes
Nchar	Yes	Yes
Ntext	Yes	Yes
Numeric	Yes	Yes	You can enter a precision value up to 28.
Nvarchar	Yes	Yes
Real	Yes	Yes
Smallint	Yes	Yes
Smallmoney	Yes	Yes
Text	Yes	Yes
Tinyint	Yes	Yes
Varbinary	Yes	No
Varchar	Yes	Yes

When the target is Hive or HDFS, you cannot perform data movement, data domain profiling, and data masking operations on the following Microsoft SQL Server data types: