Help Center/ DataArts Studio/ User Guide/ DataArts Migration (Real-Time Jobs)/ Field Type Mapping/ Mapping Between Oracle and MRS Hudi Field Types

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

View PDF

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

Parent topic: Field Type Mapping

Previous topic: Mapping Between SQL Server and Hudi Field Types

Next topic: Mapping Between Oracle and Doris Field Types

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.