Mapping Between MySQL and MRS 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 MySQL to Hudi.

**Table 1** Field types supported by a job that migrates data from MySQL to Hudi
Type	MySQL Data Type	Hudi Data Type	Description
String	CHAR(M)	STRING	N/A
String	VARCHAR(M)	STRING	N/A
Value	BOOLEAN	BOOLEAN	N/A
	TINYINT	INT	By default, TINYINT(1) is converted to BOOLEAN. If you want to keep it as TINYINT(1), add the following attribute to the MySQL data connection in Management Center: tinyInt1isBit = false
	TINYINT UNSIGNED	INT	N/A
	SMALLINT	INT	N/A
	SMALLINT UNSIGNED	INT	N/A
	MEDIUMINT	INT	N/A
	MEDIUMINT UNSIGNED	BIGINT	N/A
	INT	INT	N/A
	INT UNSIGNED	BIGINT	N/A
	BIGINT	BIGINT	N/A
	BIGINT UNSIGNED	DECIMAL(20,0)	N/A
	REAL	Not supported	N/A
	DECIMAL(M,D)	DECIMAL(38,10)	N/A
	NUMBERIC	Not supported	N/A
	FLOAT(M,D)	FLOAT	N/A
	DOUBLE(M,D)	DOUBLE	N/A
	DOUBLE PRECISION	DOUBLE	N/A
Bit	BIT(M)	Not supported	N/A
Date and time	DATE	DATE	N/A
	TIME	STRING	N/A
	DATETIME	TIMESTAMP	N/A
	TIMESTAMP	TIMESTAMP	N/A
	YEAR(M)	STRING	N/A
Multimedia (binary)	BINARY(M)	Not supported	N/A
	VARBINARY(M)	Not supported	N/A
	TEXT	STRING	N/A
	TINYTEXT	STRING	N/A
	MEDIUMTEXT	STRING	N/A
	LONGTEXT	STRING	N/A
	BLOB	Not supported	N/A
	TINYBLOB	Not supported	N/A
	MEDIUMBLOB	Not supported	N/A
	LONGBLOB	Not supported	N/A
Special type	SET	Not supported	N/A
	JSON	STRING	N/A
	ENUM	Not supported	N/A