Updated on 2025-07-25 GMT+08:00

Mapping Between Oracle 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 Oracle to Hudi.

Table 1 Field types supported by a job that migrates data from Oracle to Hudi

Oracle Data Type

Hudi Data Type

char

STRING

varchar

STRING

varchar2

STRING

nchar

STRING

nvarchar2

STRING

raw

STRING

number

STRING/DECIMAL

decimal

STRING/DECIMAL

float

FLOAT

binary_float

FLOAT

binary_double

DOUBLE

date

TIMESTAMP

timestamp

TIMESTAMP

timestamp with time zone

STRING

timestamp with local time zone

STRING