Mapping Between SQL Server and Hudi Field Types

DataArts Migration converts the source field type to the destination field type based on the default rule, and creates tables and synchronizes data in real time.

Field Type Mapping Rules

The following table lists the field types supported by a job that migrates data from SQL Server to Hudi.

**Table 1** Field types supported by a job that migrates data from SQL Server to Hudi
Type	SQL Server Data Type	Hudi Data Type	Description
String	BINARY	STRING	N/A
	VARBINARY	STRING	N/A
	CHAR	STRING	N/A
	VARCHAR	STRING	N/A
	NCHAR	STRING	N/A
	NVARCHAR	STRING	N/A
	NTEXT	STRING	N/A
	TEXT	STRING	N/A
	IMAGE	STRING	N/A
	XML	STRING	N/A
Value	DECIMAL	DECIMAL	N/A
	NUMERIC	DECIMAL	N/A
	FLOAT	DOUBLE	N/A
	REAL	FLOAT	N/A
	INT	INT	N/A
	BIGINT	BIGINT	N/A
	SMALLINT	INT	N/A
	TINYINT	INT	N/A
	MONEY	DECIMAL(19,4)	N/A
	SMALLMONEY	DECIMAL(10,4)	N/A
	NUMERIC	DECIMAL	N/A
Bit	BIT	STRING	N/A
Date and time	DATE	DATE	N/A
	TIME	STRING	N/A
	DATETIME	STRING	N/A
	DATETIME2	STRING	N/A
	SMALLDATETIME	STRING	N/A
	DATETIMEOFFSET	STRING	N/A